cmiiw,
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';
mysql_query(@mysqlconnection,PChar(querystr));
... etc ...
so delphi will ignore the second ':=' because it's in a string, not an
assignment operator
and dont forget to put '@' before TOTAL, or else you will get error from
mysql
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
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]
