Subject Re: How to use a Dbase app on two geographically diverse locations
From Ken Mayer <>
Date Sat, 13 Jan 2018 07:08:05 -0800
Newsgroups dbase.getting-started

On 1/13/2018 6:25 AM, Akshat Kapoor wrote:
> On 13/01/2018 18:38, Ronnie MacGregor wrote:
>> In article <6HRfZUFjTHA.1828@ip-AC1E04A7>,
>> says...
>>> Modified the user access and now the connection was successful.
>> Good stuff !!
> Another small query
> Question 1.
> If I use the executesql method of ADOdatabase what will be the
> limitations of sql command,
> 1. Subset of SQL provided by BDE
> 2. Limitations of SQL Server if any. All commands taught by w3schools
> are allowed

executeSQL() bypasses the BDE and sends information to the server.
ADODatabase is meant to bypass the BDE as well, so that should take it
out of the equation.

> Question 2
> Difference between Query class and ADOquery Class
> As far as my limited knowledge goes Query class uses BDE for its
> operations whereas in case of ADOquery the query is passed on to the SQL
> server directly for processing.

Same as above.


*Ken Mayer*
Ken's dBASE Page:
The dUFLP:
dBASE Books:
dBASE Tutorial: