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

[digitaljunkie]

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?

[Ender]

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.

[digitaljunkie]

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.

[comment]

How about:

Go to Layout [ 1 ]

Loop

Show All Records

Exit Loop If [ Get ( LayoutNumber ) = Get ( LayoutCount ) ]

Go to Layout [ Get ( LayoutNumber ) + 1 ]

End Loop

[digitaljunkie]

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 May 3, 2006 by Guest

[comment]

I don't think there's a way to do this - at least not reliably enough.