Devart Forums

If I run the following in Query Analyzer

Insert into W2KServer.TQGLaptop.dbo.IdPhEm
Select top 1000 * from W2KServer.TQGData.dbo.IdPhEm

it works. if i run it in TMSQuery, I get

Command text was not set for the command object

What am I doing wrong?

I am using Delphi 2005 E and SDAC 3.70.0.24 and I just
noticed the about screen says for Delphi 2006!

Do you call Prepare method before executing this query?
Do you set non-default value to TMSQuery.CommandTimeout property?

does the same thing whether or not i call prepare. timeout is zero.
error shows up immediately upon execution. would it have something
to do with accessing two databases at the same time (as what i need
to do eventually is access two different servers at the same time).
thanks.

Please ignore all -- it was, once again , me being stupid.
that query was working fine but the following one was trying
to execute a "blank query". thanks.