Re: SELECT query error
- From: "Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx>
- Date: Sun, 26 Feb 2006 13:59:03 +0300
In this syntax ("SELECT Temp( TOTALTIME, DONE, Status )") Temp is parsed as
function that has 3 parameters and its result is treated as 1 field. Correct
SQL syntax is:
SELECT TOTALTIME, DONE, Status ...
or
SELECT Temp.TOTALTIME, Temp.DONE, Temp.Status ...
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"George Kuascha" <gkhokie@xxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:4400c481@xxxxxxxxxxxxxxxxxxxxxxxxx
I get the following error 'number of query values and destination fields
not
the same' on the second line of the following code. I'm using D6 with
MSAccess 2000. What is the cause of this? I can replace with ... SELECT
Temp.TOTALTIME, Temp.DONE, Temp.Status .... and it works OK.
INSERT INTO Temp ( TOTALTIME, DONE, Status )
SELECT Temp( TOTALTIME, DONE, Status )
FROM Temp
WHERE ((Temp.DONE)= True);
.
- References:
- SELECT query error
- From: George Kuascha
- SELECT query error
- Prev by Date: Re: Help on resolving record conflicts with ADO
- Next by Date: Betterado error in Delphi 2006
- Previous by thread: SELECT query error
- Next by thread: Betterado error in Delphi 2006
- Index(es):
Relevant Pages
|
