firebird-net-provider

[Firebird-net-provider] Using FBCommandBuilder with a table that has a trigger to update a column

[Tony R. <Ton...@jf...>]

How do you stop FBCommandBuilder from using "ID" in the insert command.
The ID will be created by a trigger in the database.

=20

Insert: INSERT INTO "JFMTEMP" ("ID", "TEST_STRING", "TEST_DATE",
"TEST_BOOLEAN", "TEST_NUMERIC", "TEST_TEXT", "TEST_INTEGER") VALUES (?,
?, ?, ?, ?, ?, ?)

=20

Update: UPDATE "JFMTEMP" SET "ID" =3D ?, "TEST_STRING" =3D ?, "TEST_DATE" =
=3D
?, "TEST_BOOLEAN" =3D ?, "TEST_NUMERIC" =3D ?, "TEST_TEXT" =3D ?,
"TEST_INTEGER" =3D ? WHERE ( ("ID" =3D ?) AND (("TEST_STRING" IS NULL) OR
("TEST_STRING" =3D ?)) AND (("TEST_DATE" IS NULL) OR ("TEST_DATE" =3D ?))
AND (("TEST_BOOLEAN" IS NULL) OR ("TEST_BOOLEAN" =3D ?)) AND
(("TEST_NUMERIC" IS NULL) OR ("TEST_NUMERIC" =3D ?)) AND (("TEST_INTEGER"
IS NULL) OR ("TEST_INTEGER" =3D ?)) )

=20

Delete: DELETE FROM "JFMTEMP" WHERE ( ("ID" =3D ?) AND (("TEST_STRING" IS
NULL) OR ("TEST_STRING" =3D ?)) AND (("TEST_DATE" IS NULL) OR ("TEST_DATE"
=3D ?)) AND (("TEST_BOOLEAN" IS NULL) OR ("TEST_BOOLEAN" =3D ?)) AND
(("TEST_NUMERIC" IS NULL) OR ("TEST_NUMERIC" =3D ?)) AND (("TEST_INTEGER"
IS NULL) OR ("TEST_INTEGER" =3D ?)) )

=20

=20



This message has been scanned for viruses by MailControl - www.mailcontrol.=
com

Re: [Firebird-net-provider] Using FBCommandBuilder with a table that has a trigger to update a column

[<car...@te...>]

Hello:

> How do you stop FBCommandBuilder from using "ID" in the insert command. 
> The ID will be created by a trigger in the database.

I can't know that the field will be generated in the server side, but, 
in any case i think that the only problem here can be with inserts, the 
id will have a 0 as value ( unless you have filled it with other value 
), and if you assign a new value in the before insert trigger it needs 
to insert the record ok, with the correct value.

In the case of up`date and delete the field id needs to be filled ;)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbBatchExecution doesn't assign sqlTransaction to atomicCommand

[Mike S. <mik...@ex...>]

Hi Carlos

Long time no speak! I've been working on a different project which 
didn't require Firebird, but now we're back looking at Firebird again so 
you'll probably see more messages from me in the future :-)

I don't know if you remember, but I was interested in getting a better 
ISQL script parser. I now see that you've implemented a parser class and 
I've been playing with FbBatchExecution. However, I get exceptions which 
complain that the command has no transaction set. Having looked at the 
code, I can see that you don't assign the sqlTransaction to the 
atomicCommand in the loop in Execute(). So the commands don't have the 
transaction assigned.

Cheers,

Mike Scott.

Re: [Firebird-net-provider] FbBatchExecution doesn't assign sqlTransaction to atomicCommand

[<car...@te...>]

Hello:

> Long time no speak! I've been working on a different project which 
> didn't require Firebird, but now we're back looking at Firebird again so 
> you'll probably see more messages from me in the future :-)

:)

> I don't know if you remember, but I was interested in getting a better 
> ISQL script parser. 

I remember :)


> I now see that you've implemented a parser class and 

It's implemented by Abel Eduardo Pereira but it's unfinished ( he was a 
little busy and having no time for finish it )

> I've been playing with FbBatchExecution. However, I get exceptions which 
> complain that the command has no transaction set. Having looked at the 
> code, I can see that you don't assign the sqlTransaction to the 
> atomicCommand in the loop in Execute(). So the commands don't have the 
> transaction assigned.

Tanks, i will forward the message to Abel Eduardo Pereira for see if he 
can fix it if no i will try to take a look at it




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbBatchExecution doesn't assign sqlTransaction to atomicCommand

[Abel E. P. <sa...@sa...>]

Greetings Mike,

Carlos has gently forwarded this message to me.
FbBatchExecution is not complete. I was expecting to have it finished last
week, but the time available made it impossible.
The problem you've experimented exists because the
FbBatchExecution.Execute() is not complete (I think it's the only method
remaining)...
I'll keep yor email and notify you soon as I finnish it. Anyway, I hope to
complete the Isql namespace by next friday to be ready for 1.6 Beta 1
release.

Best regards,

Abel Eduardo Pereira

"Mike Scott" <mik...@ex...> wrote in message
news:405...@ex......
> Hi Carlos
>
> Long time no speak! I've been working on a different project which
> didn't require Firebird, but now we're back looking at Firebird again so
> you'll probably see more messages from me in the future :-)
>
> I don't know if you remember, but I was interested in getting a better
> ISQL script parser. I now see that you've implemented a parser class and
> I've been playing with FbBatchExecution. However, I get exceptions which
> complain that the command has no transaction set. Having looked at the
> code, I can see that you don't assign the sqlTransaction to the
> atomicCommand in the loop in Execute(). So the commands don't have the
> transaction assigned.
>
> Cheers,
>
> Mike Scott.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

RE: [Firebird-net-provider] Using FBCommandBuilder with a table that has a trigger to update a column

[Alan M. <al...@me...>]

  How do you stop FBCommandBuilder from using "ID" in the insert command.
The ID will be created by a trigger in the database.





  the trigger should test for NULL so you can assign NULL to the ID
parameter

  Alan