Re: S1000 error

Hi Keith,

> I made a few changes in a MySQL database that my Base application
> connects to via the java connector and now I cannot open a form that
> references the table that I made changes to.
> 
> It gives the following:
> 
> SQL Status: S1000
> 
> The document "Register/frmSales" could not be opened.

This sounds like a problem with the embedded database document, not with
the database/table. Unfortunately, looking at the code, this is the
"something went wrong and I can't figure out what"-message, which can
mean anything.

If you can read a little XML, and operate a ZIP tool, I suggest you have
a look into the content.xml inside the .odb file, look for your form
name, find the "xlink:href" attribute besides it (it will have a value
like "forms/Obj11"), and check whether a folder with this name (still)
exists in your .odb file. That's the only "remote" analysis idea I'd
have ...

Except, of course, reverting to a backup version of your odb file :-\

Ciao
Frank

-- 
- Frank Schönheit, Software Engineer         [email protected] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -