isql

Contents

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"});

applicationisql

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