If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > How Convert Ddf In Version 8 To Version 6.15 Or 7

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-05-04, 21:53
natalies natalies is offline
Registered User
 
Join Date: May 2004
Posts: 8
How Convert Ddf In Version 8 To Version 6.15 Or 7

hOW DO I CONVERT THE DDFS WHICH i WROTE IN VERSION 8 BACK INTO A VERSION OF 6.15 OR 7. The reason for this is that the crystal reports engine is using an older version of btreive and keeps on given errors like data buffer length too long error 22. The data files were created by a colleague and it's in a 6.15 format, where as I used version pervasive 8 to create the ddf files, and some how there's a data length mismatch between the data files and ddf files. I did a database consistency test and noticed a difference of 8 bytes in size due to the longvarchar field. The data file my colleage created has a note field
but in the version 8, this is replaced by a longvarchar field which has a size of 8 bytes and I think this is where it's going wrong, so basically what I need is something that can convert my ddf files back into a 6.15 format i.e convert longvarchar fields back to note fields etc.

Last edited by natalies; 05-05-04 at 22:49.
Reply With Quote
  #2 (permalink)  
Old 05-05-04, 23:58
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
Note fields are stored differently than LongVarChar fields. When you created the DDFs, did you select "Advanced Settings" to specify the exisiting data file?
You don't need to "convert" the DDFs to 6.15 format, you need to create them properly. Use the Create Table Wizard and specify "Advanced Settings". This will let you create the table with the Note field (as the last field).
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #3 (permalink)  
Old 05-06-04, 08:36
natalies natalies is offline
Registered User
 
Join Date: May 2004
Posts: 8
How to convert 8.0 ddf files back to 6.15

"Advanced settings" is not the answer since it only shows indexed fields
and all field names are like unused1,unused2 etc, and I can't be manually changing the fieldnames, inserting fields etc. my ddfs are created using an sql script that creates the tables with relevant fields etc,the script creates about 40 tables with at least 20 fields in each, I need a way of converting the ddfs in version back to a 6.15 format at least the longvarchar field needs to be converted to a note field. Is there a way to do this ???????
Reply With Quote
  #4 (permalink)  
Old 05-06-04, 09:40
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
Using script, there is no way to specify a Note data type for the variable length field. You can use DTO/DTI but not in script.
If you have an old install of 7.0 or 6.15 with the ODBC driver, you could do it in script but not in 2000 or V8.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #5 (permalink)  
Old 05-07-04, 15:06
natalies natalies is offline
Registered User
 
Join Date: May 2004
Posts: 8
Where do i get version 6.15 or 7 of pervasive

Where Can I get a version of version 6.15 or 7 of pervasive
basically it's for creating note fields not longvarchar fields, and I want to be able to write the sql script in pervasive in order to create the tables rather than create them manually. Note fields in version 7 are different to longvarchar fields in version 8
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On