DATA ENVIRONEMENT

[jtm7699]

using Data Environment Connections I have main command. It is just an SQL statment. To make a report work properly I had to put in a Child command. Now I want to use the same SQL, but this time in code. How can I access the child command. I do not see it showing up any where.

thnks

[Nathan]

The child command actually is a recordset stored in your last field in the parent command. To access it you have to save the contents of the field into another recordset.

If you will be doing the SQL in your code it might be easier to setup the SQL Code using the SHAPE command...

[jtm7699]

how can i save the recordset to another recordset?

[Nathan]

I haven't actually done it in a while as I've switched to just using the shape command but I'll see if i can find out more for you.