Microsoft KB Archive/64100

= BEGINTRANS Example &quot;Invalid Columnname&quot; for Address =

Article ID: 64100

Article Last Modified on 8/16/2005

-

APPLIES TO


 * Microsoft BASIC Professional Development System 7.0
 * Microsoft BASIC Professional Development System 7.1

-



This article was previously published under Q64100



SUMMARY
The BEGINTRANS example on Pages 23-25 of the &quot;Microsoft Basic 7.0: Language Reference&quot; manual for versions 7.00 and 7.10 incorrectly uses &quot;Address&quot; in the Borrower TYPE declaration when trying to OPEN the BOOKS.MDB sample database. The example should use &quot;Street&quot; 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 &quot;Invalid column name&quot; because it tries to OPEN the BOOKS.MDB database (an ISAM file), which actually uses &quot;Street&quot; as a column name instead of &quot;Address.&quot;

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); &quot; &quot;; should read as follows: PRINT LEFT$(People.Street, 25); &quot; &quot;;

Additional query words: BasicCom SR# S900626-73

Keywords: KB64100

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.