A customer called me with a really old Paradox file that he needed to be
imported into a DBIsam (version 2.4)data file.  BDETran hung up half way
through.  I suspected that it was the memo field, so I made a copy of
the Paradox file, deleted its memo field, ran BDETran again, and all the
records came through.

I can live without the old memo field data (or my customer will have
to....)   But now I have to get a memo field back into the DBIsam file.
 I can do that easily enough with DBSys, but the ORDER of the fields is
now different.

Is that important?  I reference data only by persistent fields or by
FieldByName, never by the order of the fields.

If it is important, how can I switch the order of two fields in a dbisam
database?  Currently the memo field is #9, and it should be #8 of nine
fields.

TIA
Jerry Blumenthal

Jerry


Using DBSys - Alter table and use the arrow buttons on the left side. Using SQL something like ALTER TABLE tablename REDEFINE COLUMN IF EXISTS fred AT newposition

Roy Lambert

"Jerry Blumenthal" <jerry@blumenthalsoftware.com> wrote in message
news:20FF2026-9104-4F9D-AE4F-3A36E4E1C4F3@news.elevatesoft.com...
>
> Is that important?  I reference data only by persistent fields or by
> FieldByName, never by the order of the fields.
>
+
Then you should be OK.

Robert

Jerry,

<< A customer called me with a really old Paradox file that he needed to be
imported into a DBIsam (version 2.4)data file.  BDETran hung up half way
through.  I suspected that it was the memo field, so I made a copy of the
Paradox file, deleted its memo field, ran BDETran again, and all the records
came through.

I can live without the old memo field data (or my customer will have
to....)   But now I have to get a memo field back into the DBIsam file.
I can do that easily enough with DBSys, but the ORDER of the fields is now
different. >>

How are you going to get the data out of Paradox without using the BDE ?
BDETran uses the BDE and a simple TTable component for reading the data in
from Paradox, so if there's an issue there, then I'm not sure you'll be able
to work around it if you intend to use the same type of access.

--
Tim Young
Elevate Software
www.elevatesoft.com