As of DesignTime revision 2096 the RunQuery page on the IDE has been split into two separate pages: Read Database Records and Change Database Records.
- RunQueryHome.PNG (16.39 KiB) Viewed 9230 times
- RunQueryHome.PNG (16.39 KiB) Viewed 9230 times
The Read Database Records page allows the user to run parameterized select queries to tables across all their applications by selecting an Instance, Table Path, and then the Table Name.
After running the query they can add specific keys and results, otherwise it will just return all records.
- ReadRecords.PNG (46.93 KiB) Viewed 9230 times
- ReadRecords.PNG (46.93 KiB) Viewed 9230 times
The Change Database Records page allows the user to Insert, Update, Upsert, or Delete records by selecting an Instance, Type, Table Path, and Table Name. Then the users downloads an xslx file and adds the database records to that. Users can download from the Read Database Records in order to easily retrieve the needed records.
- ChangeRecords.PNG (22.93 KiB) Viewed 9230 times
- ChangeRecords.PNG (22.93 KiB) Viewed 9230 times
Translation