Hi all !
I have an existing table which I cannot change. That is, I cannot create a
on before insert trigger on it. I have to know the generator value before
insert so I have to run something like this:
SELECT gen_id(GEN_WEBOBJECTNR, 1) AS id FROM rdb$database
So far so good. Since I have all the dataaccess in a separate layer (DLL)
using the DDEX provider, I would like to keep this in a tableadapter. But
the queryanalyser chokes on the $ sign in rdb$database. And if I include the
name in " like this "rdb$database" it will find the table but only 4 - 5
columns. The generators are not there. I could use a FBCommand through code
to get passed the queryanalyser, but then I met other problems.
Any help are greatly appreciated.
Thanks in advance.
Best wishes
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Norway
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
