search

FirebirdSQL / NETProvider

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

Parameters by ExecuteNonQuery [DNET144] #155

Closed firebird-automations closed 16 years ago

firebird-automations commented 16 years ago

Submitted by: Christian (garviel)

In the function "ParseNamedParameters" gets a flag "inCommas " which checks if a value is in Comma or not. In my Insert-Statement I have the problem, that a ' that this flag as true and a " set this flag to false again. ( I have to use a "-Char as short cut for an inch)

This is the cause, that a @-Char was found in the string which is content at all. I think we have to check both with different flags.

Here are my values of the INSERT - STATEMENT

('905' ,'WH/01791910' ,50020,0,null,null,'442218' ,'FILTEREINSATZ F. DF.3/8\"' ,null,null,null,0,'0130357' ,'000' ,1,'ST' ,'3RA' ,null,'False' ,null,'E' ,null,0,null,null,null,'E' ,0,3.62,'1' ,3.62,'0' ,'HP1' ,10,null,null,0,'True' ,3.62,0,0,'False' ,3.62,'WH' ,'08/03/2005 00:00:00' ,'30' ,null,0,'C6 X 003662@1' ,'400122' )"

Commits: FirebirdSQL/NETProvider@1182c8425d1ce78654e4933ca0d3b2314bf35e61

firebird-automations commented 16 years ago
Modified by: @cincuranet assignee: Carlos Guzman Alvarez \[ carlosga\_fb \] =\> Jiri Cincura \[ cincura\_net \]
firebird-automations commented 16 years ago
Modified by: @cincuranet status: Open \[ 1 \] =\> In Progress \[ 3 \]
firebird-automations commented 16 years ago

Commented by: @cincuranet

r. 455

firebird-automations commented 16 years ago
Modified by: @cincuranet status: In Progress \[ 3 \] =\> Resolved \[ 5 \] resolution: Fixed \[ 1 \] Fix Version: 2\.5\.0 \[ 10170 \]
firebird-automations commented 16 years ago
Modified by: @cincuranet security: Developers \[ 10012 \] =\>
firebird-automations commented 16 years ago
Modified by: @cincuranet Component: Provider \[ 10041 \]