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?