Does your table1 contains column Field1 (in database, not in query)? I.e. can you run query "select field1, field2 from table1 where field1=1" from another program?
Sincerely yours, Viatcheslav V. Vassiliev -----Original Message----- From: Delphi-DB [mailto:delphi-db-boun...@lists.elists.org] On Behalf Of a.nouri Sent: Monday, October 07, 2013 10:52 AM To: delphi...@elists.org Subject: Delphi unidac issue I have query : select ¯o1 from table1 where ¯o2 delphi code: macrobyname('macro1').value := 'field1,field2'; macrobyname('macro2').value := 'field1=1'; i got an error like this: Unknown column filed1 in where clouse best regards, nouri _______________________________________________ Delphi-DB mailing list Delphi-DB@lists.elists.org http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db _______________________________________________ Delphi-DB mailing list Delphi-DB@lists.elists.org http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db