List:General Discussion« Previous MessageNext Message »
From:Leo Date:November 21 2005 8:30am
Subject:Re: Assigment sign not work on Delphi
View as plain text  
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
>
>  
>
Thread
Assigment sign not work on DelphiThe Nice Spider18 Nov
  • Re: Assigment sign not work on DelphiLeo21 Nov
  • Re: Assigment sign not work on DelphiRemo Tex1 Dec
  • Re: Assigment sign not work on DelphiMartijn Tonies1 Dec