Forum at OOoForum.orgThe 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 Forum Index -> Base
View previous topic :: View next topic  
Author Message

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.

Back to top
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

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 Forum Index -> 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