Board index » delphi » Paradox questions (2)

2003-10-11 07:16:02 PM
delphi175
Hello to the Group
I have already posted 2 questions but with no luck.
( Paradox - Delphi_6 )
Can anyone give me a point ?
1) what parameters should I set in BDE Admin to have
the less of problems with accented letters (Italian)
in database jobs (select,find,locate...) ?
particolarly in data importing.
2) Is it allowed to change key_fields in a database
Paradox ? ( & Interbase ? )
I used code like this:
with Query2 do begin
sql.Clear;
sql.add('update sentences');
sql.add('set argument_1 = :new_argument');
sql.add('where argument_1 = :old_argument');
ParamByName('old_argument').Asstring := i_var_arg_from.text;
ParamByName('new_argument').Asstring := i_var_arg_to.text;
ExecSQL;
end;
the result was always that the records after the 16?
all had their memo_field cleared. It seems that changing
the key fields, the links with records in .MB file
are lost.
Thank you much for your time.
Giovanni.
 

"Giovanni Filippini" <XXXX@XXXXX.COM>writes:
it might be the same to Italy since Portuguese and Italian both derive from
Latin.
So I configured all the BDE to "intl850" and I didn't have any troubles
since.
Also, since I never know if every computer my system runs is configured to
this language driver, I include this when connecting a Tdatabase:
with Database1 do
begin
Connected := false;
Params.Values['LANGDRIVER'] := 'intl850';
Connected := true;
end;
And I force their BDE configuration calling this procedure:
procedure TForm1.UpdateBDELang;
var
Reg : TRegistry;
const
BDE_LOCAL_SHARE_KEY = '\Software\Borland\Database
Engine\Settings\SYSTEM\INIT';
begin
Reg := TRegistry.Create;
With Reg Do
begin
RootKey := HKEY_LOCAL_MACHINE;
{ Write the BDE keys }
OpenKey(BDE_LOCAL_SHARE_KEY, True);
WriteString('LOCAL SHARE', 'TRUE');
WriteString('LANGDRIVER', 'intl850');
end;
Reg.Free;
end;
Bye,
Marcio Ehrlich
 

Ciao Giovanni,
ho visto la tua domanda su Paradox. Stai iniziando adesso ad usarlo ? Se si
tratta di un prodotto commerciale non te lo consiglio. Io l'ho usato per
molto tempo e con tanti problemi. Instabilit? perdita di dati in
continuazione. Se sei ancora in tempo il consiglio ?di cambiare...
Roberto
"Giovanni Filippini" <XXXX@XXXXX.COM>ha scritto nel messaggio

Bill, Marcio, Roberto,
Thank you much for your reply.
I am using BDE 5.01 & Paradox v. 7
installed with Delphi_3 & then Delphi_6.
I now solved by not modifying key_fields 'via'
Update_Sql but Deleting + Writing new records and
all is OK.
Roberto, I use Paradox for non critical apps from Delphi_1
with no problems except these ones reported, ciao.
Regards Giovanni.
 

lucky :)