KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q69343: ISAMCVT Btrieve Specfiles Cannot Have Spaces; Must Use Commas

Article: Q69343
Product(s): See article
Version(s): 7.00 7.10
Operating System(s): MS-DOS
Keyword(s): ENDUSER | docerr SR# S910205-152 | mspl13_basic
Last Modified: 14-FEB-1991

Page 392 of the "Microsoft BASIC 7.0: Programmer's Guide" (for BASIC
PDS 7.00 and 7.10) gives an incorrect example of a Btrieve specfile.
The fields of each entry are incorrectly shown separated by spaces;
instead, the fields should be separated by commas.

ISAMCVT specfiles must not contain spaces.

This information applies to Microsoft BASIC PDS versions 7.00 and 7.10
for MS-DOS.

The specfile on page 392 should be changed to the following:

   string,4,StringCol
   integer,2,IntColumn
   Long,10,LongColumn
   Double,5,DoubleCol

If ISAMCVT is run with this specfile and an appropriate Btrieve file,
the Btrieve file will be successfully converted. Note that the
specfile must specify the format for every column in the Btrieve file
(for both indexes and non-indexes).

Page 392 gives the following incorrect example of a Btrieve specfile:

   string 4 StringCol
   integer 2 IntColumn
   Long 10 LongColumn
   Double 5 DoubleCol

ISAMCVT gives the following error message when using the above
specfile:

   ISAMCVT: Invalid data type 'string 4 StringCol
   ' in line 1 of <specfilename>.

ISAMCVT does not allow spaces as field separators. It is also illegal
to mix commas and spaces as in the next example:

   string, 4, StringCol
   integer, 2, IntColumn
   Long, 10, LongColumn
   Double, 5, DoubleCol

ISAMCVT gives the following error message when using the above
specfile:

   ISAMCVT: Missing or invalid column name in line 1 of <specfilename>

The fields of an ISAMCVT specfile must be separated by commas and no
spaces should be in the file.






Microsoft QuickBASIC
=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 1986-2002.