search

FirebirdSQL / NETProvider

Firebird ADO.NET Data Provider
https://www.firebirdsql.org/en/net-provider/
Other
159 stars 65 forks source link

Error creating Query's with Select Procedures [DNET84] #97

Closed firebird-automations closed 17 years ago

firebird-automations commented 17 years ago

Submitted by: Erick Phillipe Rezende de Almeida (ephillipe)

Assigned to: @carlosga

I trying create a query in a TableAdapter with a Select Procedure like this:

SELECT DPTO_ONLINE FROM VERIFICAR_DPTO_ONLINE(@ID_DPTO)

and the VS 2005 return above error:

Error in FROM clause: near '('. Unable to parse query text.

firebird-automations commented 17 years ago

Commented by: @carlosga

What is the command type of the command ??

In some cases Visual Studio SQL Editor makes some parsing of the SQL Command, that is not valid when working with some Firebird Features and this can't be fixed in the DDEX provider ( there are no way to customize that parsing )

firebird-automations commented 17 years ago

Commented by: @carlosga

The problem comes from the Visual Studio 2005 query parsing, not from the DDEX provider itself ( that query parsing cannot be personalized right now )

firebird-automations commented 17 years ago
Modified by: @carlosga status: Open \[ 1 \] =\> Closed \[ 6 \] resolution: Won't Fix \[ 2 \]