With datastore you can store any data in the memory or can save it back to the database
datastores are very simple to use
declare datastore with the name lds
instance datastore lds
read data from database
lds=select ....
destroy (very important)
destroy=lds
You can access the values with Place holders <objectname.spaltenname> and / or within the multi mode with <datastorename.spaltenname> (inside the Multimode you need to provide the objectname.
Set a field with a value:
objectname.columnname.value=<value>
Get a field value:
messagebox=<objectname.columnname.value>
The attribute "value" is not compelling on this occasion
Example:
instance datastore lds
// we don't use "select *"
// faster is command "select (fieldfrom="tablename") ..."
lds=select (fieldfrom="OITM") from "OITM"
// go to first row
lds.setrow=1
if <lds.itemcode.value> = "myitem" then
lds.u_beas_match.value=yes
end if
destroy=lds
Videos
Display content of a datastore
Commands:
Methode |
Description |
|
---|---|---|
multimode=<0/1> |
|
|
select=<sqlstatement> |
|
|
bsl=<odata get command> |
|
|
execute <procedure> |
|
|
add=<sql> add=<psr-file> |
|
|
setrow=<row> |
Set actual row |
|
setrow=-x,+x,top,buttom setrow=<loop> setrow=+5 setrow=tomtom=10 |
|
|
destroy |
Destroy all Datastores |
|
dir=<director> |
|
|
sort=<sortarguments> |
Sort the Datastore lds=sort=itemcode d |
|
filter=<arguments> |
Filter the Datastore lds=filter=substring(itemcode,1,1)='1' |
|
find=<argument> |
|
|
insertrow |
Insert a row the then end end set the Cursor on that row |
|
deleterow |
Delete the current row and set the cursor to the next row. lds=deleterow |
|
setitem=<colname>=<value> |
Set Item. lds=setitem=itemname=hello |
|
rowscopy=<datasdlatore> |
|
|
rowscopytodwx=<dw_x> |
copy datastore in datawindow dw_x lds=rowscopytodwx=dw_1 |
|
updatetable=<table> updatetable=<table[,primary[,primary]]> |
|
|
update |
Updates the DataStore |
Methode |
Description |
|
---|---|---|
addfield=fieldname=length=typ |
Add a field to the Datastore |
|
fieldreset |
reset all fields which has been declared with "addfield" |
|
getparent=<datastorename>
|
get reference datastorevalue from parent window instance datastore mydts mydts=getparent=mydtsfromparentwindow
|
|
getparentcopy=<datastorevalue> |
get copy from parent datastorevalue declare=mydts=ue_datastorevalues mydts=getparentcopy=mydtsfromparentwindow |
|
blobread=<id> |
|
|
blobwrite=<id>=<filename> |
|
Methode |
Description |
|||
saveas=<typ>=<filename> |
Export the DataStore into value or file in different formats |
|||
importfromfile=<filename> |
|
|||
importfromdbfile |
|
|||
importfromexcel |
|
|||
importfromxml=<filename>[<tab>Properties] importfromfile=<filename>[<tab>Properties] |
|
|||
importfromxmlstring=<string> |
Import from string. Format see importfromxml |
|||
importdbstring=<dbstring> |
Import from string in Datastore from Format "dbstring" return errormessage in "value". If empty, all is ok example: lds1.saveas=dbstring lds2.importdbstring=<value> |