Robin, No joy it just sets all values to timestamp when the query started <CFQUERY NAME="AssignNewID" DATASOURCE = "#ODBC_DSN#"> UPDATE STImport SET uid = '#timeformat(Now(),"hh:mm:sstt")#' </CFQUERY> Other thoughts appreciated Thanks, Ron. -----Original Message----- From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]] Sent: Thu 1/24/2002 10:39 AM To: [EMAIL PROTECTED] Cc: Subject: 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ࢬ &ޑ*'
winmail.dat
Description: application/ms-tnef