Search found 22 matches

by eddie9394
Fri Oct 25, 2019 4:07 am
Forum: Questions & Answers
Topic: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Replies: 3
Views: 85

Re: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?

Thanks for the help!

Yes, I did have double quotes around the description. Please refer to the uploaded screen snip.

You suggested something else is wrong, where should I start the search?! :idea: :?:
by eddie9394
Thu Oct 24, 2019 2:11 am
Forum: Questions & Answers
Topic: How to deal with comma in description when using TRANSFORM_FILE to read CSV file?
Replies: 3
Views: 85

How to deal with comma in description when using TRANSFORM_FILE to read CSV file?

I am using the TRANSFORM_FILE to read a CSV file into a list, it works fine most of the time, but when there is a comma in the description field, it will shift everything off, I try to double-quote the description field and it is not working. Is there any way to deal with this issue?
by eddie9394
Fri Oct 18, 2019 7:10 am
Forum: Questions & Answers
Topic: Server module returns error but everything seems fine in the log file (RESOLVED)
Replies: 3
Views: 319

Re: Server module returns error but everything seems fine in the log file

Thanks! Found the job log and noticed that the LANSA library was been removed from the CL so when the CL finish, the LDA clean-up was failing. Working perfectly now. Thanks for your help!
by eddie9394
Fri Oct 18, 2019 1:30 am
Forum: Questions & Answers
Topic: Server module returns error but everything seems fine in the log file (RESOLVED)
Replies: 3
Views: 319

Server module returns error but everything seems fine in the log file (RESOLVED)

From the web page, there is a button triggers the server module to create a CSV file on the AS400 and the page is waiting for the completed event to pull it up. The CSV file was created by the CL program and the log file shows that the execution completed normally. But it returns the following error...
by eddie9394
Wed Oct 02, 2019 5:37 am
Forum: Questions & Answers
Topic: DELETE from file with substring selection not working (RESOLVED)
Replies: 4
Views: 221

Re: DELETE from file with substring selection not working

Thank you! Got it to work with Select and Delete...... :D
by eddie9394
Tue Oct 01, 2019 2:12 am
Forum: Questions & Answers
Topic: DELETE from file with substring selection not working (RESOLVED)
Replies: 4
Views: 221

DELETE from file with substring selection not working (RESOLVED)

