Which component, Spider?
with TSQLQuery try setting: ParamCheck property to false. Look in help
for your specific component...
To Leo's :
Delphi/dbExpress uses ':' character to specify SQL Parameters much alike
mysql uses '@' for variables :)
e.g.:
q.sql := 'select * from tbl where col1=:val1';
// then you can
// if ParamCheck := True of course - which it *is* by default to do:
q.Params[0] := 'somevalue'; //or even e.g.:
q.Params.ParamByName('val1').AsInteger := 999;
more thorough example is in help:
Query2.SQL.Clear;
Query2.SQL.Add('INSERT INTO COUNTRY (NAME, CAPITAL, POPULATION)');
Query2.SQL.Add('VALUES (:Name, :Capital, :Population)');
Query2.Params[0].AsString := 'Liechtenstein';
Query2.Params[1].AsString := 'Vaduz';
Query2.Params[2].AsInteger := 420000;
Query2.ExecSQL;
The Nice Spider wrote:
Using Delphi to with this query: SELECT TOTAL :=
PRICE * QTY FROM
INV_PRODUCT
will caused error "Parameter object is improperly
defined. Inconsistent or
incomplete information was provided." because Delphi
look it as Parameter (a
parameter of query in Delphi using ":" at the
beginning).
Is it better for MySQL using "=" rather than ":=" ? Or
is there any setting
to set MySQL to accept the "=" sign?
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
