Dynamic execution of an .sql file -
07-19-2004
, 03:38 AM
Hi Everybody..
I'd like to execute a .sql file from my PowerBuilder application.
pick up the location of the file from the .ini file and then construc
a string variable containing the same. Eg 'C:\Scripts\scr.sql'. Now
need to run this on a Sybase database. I do so by the following--Rea
'C:\Scripts\scr.sql';
When I carry on this operation from the PowerBuilder code..usin
Execute Immediate :<var_name>; I get an SQL error. The error # i
SQLSTATE=37000 Syntax error or Access violation.
Can you please suggest as to how do I run a .sql file from the PB fro
end tool.
Thanks a zillion
Vima
-
vima
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message313190.htm |