Page 1 of 1
unspecified error & command text was not set for the command object
Posted: Sat 28 May 2005 13:39
by laknabu
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
Posted: Mon 30 May 2005 06:55
by Ikar
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
tengqu b4
Posted: Mon 30 May 2005 08:45
by laknabu
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
Posted: Mon 30 May 2005 09:52
by Ikar
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
Posted: Mon 30 May 2005 10:05
by laknabu
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
Re: tengqu b4
Posted: Wed 28 Sep 2005 09:51
by Guest
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