dont you think you are supposed to pass the query as string in delphi???
somewhat like this :
querystr:='SELECT @TOTAL:=PRICE * QTY FROM INV_PRODUCT';
... etc ...
so delphi will ignore the second ':=' because it's in a string, not an
and dont forget to put '@' before TOTAL, or else you will get error from
because it will think TOTAL as a global server variable
The Nice Spider wrote:
>Using Delphi to with this query: SELECT TOTAL :=
>PRICE * QTY FROM
>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
>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.