Databases
StackOverflow2013
Postsdbo
POWhat standard does BDE use for .sch schema files?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat standard does BDE use for .sch schema files?
    primarykey
    data
    text
    <p>I was wondering - is there a standard (like a RFC) for the .sch schema file format the BDE uses?</p> <p>The format is described <a href="http://wall.riscom.net/books/delphi/del_tis/TI2844.html" rel="nofollow noreferrer">here</a> and <a href="http://www.href.com/pub/source/D1AsciiDriver.txt" rel="nofollow noreferrer">here</a>. It seems based on <a href="http://msdn.microsoft.com/en-us/library/ms709353.aspx" rel="nofollow noreferrer">this Microsoft format</a>, but it's not quite the same.</p> <h2>Example 1 - VARYING format file</h2> <p>CUSTOMER.SCH:</p> <pre><code>[CUSTOMER] Filetype=VARYING Delimiter=" Separator=, CharSet=ascii Field1=Customer No,Float,20,04,00 Field2=Name,Char,30,00,20 Field3=Phone,Char,15,00,145 Field4=First Contact,Date,11,00,160 </code></pre> <p>CUSTOMER.TXT:</p> <pre><code>1221.0000,"Kauai Dive Shoppe","808-555-0269",04/03/1994 1231.0000,"Unisco","809-555-3915",02/28/1994 1351.0000,"Sight Diver","357-6-876708",04/12/1994 1354.0000,"Cayman Divers World Unlimited","809-555-8576",04/17/1994 1356.0000,"Tom Sawyer Diving Centre","809-555-7281",04/20/1994 </code></pre> <h2>Example 2 - FIXED format file</h2> <p>CUSTOMER.SCH:</p> <pre><code>[CUSTOMER] Filetype=Fixed CharSet=ascii Field1=Customer No,Float,20,04,00 Field2=Name,Char,30,00,20 Field3=Phone,Char,15,00,145 Field4=First Contact,Date,08,00,160 </code></pre> <p>CUSTOMER.TXT:</p> <pre><code> 1221.0000Kauai Dive Shoppe 808-555-0269 04/03/94 1231.0000Unisco 809-555-3915 02/28/94 1351.0000Sight Diver 357-6-876708 04/12/94 1354.0000Cayman Divers World Unlimited 809-555-8576 04/17/94 1356.0000Tom Sawyer Diving Centre 809-555-7281 04/20/94 </code></pre> <p>I'm especially interested in the possible argument-values for 'Filetype', 'Delimiter', 'Separator' and 'CharSet'. I've searched the internet using various terms ('RFC', 'schema', 'filetype', 'standard', etc), but came up blank... </p> <p>Things I would like to know specifically :</p> <ul> <li>What encoding(s) can be used for the .sch file itself? (This is relevant for correctly interpreting the fieldnames and other configurable characters.)</li> <li>How should I specify non-printable Separator and Delimiter characters, for example an Ansi control-character like "Unit Separator" ($1F) or even a simple "Tab" ($09)? (Given the age of the format I think I should use Caret notation, but it'd just like to be sure.)</li> <li>How can I specify to not-use a Delimiter? Should I specifiy an empty value, or leave the setting out altogether?</li> </ul> <p>TIA</p> <p>PS: Note, I'm not using the BDE itself - it's just these schema files that I have to generate and read correctly.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBinaryMisfit
    1. USPatrickvL
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhat standard does BDE use for .sch schema files?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhat standard does BDE use for .sch schema files?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload