Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Use REPAIR TABLE syntax in dbsys v3.3
Wed, Jun 11 2008 6:04 PMPermanent Link

KSD
Is it possible to issue REPAIR TABLE statement from SQL window in dbsys v3.3. The table is version 3.0. Getting following error message:
DBISAM Engine Error #11949 SQL Error - SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, or DROP keyword expected, instead found 'REPAIR'

Can I repair table without GUI in dbsys? Need command line utility that is compatible with version 3 database.

Wed, Jun 11 2008 6:08 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Karen,

<< Is it possible to issue REPAIR TABLE statement from SQL window in dbsys
v3.3. The table is version 3.0. Getting following error message:
DBISAM Engine Error #11949 SQL Error - SELECT, INSERT, UPDATE, DELETE,
CREATE, ALTER, or DROP keyword expected, instead found 'REPAIR' >>

You can repair a table in the 3.x DBSYS utility, but you must do it via
Utilities menu option.

<< Can I repair table without GUI in dbsys? Need command line utility that
is compatible with version 3 database. >>

Yes, but you would have to write such a command-line utility.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image