Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to set the value of a variable to the value of a field loaded from a qvd?
e.g.
LOAD
field1
FROM
file.qvd;
SET variable = field1;
When I do this the variable returns the text field1 as opposed to the value in field1.
You need to use the PEEK-command, like
SET variable = PEEK('field1', 0, 'MyTable')
This would load the first record, you may sort the table accordingly or create a special table with MIN- or MAX-values.
HTH
Peter
You need to use the PEEK-command, like
SET variable = PEEK('field1', 0, 'MyTable')
This would load the first record, you may sort the table accordingly or create a special table with MIN- or MAX-values.
HTH
Peter
Thank you.
Hi Peter, I am using the LET variable = PEEK('field1', 0, 'MyTable') syntax for a field that has only one value and row. For some reason it is not giving a value for the variable. Am I missing something?