[Application]
path=<путь_к_программе_или_папке>
SELECT region, city FROM regions_cities_table AS t;
UPDATE clients_table SET region = t.region WHERE city = t.city;
UPDATE clients_table SET clients_table.region = DCount("*","%таблица_соответствия%","%таблица_соответствия%.city='" & clients_table.city & "'")
with DB do
begin
Connected := false;
DatabaseName := 'localhost:C:\Program Files (x86)\Borland\Delphi7\Projects\Project\DATABASE.fdb';
Params.Clear;
Params.Add('user_name=SYSDBA');
Params.Add('password=masterkey');
Params.Add('lc_ctype=WIN1251');
LoginPrompt := false;
SQLDialect := 3;
Connected := true;
end;