Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Bob
>So you are breaking up that long Select SQL into strings not exceeding 255 characters in VFP, concatenating the strings that you pass using SQLEXEC, right?
I understood that to apply to a literal string, ie "select * from " versus
lcSQL = "select * from"
SQLEXEC(...,m.lcSql)
Further, the SQL Profiler tool showed the entire SQL, so nothing got truncated to 255 chars or any multiple of 255. So that should not matter. Agreed?
>
>What version of MS SQL is it?
7
>
>Are you running it the same way with QA with exec()?
I really believe I am. Please provide more details on things to check. I copied the content of lcSQL to the clipboard and then from the clipboard to QA and got different results. I don't know how much more exact I can get than that.
>
>What is the setting of the connection as far as 'fetch data in background' is concerned?
>
>Do you use the same connection (login/password) with sqlexec that is used with the QA?
I believe so. However, what should I check to confirm?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only