Hey Jason, Assuming your table column contains data such as C:\MYSUB\MyPic.jpg
Use this code; Set v vcolname text=null Set v voldtext text='jpg' Set v vnewtext='png' Drop cursor c#1 Declare c#1 cursor for select colname fro MyTable Open c#1 Fetch c#1 into vcolname vi1 While sqlcode <> 100 the UPDATE MyTable set colname=(srpl(.vcolname,.voldtext,.vnewtxt,0)) whe current of c#1 Fetch c#1 into vcolname vi1 Endwhile Drop cursor c#1 Return If you want to test your code before you run it (remember to backup first !) then use this code first; Set v vcolname text=null Set v voldtext text='jpg' Set v vnewtext='png' Set v vcolname2 text=null Set v vmsg text=null Drop cursor c#1 Declare c#1 cursor for select colname fro MyTable Open c#1 Fetch c#1 into vcolname vi1 While sqlcode <> 100 the set v vcolname2=(srpl(.vcolname,.voldtext,.vnewtxt,0)) --UPDATE MyTable set colname=(srpl(.vcolname,.voldtext,.vnewtxt,0)) whe current of c#1 set v vmsg=(.vcolname&.vcolname2) pause 2 using .vmsg caption 'Testing Code' icon info Fetch c#1 into vcolname vi1 Endwhile Drop cursor c#1 Return Hope this helps ! Bill Eyring Ps: University of Delaware looks better than University of laware ! -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Kramer Sent: Friday, December 05, 2008 4:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - UPDATE question I have a table that has a list of file names as one of its columns. All of the file names are .jpg files, and we just converted to .png because all the cool kids are using .png files for web design now (or so I'm told). I am trying to figure out how to update the database so the file name in the table will now have a .png extension. Only the extension changed. If the old name was MyPic.jpg, the new name is MyPic.png. I think that I should use the UPDATE command with an expression, but I'm not sure what expression to use. In psudocode: UPDATE mytable SET filename = (SMOVE(<current value in filename>,1,SLEN(<current value in filename>) - 3,'',1) + '.png') WHERE filename IS NOT NULL Thanks, Jason -- Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax)
