Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot include a comma inside a delimited string as a SP parameter [ODBC52] #53

Closed
firebird-automations opened this issue Dec 4, 2008 · 7 comments

Comments

@firebird-automations
Copy link

Submitted by: Jorge Andres Brugger (jbrugger)

Attachments:
OdbcFb.zip

SP example:

CREATE PROCEDURE SP_EMITIR_PEDIDO_INTERNO (
sucursal smallint,
numero_pedido_interno integer,
usuario smallint,
observaciones varchar(2500))
as
begin
/* do something */
exit;
end

Working case:
call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string')

Non working case:
call SP_EMITIR_PEDIDO_INTERNO(1,1,1,'some string, with a comma')

Comma cannot be included inside string, SP call fails with "SQL Error code -104 Unexpected end of command - line 1,
column 51"

Commits: d4a0065 0dab28a 35f521e

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

assignee: Alexander Potapchenko [ lightfore ]

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Driver for testing.

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11230 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0 RC2 [ 10320 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11230 ] =>

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 11231 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants