Hi,
I have an SQL like this
SELECT * FROM users WHERE user_id in ( 4, 6, 93 )
I set the FbCommand's CommandText to
SELECT * FROM users WHERE user_id in @1
then added a List<long> to the named parameters
_IdList = new List<long>( new long[] {4, 6, 93});
_Command.Parameters.Add( new FbParameter( "@1", _IdList ) );
_Command.Prepare() and I get an exception
"Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, column 38.
?"
Is it possible to use generic lists as FbParameter ?
zolee
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider