Problem with porting old DBase3 files to pdx

Problem with porting old DBase3 files to pdx

Post by Carlo Trawni » Sun, 31 Dec 1899 09:00:00



Hi there all,

the problems never end.
I have to move old DBase III plus - files , used in a Clipper/DOS programm
to pdx - files , so I can use the datas in a Delphi4 program.
I do this with a batchmove.
That works fine.
But now there are 2 problems :

1)  after a batchmove I get all german special charakters (like ? , ?, ,
?) as
another charakter ->  from ?   to TM , and so on. What can I do ???

2) is it possible with batchmove to update a field only if required ?
example : there is a database with many different Article-no. and one field
to compare
the articles with same number. So if in the comparison field is the same
OEM-number,
I can compare the different article-no using the comparison-no.
If I get a new database of articles, I have to update the old ones, but I
dont want to overwrite
a comparison-field  where I filled in a comparison-no. Up to now, if there
comes in a new database, and I do the update with a batchmove, I allways
overwrite that comprison field.
Is it possible to make any exclusion for a field, if the value is <>'   ' ,
or do I have to use another command than Batchmove, which is pretty fast.
All tries with a do-while-not-eof or similar things uses a lot of time a a
database size of more than 600.000 sentences.

Many thanks for every answer.

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Have A Nice Day
+++++++++++++++++++++++++++++++++++++++++++++++++++++
carlo trawnik
+++++++++++++++++++++++++++++++++++++++++++++++++++++

 
 
 

Problem with porting old DBase3 files to pdx

Post by HAEREN » Sun, 31 Dec 1899 09:00:00


The special characters are almost certainly a result of having special
DOS-characters (language specific) that are not translated to the
corresponding Windows-characters. A utility to change from OEM to ANSI was
shipped with dbFast (same "factory" as Clipper), others may exist, or you
can write your own.

Alex



Quote:> Hi there all,

> the problems never end.
> I have to move old DBase III plus - files , used in a Clipper/DOS programm
> to pdx - files , so I can use the datas in a Delphi4 program.
> I do this with a batchmove.
> That works fine.
> But now there are 2 problems :

> 1)  after a batchmove I get all german special charakters (like ? , ?, ,
> ?) as
> another charakter ->  from ?   to TM , and so on. What can I do ???

> 2) is it possible with batchmove to update a field only if required ?
> example : there is a database with many different Article-no. and one
field
> to compare
> the articles with same number. So if in the comparison field is the same
> OEM-number,
> I can compare the different article-no using the comparison-no.
> If I get a new database of articles, I have to update the old ones, but I
> dont want to overwrite
> a comparison-field  where I filled in a comparison-no. Up to now, if there
> comes in a new database, and I do the update with a batchmove, I allways
> overwrite that comprison field.
> Is it possible to make any exclusion for a field, if the value is <>'   '
,
> or do I have to use another command than Batchmove, which is pretty fast.
> All tries with a do-while-not-eof or similar things uses a lot of time a a
> database size of more than 600.000 sentences.

> Many thanks for every answer.

> --
> +++++++++++++++++++++++++++++++++++++++++++++++++++++
> Have A Nice Day
> +++++++++++++++++++++++++++++++++++++++++++++++++++++
> carlo trawnik
> +++++++++++++++++++++++++++++++++++++++++++++++++++++


 
 
 

Problem with porting old DBase3 files to pdx

Post by Paul Ferrar » Sun, 31 Dec 1899 09:00:00


You could have just used the dBase III files and saved yourself a lot of
trouble, not to mention all the problems associated with pdox files to begin
with.

Paul / ColumbuSoft
www.columbusoft.com


Quote:> Hi there all,

> the problems never end.
> I have to move old DBase III plus - files , used in a Clipper/DOS programm
> to pdx - files , so I can use the datas in a Delphi4 program.
> I do this with a batchmove.
> That works fine.
> But now there are 2 problems :

> 1)  after a batchmove I get all german special charakters (like ? , ?, ,
> ?) as
> another charakter ->  from ?   to TM , and so on. What can I do ???

> 2) is it possible with batchmove to update a field only if required ?
> example : there is a database with many different Article-no. and one
field
> to compare
> the articles with same number. So if in the comparison field is the same
> OEM-number,
> I can compare the different article-no using the comparison-no.
> If I get a new database of articles, I have to update the old ones, but I
> dont want to overwrite
> a comparison-field  where I filled in a comparison-no. Up to now, if there
> comes in a new database, and I do the update with a batchmove, I allways
> overwrite that comprison field.
> Is it possible to make any exclusion for a field, if the value is <>'   '
,
> or do I have to use another command than Batchmove, which is pretty fast.
> All tries with a do-while-not-eof or similar things uses a lot of time a a
> database size of more than 600.000 sentences.

