trouble with uniqueidentifier

A

alecarnero

I have write this procedure
ALTER PROCEDURE dbo.proba (@ident uniqueidentifier)

AS SELECT ident, nome FROM dbo.nomes WHERE (ident = @ident)


Private Sub Form_Open(Cancel As Integer)
Dim rsn As ADODB.Recordset
Dim identi As Variant
identi = "{3AB65B0A-60ED-4708-B492-85C56E880946}"
Set rsn = New ADODB.Recordset
rsn.Open "exec proba @iden='" & identi & "'", cn, adOpenKeyset,
adLockOptimistic
Set Forms!auxpro.Recordset = rsn
End Sub

when i try to execute this code in VB returns error of argument, what is
wrong with the code , if the procedure works fine
 
P

PlatinumBay

alecarnero,

Try removing the '{' and '}' characters from the identi initialization code.

Hope this helps,


Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top