PRB: Capital "S" Not Displayed When Using the Text ISAM

• Microsoft Visual Basic Standard, Professional, and Enterprise Editions for Windows, version 4.0

SYMPTOMS

Text files that contain a capital "S" in a column by themselves display as "0". The rest of the characters for that column are not displayed.

STATUS

This behavior is by design.

MORE INFORMATION

The text file is not in the format Visual Basic expects it to be in. Visual Basic expects to find "" around each and every entry in the text file.

Steps to Reproduce the Problem

1. Create a text file with following text. Save it as a text file.

   
   
         FirstName, MiddleInitial, LastName, age, address
         Chris ,B ,Barr ,30 , 200 main st
         Charles ,S, Sterling, 27 ,100 1st street 




2. Start Visual Basic. Form1 is created by default.



3. Add a data control to form1.



4. In the properties for the data1 control, choose Text for the connect property and select the text file for the database name.



5. Add a DBGrid control to the form and select Data1 as the datasource.



6. Run the project (press F5). Results:

   
         Chris       Barr      30  200 main st
         Charles  0  Sterling  27  100 1st street 

   The "B" middle initial (in the first record) is now blank. The "S" middle initial (in the second record) is now a "0".

Resolution

   "FirstName", "MiddleInitial", "LastName", "age", "address"
   "Chris","B","Barr",30,"200 main st"
   "Charles","S","Sterling",27,"100 1st street" 

REFERENCES

For more information on the Text ISAM and Accessing Data in a Text Document, search for the keyword "schema.ini" in the Visual basic Online help.

Additional query words: 4.00 vb4win vb4all

Keywords : kbDatabase kbIISAM
Version : WINDOWS:4.0
Platform : WINDOWS
Issue type : kbprb