- Code: Select all
update "C:\Users\UserOne\Desktop\TRANSACT.DBF" t
where t.csr=''
set t.csr = (select substr(i.c, 1, 2)
from "C:\Users\UserOne\Desktop\INS.DBF" i
where substr(t.pol_idx, 1, 7) = i.rec
and i.key = 'C')
...returns the following error...
" -> File 'transact.dbf t' does not exist "