 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Giovanni Filippini
Guest
|
 Posted: Sat Oct 11, 2003 11:16 am Post subject: Paradox questions (2) |
 |
|
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.
|
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Sat Oct 11, 2003 2:00 pm Post subject: Re: Paradox questions (2) |
|
|
I am not sure which language driver is the best choice for Italian.
Perhaps someone else can help with this.
The only solution to the second problem is to not use a query to
update the key field. Use a TTable with FindKey or SetRange. What
version of the BDE are you using?
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Marcio Ehrlich
Guest
|
| Posted: Sat Oct 11, 2003 2:52 pm Post subject: Re: Paradox questions (2) |
|
|
"Giovanni Filippini" <filippinig (AT) ciaoweb (DOT) it> wrote:
| Quote: | 1) what parameters should I set in BDE Admin to have
the less of problems with accented letters (Italian)
in database jobs
|
Here in Brazil I use the Paradox International 850 language driver. I guess
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 = 'SoftwareBorlandDatabase
EngineSettingsSYSTEMINIT';
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
|
|
| Back to top |
|
|
Roberto Nicchi
Guest
|
| Posted: Sat Oct 11, 2003 6:50 pm Post subject: Re: Paradox questions (2) |
|
|
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" <filippinig (AT) ciaoweb (DOT) it> ha scritto nel messaggio
news:3f87e5f8 (AT) newsgroups (DOT) borland.com...
| Quote: | 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.
|
|
|
| Back to top |
|
|
Giovanni Filippini
Guest
|
| Posted: Sun Oct 12, 2003 11:01 am Post subject: Re: Paradox questions (2) |
|
|
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.
|
|
| Back to top |
|
|
Roberto Nicchi
Guest
|
| Posted: Sun Oct 12, 2003 4:35 pm Post subject: Re: Paradox questions (2) |
|
|
lucky :)
| Quote: | Roberto, I use Paradox for non critical apps from Delphi_1
with no problems
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
