I have to upgrade a project written in Borland C++ Builder 3.0 using dWinsock.hpp into a project using BCB 6.0 borland sockets. The poblem I'm running into is this:
in the original code he does:
HAServerSocket->Listen(__classid(TStreamSocket));
then 200 lines later does...
everytime I do a query "select distinct * from [database] INTO [new table]" I get an error "Syntax Error near INTO", even if I put the new table name in single quotes.
I can do a DTS file transfer that uses a select distinct *, but that's it.
Check to see if your target database has any primary key constraints that your source doesn't. It could also be that you're trying to insert an identity key which is not allowed by your schema.
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.