by COBS Tech Support » Mon Nov 18, 2013 7:47 am
Your script might work but the syntax is ambiguous so it may also not work.
To make the script clearer to the interpreter it's recommended to specify the table you are referencing.
I.e.,
OpenTable("Supplier")
Supplier->(Find(Upper(SCCRead("Name2"))))
You can use GetField() like so:
x := GetField("Purchdisc", "Supplier"))
Or just do this:
nNewList := nCost * Supplier->Purchdisc
If you want to access a database field, then the syntax is:
TableName->XXXX
If you want a function or expression to look at a particular table, then surround the function or expression with round brackets like so:
TableName->(<expression>)