- David Pylatuk
- PowerBuilder
- Thursday, 14 March 2024 01:18 PM UTC
Hello,
I am using PB2022 R3 and have a datawindow with a stored procedure as the source. When I do a retrieve on the datawindow it crashes PowerBuilder. The call to the stored procedure is:
EXECUTE ESS9982 3158069, "2020-01-01" , "@", 0 , "@" , "@" ,"@" ,"@";
When I run this from isql inside Powerbuilder it also fails. When I change the double quotes to single quotes and run it from isql in Powerbuilder it runs perfect.
EXECUTE ESS9982 3158069, '2020-01-01' , '@', 0 , '@' , '@' ,'@' ,'@';
My question is how do I have the datawindow do the same thing... basically put single quotes around the parameters instead of double quotes. Thank you.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.