Search found 16 matches

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: 913

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: 1058

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: 880

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: 880

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: 889

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: 889

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: 889

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: 1182

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: 1182

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: 1182

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: 707

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: 1883

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: 1883

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: 1883

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...
by eddie9394
Fri Sep 21, 2018 6:46 am
Forum: Questions & Answers
Topic: Cannot read property 'mthREMOVEFIRST' of null
Replies: 6
Views: 1883

Cannot read property 'mthREMOVEFIRST' of null

I am trying to close the framework command window after a delete operation. I had tried #COM_Owner, #COM_Self and #COM_Ancestor avCloseForm. All yield to the same error message below: Fatal Error: Cannot read property 'mthREMOVEFIRST' of null Location: Reusable Part: CMGEXCDetailCommand, line 945 Ca...
by eddie9394
Wed Aug 15, 2018 12:19 am
Forum: Questions & Answers
Topic: Missing #DF_SLIDLB in SP2
Replies: 2
Views: 898

Missing #DF_SLIDLB in SP2

I am new to LANSA, we did a fresh install of SP2 on my machine, after initializing the partition and pull everything down from the repository, our team discovered that the #DF_SLIDLB is missing on my machine. Any body know an easy way to fix this? Is this a bug in SP2 or just me?!