#118 Lost database in mdb-sql

[Anonymous]

emorales@sepsaver.com

First all off thanks for a great tool, I just want to help you improving your great tool by issuing the following bug report:

If you try:

=> describe table MSysObjects
2 => go

+------------------------------+--------------------+----------+
|Column Name                   |Type                |Size      |
+------------------------------+--------------------+----------+
|Id                            |Long Integer        |4         |
|ParentId                      |Long Integer        |4         |
|Name                          |Text                |510       |
|Type                          |Integer             |2         |
|DateCreate                    |DateTime \(Short\)    |8         |
|DateUpdate                    |DateTime \(Short\)    |8         |
|Owner                         |Unknown 0x09        |510       |
|Flags                         |Long Integer        |4         |
|Database                      |Memo/Hyperlink      |0         |
|Connect                       |Memo/Hyperlink      |0         |
|ForeignName                   |Text                |510       |
|RmtInfoShort                  |Unknown 0x09        |510       |
|RmtInfoLong                   |OLE                 |0         |
|Lv                            |OLE                 |0         |
|LvProp                        |OLE                 |0         |
|LvModule                      |OLE                 |0         |
|LvExtra                       |OLE                 |0         |
+------------------------------+--------------------+----------+
17 Rows retrieved

It's O.K., But if you try to get the fields immediatly:

1 => select name,type from msysobjects
2 => go

msysobjects is not a table in this database

You can't even describe it anymore:

1 => describe table MSysObjects
2 => go
MSysObjects is not a table in this database

You should exit the mdb-sql command line tool, and then retry:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1 => quit
% mdb-sql file.mdb
1 => select Name,Type from MSysObjects
2 => go
[...]
89 Rows retrieved