>I have a large scale application used by over 350 clients. My company has decided to rename (and expand) this existing application (old name: EDWin new name: iePoint). I have successfully changed the project and related files to the new name. The existing DBC is named EDWin.dbc. I want to rename it to iePoint.dbc. I know that I can rename the DBC within the project, then issue VALIDATE DATABASE RECOVER to correct the backlinks for all tables. My question is this: how will I do this same process at over 350 clients? When the new application is installed at the client's site, the install process will run a VFP "fix" program, but I am not sure how to programatically rename EDWin.dbc to iePoint.dbc and fix the backlinks on all tables.
>
>BTW: I do use Stonefield - could this be of some help?
>
>TIA
Function RenDbc
lparameters OldName, NewName
Open data (oldName)
lnTables=adbobject(arrTables,'TABLE')
For ix=1 to lnTables
lcTable = arrTables[ix]+'.DBF'
handle=fopen(lcTable,12)
=fseek(handle,8,0)
lnLowByte = asc(fread(handle,1))
lnHighByte = asc(fread(handle,1))*256
lnBackLinkstart = lnHighByte + lnLowByte - 263
=fseek(handle,lnBackLinkstart,0)
Fwrite(handle,forceext(newName,'dbc')+replicate(chr(0),263),263)
=fclose(handle)
Endfor
Close data all
Rename (forceext(oldName,'dbc')) to (forceext(newName,'dbc'))
Rename (forceext(oldName,'dcx')) to (forceext(newName,'dcx'))
Rename (forceext(oldName,'dct')) to (forceext(newName,'dct'))
Cetin