VB6 / SQL newid() command problem

[mrrrl]

Having problems working with uniqueindentifiers(guid), MS SQL V7 and VB6.

I need to insert a guid into an existing sql database. The field is the DB is setup for guids. How do you use the newid() to generate a guid and then insert it into the database?


TIA

 

[MarkSweetland]

Since the NEWID() is a SQL function and not a VB function you'll have to use it as part of your SQL statement.

NewID() can be used with an INSERT statement to generate an id for the uniqueidentifier data type column in your table:

strSQL = "INSERT INTO table(column, guid) " & _
"SELECT 'columndata', NEWID()"




Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[mrrrl]

Thanks, I must have been really tired yesterday. I thought I had tried that, but I guess not.