Parameters without quotes
Posted 27 February 2012 - 12:04 PM
RP_property ,is my parameter.
FROM property_info AS pi
WHERE pi.propertyid = :RP_property
Now if I set RP_property to a valid entry say 001 it works no problem; but if I set it to pi.propertyid ,it returns nothing. It should return the entire table. I don't know if there's a way to show the generated query somehow after all parameters and what not get filled in at run time, so i'm just guessing it's because of some quotes being added.
I'm sure there's an easy work around with the spreadsheet designer/java api i don't know about yet. I'm still rather new in the realm.
Please let me know if you have any suggestions or thoughts!
Posted 29 February 2012 - 07:29 AM