I'm trying to create a temp table from an SQL database using a stored procedure (Load-Result-Into).
Using the send-sql-statement with the proc-text buffer is working fine.
However when I try to introduce the load-result-into, I get the most common and annoying syntax error, could not under stand...
Thanks for the info.
We're going to try the var char...
I've done okay with the data server..
I think it just might be better to leave access to the tables in the SQL database and keep using the data server.
Thanks again
Patti
We created a new database and used an ODBC connection to create the
tables.
The char fields now have a "fixc" datatype. I'm trying to re-use some code that was orginally used when we the dataserver odbc to connect to the SQL database.
Now using the new Progress/SQL tables I'm getting lots of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.