variables for commands in DE

[rss000f]

I want to use a variable when working with a command in the data environment, for example (rough example, but you should get my meaning.

DE.rsTable.open 'works


variable = rsTable

DE.variable.open 'doesn't

[sig][/sig]

 

[Collin]

I hope this helps alittle, when you make a Command in the DE, The DE automaticaly makes a variable with the same name as the Command prefixed with "rs".

So for example, if you have a Command named Table, DE will make a variable named rsTable which represents the recordset returned by the Command "Table".

But, to anwser your question

Dim rs as AODB.Recordset

myDe.Table 'Execute the Command "Table"
Set rs = myDE.rsTable 'Now you can use rs in place of rsTable


Collin
[sig][/sig]