BEGINTRANS Example "Invalid Columnname" for Address (64100)



The information in this article applies to:

  • Microsoft Basic Professional Development System for MS-DOS 7.0
  • Microsoft Basic Professional Development System for MS-DOS 7.1

This article was previously published under Q64100

SUMMARY

The BEGINTRANS example on Pages 23-25 of the "Microsoft Basic 7.0: Language Reference" manual for versions 7.00 and 7.10 incorrectly uses "Address" in the Borrower TYPE declaration when trying to OPEN the BOOKS.MDB sample database. The example should use "Street" instead.

This information applies to Microsoft Basic Professional Development System (PDS) versions 7.00 and 7.10.

MORE INFORMATION

The BEGINTRANS example gives the error message "Invalid column name" because it tries to OPEN the BOOKS.MDB database (an ISAM file), which actually uses "Street" as a column name instead of "Address."

The following lines of the code example should be changed as follows:

Page 23

The following line
   Address AS STRING * 50        'Address
				
should read as follows:
   Street AS STRING * 50         'Street address
				

Page 24

The following line
   PRINT LEFT$(People.Address, 25); "  ";
				
should read as follows:
     PRINT LEFT$(People.Street, 25); "  ";
				

Modification Type:MinorLast Reviewed:8/16/2005
Keywords:KB64100