i 'm writing the following script. It gives the following error when i insert the the conditions in the where clause.

SQLState 42I03: Unknown column 'inlet' (error 302)


the code is attached.

the table tdpsl006 index 2 has the following domains and it contains 5 fields:

tcmcs.str3
tcargl - float type for the remaining 4 fields

I think you Need to post this in "Tools" Sections not in General discussion or in blogs !!

To use a program variable in a select statement, they have to be proceeded by a colon ":", otherwise it is considered a table field.

Thread moved