This method execute sql command and display this in a new window as result
This is a very simple variant to display sql results
application.isql(String SqlCommand);
application.isql(objects properties);
example:
#jbs
// Very simple variant: only sql statement
application.isql('select "ItemCode","ItemName","OnHand" from "OITM"');
#jbs
// by object: you can define more properties.
application.isql({sql:'select "ItemCode","ItemName","OnHand" from "OITM"',title:"my window"});
if you define an object as argument, the system will replace the titles with the standard description, otherwise with the field name from sql command
Follow properties supported
Property |
Description |
---|---|
sql |
the sql command or procedure call |
title |
title of the window |
name |
name of the window if you change it, you can work with customizing, example with B1UP, because all changes related to this window name |
master |
Script (beas script) for master area |
init |
add Script (beas script) for init area |
script |
add Script (beas script) for "after retrieve" |
Note: for windows with more functionality see new form