The SQL magic is more difficult as it needs proprietary statements depending on your database.
But it works similar to editing the export file with the following steps:
- For all the records where U_OBJNAME starts with the path to the working directory
- we UPDATE u_objname taking away the leading path to the working directory (via SUBSTRING or so.)
- finally we must not forget to commit this transaction with another SQL command
This way we are database dependend, but do not need to export/delete/import.
190822: Just to complete the suggestion with an example
For a SOLID database, the statements you can use with the SQL Workbench (GOLD-W) are for $IDF:
update UARCHITEM set U_OBJNAME = replace(U_OBJNAME,'C:\drive_g\!drive_!m4l\umeFASTory\umeFASTory_TDD-9604\work\','') where u_objname like 'C:\drive_g\!drive_!m4l\umeFASTory\umeFASTory_TDD-9604\work\%'
commit work
or you can write a tiny form using $ldir to get the working directory, but I would use the "all uniface" implementation because it should work on all databases.