RE: [KCFusion] Assigning unique ID's

[Ramphal, Ron]

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