Well guys and girls, I did the batchfile option and offcorse that works. I had made objects anyways so it was not that much work changing things so it made and used batch files.
This thread is solved but the TShellExecute not working with large params I guess is not.
Thanks for your input...
Well the thing is that you can run the BCP from a command window. I did this by opening a command window adding BCP after the prompt and then copy and paste the big query with all of its params after the BCP and pressing Enter. It works like a charm then. So the problem seems to be TShellExecute...
ShellExecute the SQLServer BCP Utility does not work with large lpParams
Hi all,
What I'm trying to do is the following:
(BCP Utility is a SQLserver program to import and export data to/from a SQLServer database).
ShellExecute(0, 'Open', PChar('<path>\bcp.exe'), PChar(<some big querry...
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.