I'm having trouble with syntax in a condition applied to a select statement using SQL (Jetforms) connecting to a progress 91C database through a merant 3.70 Odbc driver on an NT4.0 platform.
I wish to use data entered from another feild as the input for the database lookup.
where item.item = '#another_feild'
the # is not correct for syntax for progress.
I've spent a week searching for information as I expect I will have alot of these type questions and have found no resources.
Any help would be greatly appreciated.
Thanks,
Barry
I wish to use data entered from another feild as the input for the database lookup.
where item.item = '#another_feild'
the # is not correct for syntax for progress.
I've spent a week searching for information as I expect I will have alot of these type questions and have found no resources.
Any help would be greatly appreciated.
Thanks,
Barry