> Many thanks for every answer.

> --
> +++++++++++++++++++++++++++++++++++++++++++++++++++++
> Have A Nice Day
> +++++++++++++++++++++++++++++++++++++++++++++++++++++
> carlo trawnik
> +++++++++++++++++++++++++++++++++++++++++++++++++++++

 
 
 

Problem with porting old DBase3 files to pdx

Post by Carlo Trawni » Sun, 31 Dec 1899 09:00:00


thanks for answer, but it doesnt solve my problem.

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Have A Nice Day
+++++++++++++++++++++++++++++++++++++++++++++++++++++
carlo trawnik
+++++++++++++++++++++++++++++++++++++++++++++++++++++

 
 
 

Problem with porting old DBase3 files to pdx

Post by Carlo Trawni » Sun, 31 Dec 1899 09:00:00


thanks for your answer.
do you know the name of the utility ?

regards   Carlo

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Have A Nice Day
+++++++++++++++++++++++++++++++++++++++++++++++++++++

catsoft
small busines software solutions

carlo trawnik
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Homepage      : http://www.ctv.es/CATSOFT/index.html
Bikeware Home : http://www.ctv.es/CATSOFT/home.html
Kataloge      : http://www.ctv.es/CATSOFT/login.htm



> The special characters are almost certainly a result of having special
> DOS-characters (language specific) that are not translated to the
> corresponding Windows-characters. A utility to change from OEM to ANSI was
> shipped with dbFast (same "factory" as Clipper), others may exist, or you
> can write your own.

> Alex



> > Hi there all,

> > the problems never end.
> > I have to move old DBase III plus - files , used in a Clipper/DOS
programm
> > to pdx - files , so I can use the datas in a Delphi4 program.
> > I do this with a batchmove.
> > That works fine.
> > But now there are 2 problems :

> > 1)  after a batchmove I get all german special charakters (like ? , ?,
,
> > ?) as
> > another charakter ->  from ?   to TM , and so on. What can I do ???

> > 2) is it possible with batchmove to update a field only if required ?
> > example : there is a database with many different Article-no. and one
> field
> > to compare
> > the articles with same number. So if in the comparison field is the same
> > OEM-number,
> > I can compare the different article-no using the comparison-no.
> > If I get a new database of articles, I have to update the old ones, but
I
> > dont want to overwrite
> > a comparison-field  where I filled in a comparison-no. Up to now, if
there
> > comes in a new database, and I do the update with a batchmove, I allways
> > overwrite that comprison field.
> > Is it possible to make any exclusion for a field, if the value is <>'
'
> ,
> > or do I have to use another command than Batchmove, which is pretty
fast.
> > All tries with a do-while-not-eof or similar things uses a lot of time a
a
> > database size of more than 600.000 sentences.

> > Many thanks for every answer.

> > --
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Have A Nice Day
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++
> > carlo trawnik
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++

 
 
 

1. Importto PDX/DELPHI - MicroFocus COBOL *.dat/*.idx file pair contents from old APPlication

I have a client that has an old (converted from HP3000 COBOL)
Microfocus COBOL application.  He wants a new client server DB
application built, but needs the data ported out.  The MFCOBOL
APPLICATION is run time only and the relationship with the old
developer is broken.  No chance of using COBOL.

Does anyone know of a way to port out the MFCOBOL Files into    
TEXT so that I can import it into a PDOX / Delphi environment for  
Queries and new development conversion and testing??

I am not looking for a conversionservice, but rather a utility.

I have heard that MSAccess may do this, but I do not want to spend the
bucks on Access just to find out.

Thanks,

Joe McGlohen

2. DTS

3. req ; paradox and old dbase3

4. query update

5. ADO for DBase3 file problem

6. Memory Leak with a DLL connecting to a database

7. ADO and dbase3 file problem

8. Data control refresh.

9. Agonizing over Pdx 8 over 7, and a significant Pdx 8 problem (HELP)

10. problems with replacing values in pdx-file

11. Problem inserting new records in PDX 5-file

12. Approach 96 with PDX.db - need help porting MRP from SC4