Click to See Complete Forum and Search --> : Async Middle Tier


April 12th, 1999, 06:31 AM
Has anyone got an example of an Async middle tier or any example where I can get the logic of how to create an Async middle tier?
I would like to populate a table on my client system with data from a database. I am using ADO to talk to the database, but I would like to be able to get a few rows at a time from the middle tier back to the client so I do not have to freeze the client program to download all the data before I can populate the table.
Any suggestions would be greatly appreciated.
If possible could you email me at ds@infra.com.au
Thank you
David Stephen

Lothar Haensler
April 12th, 1999, 07:00 AM
the GetRows method in ADO allows you to specify a number of rows to return. Thus, you can only fetch a few rows and populate your table and continue that process until you get an EOF condition.

ADO 2.0 also support asynchronous execution via the Options Parameter in the Execute method (adAsyncExecute and adAsyncFetch and adAsyncFetchNonBlocking).