Data Environment

[audiopro]

Many of my forms use a data environment with relationships between tables. Sometimes it is necessary to change the order of one of the tables'
Is there a restore original data environment option or has this to be coded?

Keith

http://www.studiosoft.co.uk

 

[Dan Freeman]

There's nothing automatic. You'll have to remember the original setting and put it back when done (just like SET TALK, SET EXACT, etc.)

You might find it less effort to try this:

USE theTable AGAIN ALIAS otheralias ORDER WHATEVER

This second instance of the table will be in the order you want, but it won't affect the instance held by the DE.

 

[audiopro]

If I return the orders of the tables to the start settings, do the relationships restore themselves too?

Keith

http://www.studiosoft.co.uk

 

[Imaginecorp]

You can turn off the relationship with a
set relation off into <<tablename>>

and when needed reset it back with a
Set relation to <expression> into <<childtable>>

check out the help...

 

[audiopro]

check out the help

My MSDN disks are hiddden away after several house moves. I will find them when I have some time.

Keith

http://www.studiosoft.co.uk

 

[Imaginecorp]

its simple;
Parent table = Customers
Child Table = Customer_address

select customer
set relation off into customer_address

to reset:
select customer
set relation to <<id>> into customer_address