Visual LANSA Forum

Anyone know the limit on Response.ContentString? When the following server module executes, it generated an error on iSeries job and hangs. The client eventually timed out. And I have to end the job to clear it.
This server module works fine if the result set is less then 25K rows ...

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?!

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?

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!

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 ...

Thank you! Got it to work with Select and Delete......

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 ...

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".

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 ...

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!

I have to use select_SQL using (Select RRN(<File>) from <File> ) to get the RRN

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 ...

Change the #WRKLIST entrys to *max, now the Transform_File works. Bad character issue remain unsolved!

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 ...

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 ...

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)

Thank you for the information! I will continue to play with it.

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 ...

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?

Yes, did it with a timer. THANKS for your support!

Found my problem! The #COM_OWNER.avCloseForm have to be completely out of scope of the Save.Completed and the avExecuteAsyncOperation