I have meet same problem. SQL generated for update with designer generate error. For Autonumber fields I modify allownull to true, and is autonumber to true. For update statement, I have deleted all where blab la bla, and let only where [EMAIL PROTECTED] and it works without errors.
Regards, Paul > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Jiri Cincura > Sent: Thursday, January 11, 2007 9:39 PM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Wrong parameter declaration > > sasha wrote: > > And yet one inconvenience. Seems designer knows what fields in table > are > > primary keys. So why don't it generates UPDATE and DELETE commands > > using only this keys in WHERE clause: > > > > ... WHERE Id = @Original_Id; > > Because MS likes "optimistic concurency". > > -- > Jiri {x2} Cincura > http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com > > ----------------------------------------------------------------------- > -- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD > EV > _______________________________________________ > Firebird-net-provider mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
