SQL statement

[Wings]

Hi,
When i try to execute the following sql statement I get a syntax error. Does any one see a problem?

String x = "Select * from CrewTable where PlatoonId = " + QuotedStr(DBPlatoonID->Text) + " AND VehicleID NOT = " + QuotedStr(DBVehicleID2->Text)
+ " AND VehicleID NOT = " + QuotedStr(DBVehicleID3->Text) + " AND VehicleID NOT = " + QuotedStr(DBVehicleID4->Text);

QryPlatoon1->SQL->Add(x);

QryPlatoon1->ExecSQL();

 

[LastCyborg]

Have you tried using the SQL Explorer?
What the error exactly says?

--- LastCyborg ---

 

[McGoat]

use String() and not QuotedStr()...

 

[Supernat03]

I think you need parenthesis as well around your where clause.

 

[Zyrenthian]

if QuotedString returns the text within single quotes you are fine... otherwise you need to make a SingleQuotedString function which will use the ' instead of "

Matt

 

[Wings]

Thanks for the help, actually the sql was fine, I needed to call Open() instead of ExecSQL().