Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you handle Out Parm UniqueIdentifier
Message
From
01/04/2005 17:04:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How do you handle Out Parm UniqueIdentifier
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01000885
Message ID:
01000885
Views:
72
We are going a ms sql server stored procedure provided to us by a 3rd party.
The final parameter is the out parameter which is an UniqueIdentifier.

I tried the following.
lcCmd = [Exec < sp > ?in1, ?in2, ?in3, ?@out1]

SqlPrepare( lnConnectionHandle, lcCmd )

Select < table >
Scan
    out1 = Space(20)
    SqlExec( lnConnectionHandle )
EndScan
The call doesn't generate an error but the out parameter is not set.

I then tried the following.
lcCmd = [Exec < sp > ?in1, ?in2, ?in3, ?@out1]
SqlPrepare( lnConnectionHandle, lcCmd )

CREATE CURSOR 'Test' ( 'Test' Q(32) )

Select < table >
Scan
    out1 = Test.Test
    SqlExec( lnConnectionHandle )
EndScan
The out parameter is stuffed with the 32 byte integer.

Is there a simple way to convert that to it's character representation?
Is this the best way to handle the out parameter, assuming I'm using SqlExec instead of ADO?
Next
Reply
Map
View

Click here to load this message in the networking platform