HEEEELP : Converting Table to new LangDriver 
Author Message
 HEEEELP : Converting Table to new LangDriver

I developed an application with D4 using Paradox tables.
My customer gets a liottle bit annoying (I'd like to have THIS
and THAT report...) so that I tried to give them a possibility
to create their own reports - using Access because they know it.

Now : I found Access can only use Paradox tables when they are
in "Paradox ascii" format, I created all the tables with the
"Paradox intl" language driver.

When I convert them a lot of letters disappear
(special char's - Umlauts - specific to german)

Now, is there something that can rescue me ?

Help me, I am desperate !!!!!!!
Thanks,
Ralf



Wed, 18 Jun 1902 08:00:00 GMT
 HEEEELP : Converting Table to new LangDriver


Quote:
>I developed an application with D4 using Paradox tables.
>My customer gets a liottle bit annoying (I'd like to have THIS
>and THAT report...) so that I tried to give them a possibility
>to create their own reports - using Access because they know it.

>Now : I found Access can only use Paradox tables when they are
>in "Paradox ascii" format, I created all the tables with the
>"Paradox intl" language driver.

>When I convert them a lot of letters disappear
>(special char's - Umlauts - specific to german)

>Now, is there something that can rescue me ?

>Help me, I am desperate !!!!!!!
>Thanks,
>Ralf

I'm know one way.
First you need create new Paradox tables in new Folder with usung new
character set.
Let's take names OldDataBase and New DataBase - old and new folders with
Paradox tables and make simle program. This programm defined Two TDataBase
component in
own data Module. One component named OldDataBase and point to old Paradox
tables
and NewDataBase point to new Paradox tables.  For onCreate event (of this
Data Module)
makes mesod with fill some StrigList (let's call it as TableList) for Table
names :
 TableList.Add('TableName1'); .................
Than defined two TTable component - OldTable and NewTable and cross its with
Old and
New DataBase Components (This tables muust be undefined TableName
properties).
Follow procedure convert information between DataBases :
procedure DataModule.Convert;
var
  TableIndex : Integer;
  FieldIndex : Integer;
begin
  for TableIndex :=0 to TableList.Counter - 1 do begin
   OldTable.TableName := TableList[TableIndex];
   NewTable.TableName := TableList[TableIndex];
   OldTable.Open;
   NewTable.Open;
   if OldTable.FindFirst then repeat
     NewTable.Append;
     for FieldIndex := 0 to NewTable.FieldCount - 1 do
       if NewTable.Fields[FieldIndex].DataType in [ ftString, ftMemo,
ftFmtMemo ] then
         NewTable.Fields[FieldIndex].AsString  :=
OldTable.Fields[FieldIndex].AsString
                                   {  !!! take convert effect throuth string
type only}
       else
         NewTable.Fields[FieldIndex].Assign( OldTable.Fields[FieldIndex])
     NewTable.Post;
   until not OldTable.FindNext;
   OldTable.Close;
   NewTable.Close;
 end;
end;
...................
CAUTION !
Don't use TBathMove component or Datapump utility, because its don't take
convertation effect.

Good Luck
          Yaroslav ( Delphi programmer )

PS.  Sorry for my bad English



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How can I change LANGDRIVER of table programatically?

2. Copying database tables to new tables (haviing new fields)

3. Update data in a table when a new table with new datas is created

4. changing LANGDRIVER at runtime

5. BDE langdriver

6. Changing Paradox LangDriver in Code

7. Delphi 1: Change langdriver at runtime

8. several LANGDRIVER with DBASE

9. LangDriver?

10. LANGDRIVER

11. Changing LANGDRIVER at runtime

12. BDE LANGDRIVERS


 
Powered by phpBB® Forum Software