Dbschema
Posted in 1995
I am using dbschema to duplicate a database structure in a newly created
instance of OnLine 7.1. I have used dbschema before, yet I still have
questions based on a recent experience:
1) If I use dbschema to create a schema file, from a working database,
why would the use of the schema file in creating a new database
structure generate an error (#201 - Synatx error)?
2) When I run the schema SQL commands from within the isql interface
and reach the error, I escape to my editor . At that point I remove
all of the statements ABOVE and including the offending statement
assuming that ONLY those satements have run.
When I re-run what I have left, if
the first statement is a "CREATE TABLE ..." statement, I get a new
error message: table already created. How could that table have been
created,if the running of the schema file bombed out at the
statement above?
Please e-mail and post. Thank you
--
-----------------------------------------------------------------------------
Do unto others ... then split!
MaryAnne Stasium
-----------------------------------------------------------------------------