unspecified error & command text was not set for the command object

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
laknabu

unspecified error & command text was not set for the command object

Post by laknabu » Sat 28 May 2005 13:39

i use t msquery and do some master-detail everything working fine, but often got this message : "unspecified error" or "command text was not set for the command object" any one knowing what's going on ?
TIA.
cheers,
laknabu

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 30 May 2005 06:55

Please supply us following information.

- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in Info sheet of TMSConnection Editor
- If it is possible send small test project to reproduce the problem;
it is desirable to use Northwind or Master schema objects otherwise include
definition of your own database objects; don't use third party components

laknabu

tengqu b4

Post by laknabu » Mon 30 May 2005 08:45

tengqu for ur help, we use :

- Exact version of Delphi or C++ Builder
delphi 7.1
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
SDAC 3.50.00.11
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in Info sheet of TMSConnection Editor
Microsoft SQL Server: 08.00.0194
Microsoft OLE DB Provider for SQL Server: 08.00.1111
- If it is possible send small test project to reproduce the problem;
unfortunatelly we use TcxDBextLookup from Developer Express, the error happen if we scrolling TcxDBextLookup, we suspicous error when there's no detail field this error will appear.is it problem ?.
what error if "Unspecified Error" or what's the problem if "command text was not set for the command object".

tengqu for the help, i really apreciate ur help :)

cheers,
laknabu

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 30 May 2005 09:52

Try to reproduce the problem without using DevExpress components.
According to error message the problem is in incorrect using multi-threading on retrieving values for Lookup-fields.

laknabu

tengqu

Post by laknabu » Mon 30 May 2005 10:05

Ikar wrote:Try to reproduce the problem without using DevExpress components.
According to error message the problem is in incorrect using multi-threading on retrieving values for Lookup-fields.
tengqu for ur help, i'll try it....
TIA
cheers,
laknabu

Guest

Re: tengqu b4

Post by Guest » Wed 28 Sep 2005 09:51

laknabu wrote:tengqu for ur help, we use :

- Exact version of Delphi or C++ Builder
delphi 7.1
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
SDAC 3.50.00.11
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in Info sheet of TMSConnection Editor
Microsoft SQL Server: 08.00.0194
Microsoft OLE DB Provider for SQL Server: 08.00.1111
- If it is possible send small test project to reproduce the problem;
unfortunatelly we use TcxDBextLookup from Developer Express, the error happen if we scrolling TcxDBextLookup, we suspicous error when there's no detail field this error will appear.is it problem ?.
what error if "Unspecified Error" or what's the problem if "command text was not set for the command object".

tengqu for the help, i really apreciate ur help :)

cheers,
laknabu

Post Reply