[Firebird-net-provider] autonumber field (was: Wrong parameter declaration)

2007-01-11 Thread Jiri Cincura
Mercea Paul wrote: You're right. But for autonumber field, if I don't correct manually allowdbnull for each insertion in datagridview I get error, generate by grid (VS), because expecting value for ID column! Let's clarify this a little. You have table with PK ID, the ID is generated by

Re: [Firebird-net-provider] autonumber field (was: Wrong parameter declaration)

2007-01-11 Thread Mercea Paul
Let's clarify this a little. You have table with PK ID, the ID is generated by generator in trigger, right? If you insert the row into grid you get error because ID is null, right? Right! - Take Surveys. Earn Cash.

Re: [Firebird-net-provider] autonumber field

2007-01-11 Thread Jiri Cincura
Mercea Paul wrote: Let's clarify this a little. You have table with PK ID, the ID is generated by generator in trigger, right? If you insert the row into grid you get error because ID is null, right? Right! Well, this is a problem by design. The MS SQL has identity, which is in fact

Re: [Firebird-net-provider] autonumber field

2007-01-11 Thread Mercea Paul
Well, this is a problem by design. The MS SQL has identity, which is in fact something like autoincrement id. This is a property of column. But FB has more powerfull (OK, little bit PR) generators. But bind between column and (trigger and) generator cannot be discovered easily. So if

Re: [Firebird-net-provider] autonumber field

2007-01-11 Thread Jiri Cincura
Mercea Paul wrote: designer.cs file and it works. Carlos said that VS verify the syntax agains possible error. For now looks like VS is strictly oriented to SQL, but, I Yes, it's a damn desing bug. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] autonumber field

2007-01-11 Thread Carlos Guzmán Álvarez
Hello: You're right. From DDEX, right now I would expect possibility to put plan in my sql statements, but, it's not working for now. The trik is to edit the designer.cs file and it works. Carlos said that VS verify the syntax agains possible error. For now looks like VS is strictly oriented