Quicklabel PowerForms Bedienungsanleitung PDF herunterladen (Seite 14)

- 14 -

l WhenyouusecommandsINSERT,UPDATEorDELETEthevariablewillcontainthe

numericalvalue,whichrepresentsthenumberoftherowsaffectedbythecommand.

Youcanusethisresultforexecutiontracking.Iftheresultis0,noupdatesweredonein

thedatabase.

l WhenyouusecommandSELECTthevariablewillcontaintheresultreturnedfromthe

databaseserver.

TheresultforSELECTcommandcanbe:

l Value of a single field:inthiscaseyourSQLstatementiswrittentoreturnjustsingle

fieldfromonerecordfield.

Samplestatement:

SELECTMyFieldFROMdbTableWHEREID=1

Result:Ifthereisjustonerecordmatchingtheabovecondition,thevalueofvariable

willbevalueoffieldMyField.

l Values of two or more fields, in one or more records:Inthiscaseadatasetis

returned.Eachlineinthedatasetcontainsdatafromonerecord,fieldsareincludedinthe

line,delimitedbycomma(,).Thefirstlinewillcontainnamesofthefields.Youwill

havetowriteascripttoparsethevaluesintoindividualvalues,ifyouwanttouseindivid-

ualfieldsintheform.

Samplestatement:

SELECT*FROMdbTableWHEREID=1ORID=2

Theresult:

"ID","MyField"

"1","field1"

"2","field2"

Condition:Thisisascriptingbooleanexpression.Onlytworesultsarepossible(TrueandFalse).

Usethisoptiontoenablecurrentactiononlywhensometermismet.Theactionwillbestartedonly

ifconditionreturnsTrueastheresultoftheexpression.

For Every Label

Thepropertydefinesthelistoflabelsforwhichalldefinedactionswillbeexecuted.

Fixed values:Definethelistoflabels.

l Add:Addlabelstothelist.

l Arrow next to the Add button:Addvariablestothelist.Thevariablesmustcontain

thepathandnameofthelabel.

l Delete:Removetheselecteditemfromthelist.

l Arrow buttons:Changetheorderoflabelsinthelist.Thisistheorderinwhichthe

labelsareprinted.

Variable value:Selectonevariablethatwillcontainthepathandnameofthelabel.

Condition:Thisisascriptingbooleanexpression.Onlytworesultsarepossible(TrueandFalse).

Usethisoptiontoenablecurrentactiononlywhensometermismet.Theactionwillbestartedonly

ifconditionreturnsTrueastheresultoftheexpression.

1 2 ... 9 10 11 12 13 14 15 16 17 18 19 ... 46 47

Keine Kommentare

Quicklabel PowerForms Bedienungsanleitung Seite 14