Incorrect value in procedure output
-
- Posts: 52
- Joined: Mon 24 Mar 2008 13:22
Incorrect value in procedure output
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
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.
- 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.