Re: [Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

2006-06-11 Thread Robert Simpson
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Saturday, June 10, 2006 12:50 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] OT: Problem with FB specific statements

Re: [Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

2006-06-11 Thread Jiri Cincura
On 11.6.2006 17:55 Robert Simpson wrote: I have the same problem with the SQLite provider. Basically what you have to do is generate a simple select statement to make the querybuilder build the other statements, then show the properties for the generated tableAdapter, and manually edit your

Re: [Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

2006-06-11 Thread Robert Simpson
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Sunday, June 11, 2006 9:09 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

Re: [Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

2006-06-10 Thread Jiri Cincura
On 10.6.2006 10:31 +0200 Carlos Guzmán Álvarez wrote: i don't know if it's possible or not to bypass that validation or do a custom one ( in any case looks strange they don't do a simple call to prepare for the command to see if it's accepted or not by the target database ) Yes, I know. i

Re: [Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

2006-06-10 Thread Carlos Guzmán Álvarez
Hello: I have sent a question to the VS Data team using their blog i will post here the news when i get a response. They have answered to me that in the case of the Query Editor that is not extensible ( so on the query builder looks like that issue is not going to have a solution ). But

Re: [Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

2006-06-10 Thread Jiri Cincura
On 10.6.2006 19:40 +0200 Carlos Guzmán Álvarez wrote: But you told me that isn't your case, can you post a list with the steps you are doing ?? Yes. :) Very simple: 1. Create new (typed) dataset. 2. Add new table adapter via right-click menu. 3. Do some classic steps with next. 4. Type

[Firebird-net-provider] OT: Problem with FB specific statements and VSDDEX

2006-06-09 Thread Jiri Cincura
Hi *, today I was really peeved with typed datasets and FB .NET provider. I was creating a lot of (really lot) typed DS and sometimes with some FB specific statements. I.e. select first 10 items from ... This statements are emiting VS's errors (I'm not using Query Builder, I'm writing direct