Converting Guids, and using parameterized stored procedures

[dew]

I have a stored procedure that retrieves the id of a client table, which is
a guid

To get that id, I have
dim clientid as guid = GetClientID("Or gName")

The GetClientID returns a string, because sometimes it's not a guid, but in
this procedure it is.
How do I convert the GetClientID into a Guid? I tried

dim clientid as guid = CType(GetClient ID("OrgName"), guid)

but I get an error that says it cannot convert a string into a guid. I even
tried manually inserting a known guid in place of the GetClientID function
and still get the same error.

I tried changing the function GetClientID to return an object, and I get the
same conversion error.

On the other hand, I cannot change ClientID to a string, because then my
stored procedure will not work. My parameter is :
param=cmd.param eters.add("@Wor kerID", sqldbtype.uniqu eidentifier, 255)

I cannot change the parameter because the stored procedure will not work, if
I change the stored procedure to be a uniqueidentifie r, I get an error that
says Syntax .... converting string to a uniqueidentifie r.

So what am I missing: I need to retrieve a uniqueidentifie r (the client
id), so I can update other records using that clientid and I just don't seem
to have all the ducks in a row.

Thanks for your help.

[Alex D.]

this is how I do it in c#:

execProc.Parame ters.Add("@id", SqlDbType.Uniqu eIdentifier).Va lue = new
Guid(myString);

Hope that helps;
Alex.
"dew" <de*@yahoo.co m> wrote in message
news:OV******** *****@TK2MSFTNG P09.phx.gbl...

I have a stored procedure that retrieves the id of a client table, which is
a guid

To get that id, I have
dim clientid as guid = GetClientID("Or gName")

The GetClientID returns a string, because sometimes it's not a guid, but
in
this procedure it is.
How do I convert the GetClientID into a Guid? I tried

dim clientid as guid = CType(GetClient ID("OrgName"), guid)

but I get an error that says it cannot convert a string into a guid. I
even
tried manually inserting a known guid in place of the GetClientID function
and still get the same error.

I tried changing the function GetClientID to return an object, and I get
the
same conversion error.

On the other hand, I cannot change ClientID to a string, because then my
stored procedure will not work. My parameter is :
param=cmd.param eters.add("@Wor kerID", sqldbtype.uniqu eidentifier, 255)

I cannot change the parameter because the stored procedure will not work,
if
I change the stored procedure to be a uniqueidentifie r, I get an error
that
says Syntax .... converting string to a uniqueidentifie r.

So what am I missing: I need to retrieve a uniqueidentifie r (the client
id), so I can update other records using that clientid and I just don't
seem
to have all the ducks in a row.

Thanks for your help.

[dew]

You are Good! Thanks very much, that worked beautifully.

"dew" <de*@yahoo.co m> wrote in message
news:OV******** *****@TK2MSFTNG P09.phx.gbl...

I have a stored procedure that retrieves the id of a client table, which is
a guid

To get that id, I have
dim clientid as guid = GetClientID("Or gName")

The GetClientID returns a string, because sometimes it's not a guid, but
in
this procedure it is.
How do I convert the GetClientID into a Guid? I tried

dim clientid as guid = CType(GetClient ID("OrgName"), guid)

but I get an error that says it cannot convert a string into a guid. I
even
tried manually inserting a known guid in place of the GetClientID function
and still get the same error.

I tried changing the function GetClientID to return an object, and I get
the
same conversion error.

On the other hand, I cannot change ClientID to a string, because then my
stored procedure will not work. My parameter is :
param=cmd.param eters.add("@Wor kerID", sqldbtype.uniqu eidentifier, 255)

I cannot change the parameter because the stored procedure will not work,
if
I change the stored procedure to be a uniqueidentifie r, I get an error
that
says Syntax .... converting string to a uniqueidentifie r.

So what am I missing: I need to retrieve a uniqueidentifie r (the client
id), so I can update other records using that clientid and I just don't
seem
to have all the ducks in a row.

Thanks for your help.

[Alejandro Penate-Diaz]

you are welcome!
alex.
"dew" <de*@yahoo.co m> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .

You are Good! Thanks very much, that worked beautifully.

"dew" <de*@yahoo.co m> wrote in message
news:OV******** *****@TK2MSFTNG P09.phx.gbl...

I have a stored procedure that retrieves the id of a client table, which
is
a guid

To get that id, I have
dim clientid as guid = GetClientID("Or gName")

The GetClientID returns a string, because sometimes it's not a guid, but
in
this procedure it is.
How do I convert the GetClientID into a Guid? I tried

dim clientid as guid = CType(GetClient ID("OrgName"), guid)

but I get an error that says it cannot convert a string into a guid. I
even
tried manually inserting a known guid in place of the GetClientID
function
and still get the same error.

I tried changing the function GetClientID to return an object, and I get
the
same conversion error.

On the other hand, I cannot change ClientID to a string, because then my
stored procedure will not work. My parameter is :
param=cmd.param eters.add("@Wor kerID", sqldbtype.uniqu eidentifier, 255)

I cannot change the parameter because the stored procedure will not work,
if
I change the stored procedure to be a uniqueidentifie r, I get an error
that
says Syntax .... converting string to a uniqueidentifie r.

So what am I missing: I need to retrieve a uniqueidentifie r (the client
id), so I can update other records using that clientid and I just don't
seem
to have all the ducks in a row.

Thanks for your help.