Passing uniqueidentifier (GUID) from Adp to SQL Server

[PWise]

I am trying to run this code from a Vba module

.....
cmd.CommandText = "Insert into ProvidersSelect(Providerid,newguid) Values (655," & me.TxtGUID & ")"
cmd.Execute
....

where me.TxtGUID ={94FB6132-8812-48A3-8997-DDA311DE23AF}
this is the error I get

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

any help will be appreciated

Pwise

 

[ajrimmer]

Looks like it's a string so needs to be in single quotes

cmd.CommandText = "Insert into ProvidersSelect(Providerid,newguid) Values (655, [COLOR=red]'[/color red]" & me.TxtGUID & "[COLOR=red]'[/color red])"

hth

 

[PWise]

ajrimmer:

Thanks for replying

Field newguid is of type uniqueidentifier

When I enclosed it in single quotes m get this error

Syntax error converting from a character string to uniqueidentifier.

I tried useing

cmd.CommandText = "Insert into ProvidersSelect(Providerid,newid) Values (" & ProviderId & "," & GUIDFromString(Me.NewId) & ")"

I get This error

Line 1: Incorrect syntax near '?'.

when i run

debug.print cmd.CommandText

it prints

Insert into ProvidersSelect(Providerid,newid) Values (655,????????)

and in profiler

Insert into ProvidersSelect(Providerid,newid) Values (655,????????)

Pwise