Incorrect value in procedure output

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 52
Joined: Mon 24 Mar 2008 13:22

Incorrect value in procedure output

Post by Alexander_73 » Fri 02 Aug 2013 13:30

A table contains field Id UNIQUEIDENTIFIER. When I see values of this field with MSQuery.Fields[0].AsString, it contains symbols '{' like '{4A38E7AD-494F-E211-9782-00259038EC35}'. But if I call MSStoredProc with output parameter UNIQUEIDENTIFIER for this field with MSStoredProc.FindParam('ID').AsString, it doesn't contain these symbols, like '4A38E7AD-494F-E211-9782-00259038EC35'. Is it true?


Re: Incorrect value in procedure output

Post by AndreyZ » Mon 05 Aug 2013 09:16

If a stored procedure has the UNIQUEIDENTIFIER output parameter, you will see its value with the '{' and '}' symbols when using the AsString property of the parameter. If you encountered situation when it is not true, please specify the following:
- the script to create the stored procedure;
- the exact version of SQL Server server and client you are using. You can learn it from the Info sheet of TMSConnection Editor.

Post Reply