(RPG) Offline : How to access local table
Posted: Wed Mar 04, 2015 3:53 pm
Hi,
I'm working on an offline form and I just want to check if a local table or a record in a local table exists or not. The local table is not bound to any form fields. I've checked the Offline examples but can only find SQL that are bound to form fields.
1. Is there a way to simply use the SQL statement (without having them bound to a form field) to access a local table or is this only possible through the use of ECL JScript?
2. Is it possible to use the /DB.Tr.BATCHROWCOUNT property to check for a record in a local table? Or is this solely for upload/download use?
3. Is it possible to use EZI_OffLine_GetTableInfo and EZI_OffLine_GetRowDetails for this? Or is this (again) for upload and download use only?
I'm trying to look for something similar in the examples but could not find any. Any help would be greatly appreciated.
Thanks,
Rocel
I'm working on an offline form and I just want to check if a local table or a record in a local table exists or not. The local table is not bound to any form fields. I've checked the Offline examples but can only find SQL that are bound to form fields.
1. Is there a way to simply use the SQL statement (without having them bound to a form field) to access a local table or is this only possible through the use of ECL JScript?
2. Is it possible to use the /DB.Tr.BATCHROWCOUNT property to check for a record in a local table? Or is this solely for upload/download use?
3. Is it possible to use EZI_OffLine_GetTableInfo and EZI_OffLine_GetRowDetails for this? Or is this (again) for upload and download use only?
I'm trying to look for something similar in the examples but could not find any. Any help would be greatly appreciated.
Thanks,
Rocel