Re: Hidden error kills my transaction. Help!

From: oj (nospam_ojngo_at_home.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 01:12:19 -0800

There is an implicit conversion from string (char(36)) to uniqueidentifier if
id_doc is defined as uniqueidentifier. A string with a length of 36 is
convertible only if it follows the form of xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
and each x is in the range of 0-9 or A-F.

Now, to further troubleshoot your issue, you would want to post your stored
procedure (plus ddl) so we can see what you're up against. 

-- 
-oj
http://www.rac4sql.net
"Miroo_news" <miroo@USUNTO.poczta.fm> wrote in message
news:c2mk5u$k1o$1@nemesis.news.tpi.pl...
> Hi,
> The situation is as follows:
> - I have a stored procedure with parameter
>   @ID_DOC  Char(36) OUTPUT,  --for uniqueidentifier
>   (and other paramters)
> - the first line in procedure is:
>   select @cnt = count(*) from docs where id_doc = @ID_DOC
> - the transaction begins
> - the parameter @ID_DOC is set in Delphi
>   to value (for example): 'ED5B7DD0-BBDD-45C5-912E-64F73720080B'
> - the procedure is called from Delphi using ADO
> - the procedure finishes properly
> But:
> Profiler shows there is an error:
>   Error: 8169, Severity: 16, State: 2 = 'Syntax error converting from a
> character string to uniqueidentifier.'
> The transaction is rollbacked
> The procedure goes on as the error wasn't raised
>
> Why? Why the error which rollbacks the transaction
> is not returned to Delphi as exception?
> Why it occures?
>
> Regards,
> Miroo
>
> ps.
> Don't ask me why uniqueidentifier is stored in
> char(36) parameter - this is not my own procedure.
>

Relevant Pages

  • Re: Hidden error kills my transaction. Help!
    ... >> There is an implicit conversion from string ) to ... >> uniqueidentifier if id_doc is defined as uniqueidentifier. ... >> stored procedure so we can see what you're up against. ...
    (microsoft.public.sqlserver.programming)
  • Re: Hidden error kills my transaction. Help!
    ... > There is an implicit conversion from string ) to ... > uniqueidentifier if id_doc is defined as uniqueidentifier. ... > stored procedure so we can see what you're up against. ...
    (microsoft.public.sqlserver.programming)
  • Re: Average multiple colums
    ... try to change the string into a number (implicit conversion) and then compute the average of that. ... Response: The answer to the question ... Avg Of AllQ: ...
    (microsoft.public.access.queries)
  • Re: uniqueidentifier in Access 2002
    ... being forced in this path while waiting for a DB overhaul that has also ... attribute that looks like necessary to identify the uniqueidentifier ... For now the application uses unbound forms but basically the first screen ... uniqueidentifier retrieved from a combo is a string while the one ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ToString.....or not ToString (that is the question)
    ... to use on the string in the first place (in this case: char). ... >> One implicit conversion that compiles with Option Strict On is Char to ...
    (microsoft.public.dotnet.framework)