delphi / ADO / MySQL / parameters

bidochon · #1 (**permalink**) 06-03-04, 13:32

Hi,

I'm using Delphi 7, MS ACCESS and MySQL 4.0.20 via ADO.

I'm trying to make simples Querys with parameters

code :

Code:

Query.SQL.Text:='Select sum(debit),sum(credit) '+
                'from MaTable '+
                'where (Month(jour)=:PMois) and (Year(jour)=:PAn)'; 
Query.Parameters[0].Value:=5; 
Query.Parameters[1].Value:=2000; 
Query.Open;

The problem is :
-> When I'm connected to ACCESS, Works Fine !
-> When I'm connected to MySQL, I got a ERROR message : 'Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another'

Any help would be greatly apreciated.
thanks

bidochon · #2 (**permalink**) 06-04-04, 15:35

More informations :

The ERROR Message appears just after loading the property Query.SQL.Text (before the affectation of Query.Parameters[0].Value)
When the program is compiled : that works fine
but under DELPHI debugger the error message appears
If the database is a local database (MySQL 5.0.0-alpha-nt for Windows) : it works fine but if the database is on my Linux server (MySQL 4.0.20) the problem appears

Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech