Devart Forums

I'm using SDAC 4.10's TMSQuery
My code is like ->

CLOSE;
SQL.TEXT := 'SELECT * FROM CUSTOMERS'+
' WHERE ACCTNO=:ACCTNO';
PARAMS[0].VALUE := 'ABCD';
OPEN;

It only works on SQL 2005/SQL 2005 Express.
But not on SQL 2005 COMPACT. It shows error:
REQUESTED CONVERSION NOT SUPPORTED...

Please guide me how to correct it.

I finally found a way.
Just set the param's datatype as variant ->

SQL.TEXT := 'SELECT * FROM CUSTOMERS'+
' WHERE ACCTNO=?';
PARAMS[0].DATATYPE := ftVARIANT;

...

CLOSE;
PARAMS[0].VALUE := 'ABCD';
OPEN;

It works great on both SQL Server and SQL Server Compact.
My app is totally scalable now.

This is an acceptable solution, but we recommend using exact data types like ftInteger, ftString instead of ftVariant.