>>Basically I create cursor using Data Adapters in forms.
>>
>>
>>WITH Thisform.DataEnvironment.&tcCursorName
>> .Alias = tcCursorName
>> .DataSourceType = "ODBC"
>> .Datasource = (oApp.nConnectionHandle)
>> .Name = tcCursorName
>> .Selectcmd = "SELECT * FROM Users "
>> .Tables = "Users"
>>ENDWITH
>>
>>Now if I'm querying data outside of any form, how do I use the cursor adapter to get this data? Create a DEClass Object under _Screen and add it to it? Or is there another way of doing it?
>>
>>Thanks.
>
>Roy,
>CA doesn't need a DE or form. There are many samples here on UT. For example Message #
906597>Cetin
I use Mark McCasland's CursorAdapter Builder at:
http://www.mctweedle.com/mjtools.mjIt is free.
It works great to build CursorAdapters as classes.
- Andy Rice
San Diego, CA