> Which component, Spider?
> with TSQLQuery try setting: ParamCheck property to false. Look in help
> for your specific component...
Mind you, setting ParamCheck only has effect for run-time assignments
to the SQL strings property.
Martijn Tonies
Database Workbench - tool for InterBase, Firebir
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
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
assign
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