Jump to content

Universal Script to View All..? (prep for export)


This topic is 5691 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Ok when upgrading a client from any version of our system we have a script that goes to each individual layout and shows all records so that every table, racord accross the database is found.

Different clients obviously may have different layouts so its extremely slow to build this script as I have to ensure every table, layout etc is covered in this script.

If there a way of building a script that does something like this...

Show all records on all layouts?

or

automatically goes through each individual layout and shows all?

Link to comment
Share on other sites

If the file is closed, then imports from that file will pull all records from the selected table.

Different clients obviously may have different layouts so its extremely slow to build this script as I have to ensure every table, layout etc is covered in this script.

I'm afraid it is not so obvious why 'different clients may have different layouts'. If "clients" are records, then different clients should be using the same structure and layouts.

Link to comment
Share on other sites

Sorry clients being our clients that we install our solution into as in the end user "client".

Hence say one client may have a custom layout, script, table etc. While another may havbe something slightly different.

I hope that makes sense.

Link to comment
Share on other sites

Thanks that looks like that will work, awesome job thankyou.

Is there a way to do something similar for this script...

We have a "Set Serial Values to 1" script.

What this does is...

---

Go to Layout ["My Layout" (Dummy Table)]

Set Next Serial Value [Dummy Table::dummy ID; 1]

---

See I have to print off or cross reference every layout that uses an auto enter serial to ensure that that layout is in this script.

Is there a way of sripting a script like...

---

Go to Layout [1]

Loop

(Ideal script input - if auto enter serial on or true then show all records.)

Then proceed the script through each layout count, as comments post indicates?

---

Edited by Guest
Link to comment
Share on other sites

This topic is 5691 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.