Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-10 Thread sasha
Yes. BTW can you send me a test case, I try to have a look at the problem. But what test do you want? You can take any table with BIGNINT field and create for example UPDATE command oh this field... I can sent you screenshots if you want.

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-10 Thread Jiri Cincura
sasha wrote: Yes. BTW can you send me a test case, I try to have a look at the problem. But what test do you want? You can take any table with BIGNINT field and create for example UPDATE command oh this field... I can sent you screenshots if you want. If I create update command for

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-10 Thread sasha
If I create update command for TableAdapter, it creates me paramaters as objects... Hmm, very strange... I'll look at home later... - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-10 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: can't be customized ( as i know at least ) Yeah, I hate MS for doing this. But it's a good story for other developers - trust me, everytime I'm saying this everybody almost cries from laughing. ;) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-10 Thread sasha
If I create update command for TableAdapter, it creates me paramaters as objects... Tested in my VS. Look - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-10 Thread sasha
If I create update command for TableAdapter, it creates me paramaters as objects... Tested in my VS. Look at screenshot. - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-09 Thread Carlos Guzmán Álvarez
Hello: Can't find your e-mail. You can try script below... easy ;) carlosga05 at gmail.com -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com - Take Surveys. Earn Cash. Influence the Future of IT Join

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-09 Thread sasha
easy ;) carlosga05 at gmail.com Sent... - 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

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-09 Thread sasha
Well, creating case sensitive tables is like playing with a fire. But this isn't problem of FB provider, this quotation is handled by VS. But MS SQL also supports quoted identifiers in and []. I'm using in my MS SQL databases fields with names equals to reserved words. For example i have few

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-09 Thread sasha
It's not wrong. ;) Why provider decide to select for this parameter Int32 type? Why don't it use object, boolean, string, deciamal and so on... I think provider can generate correct type ;-) - Take Surveys. Earn Cash.

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-09 Thread Dean Harding
But MS SQL also supports quoted identifiers in and []. I'm using in my MS SQL databases fields with names equals to reserved words. For example i have few fields with name Name and i think sql provider will handle this names correctly. The fact that quoted identifiers are case-sensitive is a

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-08 Thread Jiri Cincura
sasha wrote: I've tried generation of commands for vews. For tables seems all ok Is the view updatable? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence

[Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-08 Thread sasha
Hi! I'm using FB.NET Privider 2.1 with DDEX 2.0.1. When i click Add query in DataSet designer on table adapter and choose generating new UPDATE or INSERT command then provider generates simple words UPDATE or INSERT and that's all. I've tried generation of commands for vews. For tables seems

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-08 Thread sasha
Is the view updatable? Yes. It simle alias for table: CREATE VIEW Notes AS SELECT * FROM _Notes; - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-08 Thread Jiri Cincura
sasha wrote: Is the view updatable? Yes. It simle alias for table: CREATE VIEW Notes AS SELECT * FROM _Notes; Humm, seem to be, that cooperation with DbCommandBuilder isn't 100% correct (it will not return result in GetInsertCommand etc.). Does this work with previous version? Does the

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-08 Thread sasha
Can you send a test database to my private email ??, please Can't find your e-mail. You can try script below... /**/ /*** Generated by IBExpert 2006.11.26 08.01.2007 22:12:26 ***/

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-08 Thread sasha
Does this work with previous version? Does the MS SQL work with views (if you're able to test)? Don't know about previous versions and MS SQL. In any case this is a bug. - Take Surveys. Earn Cash. Influence the Future

Re: [Firebird-net-provider] Insert/Update/Delete commands not generated for views in 2.1 b1

2007-01-08 Thread sasha
Another one. If i not confuse (can't check now) MS SQL's provider generate something like this: INSERT INTO Table (Name, Description) VALUES (@Name, @Description); SELECT Id, Name, Description FROM Table WHERE Id = SCOPE_IDENTITY(); But it's not completely clear for me how does it works...