Delete From_File(CF1234) Where((#DTEDATE = #wk_date) *And (#DTRECTYP = "RC") *And (#DTCMR = "M") *And (#DTPCDE = *Blanks) *And (#DTDESC.Substring( 1 8 ) = "<*ERROR*")) Io_Error(*NEXT) The above statement is not working, I did a SQL delete it work Delete from cf1234 where dtedate=20191001 and DTRECTY...
by eddie9394
Tue Aug 13, 2019 12:55 am
Forum: Questions & Answers
Topic: Can I call a Stored Procedure on IBMi via SELECT_SQL and share a result set ?
Replies: 2
Views: 998

Re: Can I call a Stored Procedure on IBMi via SELECT_SQL and share a result set ?

Any luck on getting the stored procedure call to work? I try to do the same thing but end up with the ultimate decimal 3 error. the SQL procedure works fine on both "SQL-Scripts" and "STRSQL".
by eddie9394
Thu Oct 18, 2018 2:52 am
Forum: Questions & Answers
Topic: User Name changed to DCXPGMLIB when Calling RPG
Replies: 2
Views: 1110

User Name changed to DCXPGMLIB when Calling RPG

I have a Server Module that create transaction records then call a function (to call a RPG program) to generate GL entries. Everything works fine except records generated by the RPG program are showing created by "DCXPGMLIB", the transaction records created before the function call in the same serve...
by eddie9394
Wed Oct 17, 2018 1:00 am
Forum: Questions & Answers
Topic: Insert return_rrn not working
Replies: 2
Views: 938

Re: Insert return_rrn not working

yes, records are actually inserted in the table and the field is 15,0. I changed my logic to work around it. However, the Insert with RRN statement should work but it is not! :cry:

I have to use select_SQL using (Select RRN(<File>) from <File> ) to get the RRN
by eddie9394
Sat Oct 13, 2018 1:14 am
Forum: Questions & Answers
Topic: Insert return_rrn not working
Replies: 2
Views: 938

Insert return_rrn not working

I use a insert with return_rrn() hopping to get the RRN of the inserted record, however i am getting the RRN of the first record with the same key. I had changed the SQL_table to allow duplicate keys and removed all the indexes, it is still not working right. Any idea? THANKS! selectlist named(#WRKL...
by eddie9394
Thu Oct 11, 2018 1:47 am
Forum: Questions & Answers
Topic: Using STM_File_Read / Transform_File to process Text file
Replies: 3
Views: 973

Re: Using STM_File_Read / Transform_File to process Text file

Change the #WRKLIST entrys to *max, now the Transform_File works. Bad character issue remain unsolved!
by eddie9394
Thu Oct 11, 2018 1:04 am
Forum: Questions & Answers
Topic: Using STM_File_Read / Transform_File to process Text file
Replies: 3
Views: 973

Re: Using STM_File_Read / Transform_File to process Text file

Mark, Thanks for the Reply! I try removing all the funny characters in the CSV file the STM_File_Read read all the records, but transform_file only read the first 50 records * Transform File use builtin(TRANSFORM_FILE) with_args(#WRKLIST #WK_String1 "OU") to_get(#RETNCODE) #wk_int6 := 0 selectlist n...
by eddie9394
Wed Oct 10, 2018 8:41 am
Forum: Questions & Answers
Topic: Using STM_File_Read / Transform_File to process Text file
Replies: 3
Views: 973

Using STM_File_Read / Transform_File to process Text file

I am using the STM_FILE_Read / Transform_file to read the CSV file and create worklist. I had about 700+ records in the file and it stop at some record with bad data Cafe with the funny E. Any one know how to deal with funny character and force it to continue to read until the true EOF is reach? THA...
by eddie9394
Wed Oct 10, 2018 8:24 am
Forum: Questions & Answers
Topic: file picker and CSV file
Replies: 3
Views: 1260

Re: file picker and CSV file

I end up using BIF Transform_File, it work BUT it didn't process all the records in the CSV file because of funny character in the data content!

use builtin(TRANSFORM_FILE) with_args(#WRKLIST #FileName "O" "B") to_get(#RETNCODE)
by eddie9394
Wed Oct 10, 2018 12:26 am
Forum: Questions & Answers
Topic: file picker and CSV file
Replies: 3
Views: 1260

Re: file picker and CSV file

Thank you for the information! I will continue to play with it.
by eddie9394
Tue Oct 09, 2018 7:57 am
Forum: Questions & Answers
Topic: file picker and CSV file
Replies: 3
Views: 1260

file picker and CSV file

I am working on a project that will allow users to upload a CSV file from their local drive, the server module will save the CSV content to a database table and return a list. What is the best way to do this? When fooling around with the code, I ran into some interesting problem with the file picker...
by eddie9394
Wed Sep 26, 2018 5:07 am
Forum: Questions & Answers
Topic: Tab Order in Detail Command Window
Replies: 1
Views: 743

Tab Order in Detail Command Window

I have 5 input controls in the Detail Command Window, I set the Tab stop from 1 to 5, as I keep pressing the Tab key, it will keep counting up but will not loop back to the first one. Is there any property to set to make it loop back to the first one?
by eddie9394
Mon Sep 24, 2018 11:43 pm
Forum: Questions & Answers
Topic: Cannot read property 'mthREMOVEFIRST' of null
Replies: 6
Views: 1983

Re: Cannot read property 'mthREMOVEFIRST' of null

Yes, did it with a timer. THANKS for your support!
by eddie9394
Sat Sep 22, 2018 5:42 am
Forum: Questions & Answers
Topic: Cannot read property 'mthREMOVEFIRST' of null
Replies: 6
Views: 1983

Re: Cannot read property 'mthREMOVEFIRST' of null

Found my problem! The #COM_OWNER.avCloseForm have to be completely out of scope of the Save.Completed and the avExecuteAsyncOperation
:roll: :roll: :roll:
by eddie9394
Sat Sep 22, 2018 12:42 am
Forum: Questions & Answers
Topic: Cannot read property 'mthREMOVEFIRST' of null
Replies: 6
Views: 1983

Re: Cannot read property 'mthREMOVEFIRST' of null

Mark, Thank you for the reply. I created a simple command with just one button and the avCloseForm works fine, so something in my code is causing the issue. Here is my code please shine some light to it. Again THANK YOU! function options(*direct) begin_com role(*EXTENDS #MGSCommand) height(521) widt...