With into command you can define the target variables for sql command
the target-list is between "into" and "from" - all keywords in lowercase.
Correct:
select "ItemCode" into :ls_itemcode from ..
Wrong:
select "ItemCode" INTO :ls_itemcode from .. // uppercase not allowed
select 'hello' into ls_itemcode // keyword "FROM" missing
use as separator a comma
select "ItemCode","ItemName" into ls_itemcode,ls_itemname from "OITM" where "ItemCode"=<itemcode,dbstring>
You can work in Powerbuilder-Syntax with ":" for the target
select "ItemCode","ItemName" into :ls_itemcode,:ls_itemname from ..
or without ":"
select "ItemCode","ItemName" into :ls_itemcode,:ls_itemname from ..
if you will format the result: Write the format after ":"
select sum("OnHand") into ls_onhand:#0 from "OITW" where itemcode=<ls_itemcode,dbstring>
select "ItemName" into ls_itemname:lower from "OITM" where itemcode=<ls_itemcode,dbstring>
you can use as target:
local variable |
local string ls_itemname Format: You can only use the Format after ":", if the source is type "string" Example: select sum("OnHand") into lc_stock:#0.00 from "OITW" where ... is not working. |
instance variable |
instance string ls_itemname Format: You can only use the Format, if the source is type "string". Siee local Variable |
str_parm |
select "ItemName" into str_parm.s_parm1 from oitm where itemcode=<itemcode,dbstring>
|
window variable |
// without declare select "ItemName" into ls_itemname from oitm where itemcode=<itemcode,dbstring> |
column in dw_1 |
set in dw_1 the field "itemname" select "ItemName" into dw_1.item.itemname from oitm where itemcode=<itemcode,dbstring>
example: select stock and set this in dw_2 column "currentstock" select sum("OnHand") into dw_2.item.correntstock from "OITW" where "OITW"."ItemCode"='ls_itemcode,dbstring> with format: ..into itemcode:lower from ... Only in the current row in dw_1. if you want a other row, use ..into dw_1.itemcode:[ll_row] from ... |
dw_1-Column |
|
dw_x in row y |
you can define the row in :row:format if you've no format, set :row:
example: select stock and set this in dw_2 column "currentstock" in row for ll_loop=1 to <dw_2.rowcount>
Short form: You can write: .. into dw_2.item.onhand.value:[row]:format from.. without row and format: .. into dw_2.item.onhand.value from .. without item and value-keyword: .. into dw_2.onhand from .. without item and value-keyword, with row: .. into dw_2.onhand:[row]:format from .. or only format: .. into dw_2.itemname:left 20 from ..
|
Priority:
select search for target-Variable in
1. datawindow (columname or dw_x)
2. str_parm
3. local-Variable
4. instance-Variable
5. window-variable