Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Restructure problem |
Tue, Apr 18 2006 10:45 PM | Permanent Link |
Jerry Blumenthal | 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 |
Wed, Apr 19 2006 3:36 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Wed, Apr 19 2006 7:39 AM | Permanent Link |
"Robert" | "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 |
Wed, Apr 19 2006 8:40 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Friday, April 26, 2024 at 05:32 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |