Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you handle Out Parm UniqueIdentifier
Message
De
01/04/2005 18:14:38
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01000885
Message ID:
01000901
Vues:
17
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform