RE: [KCFusion] Assigning unique ID's

[Greenhagen, Robin]

Title: RE: [KCFusion] Assigning unique ID's

Maybe you shouldn't use a GUID, use a timestamp of some sort (whatever VFP gives you with the finest precision).  It will still free up your "two records that look exactly alike" issue.   Just a thought. Thanks, Robin Greenhagen President GSI (GreenSoft Solutions, Inc.) http://www.gsi-kc.com/ -----Original Message----- From: Ramphal, Ron [mailto:[EMAIL PROTECTED]]On Behalf Of Ramphal, Ron Sent: Thursday, January 24, 2002 10:28 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Assigning unique ID's Robin & Ryan,   I am using Visual Foxpro database for this app, don't believe I have any of the operators/functions you mentioned available thru ODBC... :(   Thanks for the swift replies,   Ron. -----Original Message----- From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]] Sent: Thu 1/24/2002 9:47 AM To: [EMAIL PROTECTED] Cc: Subject: RE: [KCFusion] Assigning unique ID's What about running a query like this in SQL Ent Mgr. UPDATE table_name SET new_guid_fld=NEWID() Now you will have a new Unique GUID on each record, and you can fix your IDENTITY/INDEX issue. Thanks, Robin Greenhagen President GSI (GreenSoft Solutions, Inc.) http://www.gsi-kc.com/ > -----Original Message----- > From: Ramphal, Ron [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 24, 2002 9:34 AM > To: [EMAIL PROTECTED] > Subject: [KCFusion] Assigning unique ID's > > > Hello, >  > Might be real simple but it eludes me at this moment... > I have a table in which the app somehow managed to assign > duplicate id's to different records, to fix I decided to add > an extra  field and propagate with a guid using CF's > CreateUUID function, can anyone explain how to do the whole > table in one pass, therefore creating a unique id for each record? >  > TIA, >  > Ron. > N[  w鲲+Ȳo!♙w > p븸 > +    Vry > NJq捲zˢ{i۬i)>궶[疖+z~zぁ:&+rzG麺ȞNrzf~Xᶶ鹻&Dz* > N[    b2֧w+^h2םo!wR^Z'p8 ܆+޲m   Vry& dq .zϬb{i(䀬ih) >隊[h+--z~"z+䠁:&ޙ+-rzGȨN'蠲rzf~Xࢬ        &ޑ*'