Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you handle Out Parm UniqueIdentifier
Message
From
01/04/2005 18:14:38
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01000885
Message ID:
01000901
Views:
19
>Dan, sorry but what type is Q(32)?
>I didn't see this in help. When I try to CRATE TABLE with Q(32) field VFP raise an error

I apologize. I'm writing this in VFP 9.0
Q is VarBinary.

I don't need to add the cursor and I want to convert the GUID to a string so I can do the following.
lcCmd = [Exec < sp > ?in1, ?in2, ?in3, ?@out1]
SqlPrepare( lnConnectionHandle, lcCmd )

out1 = 0h

Select < table >
Scan
    SqlExec( lnConnectionHandle )
    cOut1 = STRCONV( cOut1, 15 )
    cOut1 = [{] + SUBSTR( cOut1, 7, 2) + SUBSTR( cOut1, 5, 2) + SUBSTR( ;
       cOut1, 3, 2) + SUBSTR( cOut1, 1, 2) + [-] + SUBSTR( cOut1, 11, 2) + ;
       SUBSTR( cOut1, 9, 2) + [-] + SUBSTR( cOut1, 15, 2 ) + SUBSTR( ;
       cOut1, 13, 2 ) + [-] + SUBSTR( cOut1, 17, 4 ) + [-] + SUBSTR( ;
       cOut1, 21, 12 ) + [}]
EndScan
I think that I can convert back by stripping the extra characters and
reordering the characters then.

Out1 = 0h&cOut1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform