Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Uniqueidentifier 1

Status
Not open for further replies.
foxbox

foxbox

Programmer
Sep 11, 2000
1,052
NL
I need to INSERT records in a MS SQL 2005 table with an uniqueidentifier field.Is it possible to create the full SQL statement in the VFP program?
Or should i write a SP in the database that accepts the values from my program and uses the NEWID() function?
Other ideas?
 
Sort by date Sort by votes
Why not just make default value for that field to be NEWID() and don't touch that field in VFP?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
of course. [i'm used to IDENTITY fields]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Marat
  • Locked
  • Question
Convert string to uniqueidentifier
Replies
5
Views
123
Marat
Marat

Part and Inventory Search

Sponsor

Back
Top