I have a problem and I can not solve.
I need to insert a record and read the table below to see a TDBLockupComboBox.
For this I use the following code to insert:
and try to read the table with:with FxEx.msqFabricants do begin
Close;
SQL.Clear;
SQL := SQLInsert;
ParamByName('NomFabricant').AsString := edtCrear.Value;
ParamByName('Codi').AsInteger := Codi;
ParamByName('Referencia').AsString := edtReferencia.Value;
Execute;
end;
SQLRefresh = Select * FROM tblFabricants.with FxEx.msqFabricants do begin
Close;
SQL.Clear;
SQL := SQLRefresh;
Open;
end;
but returns nothing
I use Delphi 2010 in Windows 7 and SDAC 7,5
thank you very much