OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Transporting Queries

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
wbaker
Guest





PostPosted: Sun Mar 14, 2004 9:30 pm    Post subject: Transporting Queries Reply with quote

I'd like to deploy my database, queries, and forms with associated fields. I copy the MySql data files and the forms in a straightforward way. However, I can't find the rather complex queries I've built. My workaround is to edit the queries, turn off design view and cut/paste the SQL into a text document. Then, when I copy the data files and forms to the next computer, I cut/paste the queries one by one to rebuild the entire set. That's OK but if there's a more elegant or simple way to do this, I'd appreciate a pointer.

Thanks,
Wil
Back to top
JamesR
General User
General User


Joined: 01 Apr 2004
Posts: 6
Location: Salt Lake City, Utah

PostPosted: Fri Apr 02, 2004 10:56 am    Post subject: Reply with quote

Many kudos to Daniel Strome who posted this info on the gmane newsgroup:
____________________________________________________
In the file
....../user/registry/data/org/openoffice/Office/DataAccess/xcu

Queries look something like:

<node oor:name="Queries">
<node oor:name="query_save_notes_cat_to_file" oor:op="replace">
<prop oor:name="Command" oor:type="xs:string">
<value>select note_cat_id, description ....

And I guess an administrator could have added queries
to the comparable file in ..../share
so they would be available to other users.
Not sure.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group