[DUG]: Dbase: Error in SQL ?

[John Christenhusz]

Hi all,

Can anybody tell me what the problem is with the following SQL statement
and SQL-parameter setting.

SELECT *
FROM CommsPars.DB cp
WHERE (cp.CommPortState = :State) AND (cp.CommDevice <> 'Inactive');

When I set the SQL-parameter, with the following code

   paramByName('State').asInteger = 8

then it generates (occasionally) an error. The message is "Invalid
parameter".

Any ideas?

Thanks,

John Christenhusz
POSTEC DATA SYSTEMS Ltd.
PO Box 302-230
Auckland, New Zealand
E-mail: [EMAIL PROTECTED]
Phone: 09-415.8803
Fax: 09-415.9042

application/ms-tnef