Query field "CarID"not find?
位大哥帮帮忙！我对应老是提示发现不了字段，源代码如下，那位朋友帮帮忙
begin
FrmAddCar:=TFrmAddCar.Create(nil);
FrmAddCar.Caption:='修改车辆';
for i:= 1 to DBAdvGrid1.RowCount -1 do
if DBAdvGrid1.RowSelect[i] then
s:=DBAdvGrid1.Cells[0,i];
//ShowMessage(s);
with DMLBS.ABSQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select a.CarID ,a.CarType ,b.Name ,b.PhoneNum ,a.MainLine ,a.TruckState,a.ServersType);
SQL.Add('from Cars a,Drivers b where a.DriverID=b.ID and a.CarID='''+trim(s)+'''');
Open;
//DMLBS.ABSQuery1.ReadOnly:=True;
//Edit;
if DMLBS.ABSQuery1.IsEmpty then Exit;
while not DMLBS.ABSQuery1.Eof do
begin
FrmAddCar.edtCarID.Text:=fieldByName('CarID').AsString;
FrmAddCar.edtDriverName.Text:=FieldByName('Name').AsString;
FrmAddCar.edtCarPhone.Text:=FieldByName('PhoneNum').AsString;
FrmAddCar.edtCarType.Text:=FieldByName('CarType').AsString;
FrmAddCar.edtMainLIne.Text:=FieldByName('MainLine').AsString;
FrmAddCar.cbbTruckState.Text:=FieldByName('TruckState').AsString;
FieldByName('CarID').Value:=FrmAddCar.edtCarID.Text;
end;
FrmAddCar.AdvGlowButton1.Caption:='修改并保存';
FrmAddCar.Show;
// FrmAddCar.AdvGlowButton1Click(act3);
end;
运行结果是 ABSQuery1 not find Field "CarID" 请看到的朋友帮忙
[解决办法]
如果sql没有错误的话，就是引号问题了，你跟踪下，看里面的字符串是否合法
[解决办法]
a.CarID as CarID 一点意义没有，你直接这样a.CarID试试
