Hello Barbara, > When I tried this as a query, that didn't work either: > > SQL Status: 00000 > Error code: -155 > > Statement does not generate a result set
Just as explanation, as you already found your way: This message says you executed the statement in the query designer. The designer is intended for SELECT commands, that is, commands which return data to display and maybe edit. An "administrative" command (it depends on the definition of "administrative" whether the online help is right with its claim) as yours does not produce any data - thus their execution might even succeed, but as soon as OOo asks the database engine for the resulting data, you will get the above error. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
