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

Click here to load this message in the networking platform