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();
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();