Subject Re: complex indexes vs index key fields From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Tue, 28 Jul 2020 17:29:10 +0530 Newsgroups dbase.getting-started On 28.07.2020 17:02, Gaetano De Luisi wrote: > > HI Akshat, > > I opened and SET the database to the BDE alias I created, then USE the table and APPEND FROM the DBF file on my computer. > > The 64-bit did not seem to work. It was unsuccessful until I deleted the ODBC DSN I had created with the 64-bit version. I don't have enough understanding of that to comment any further, all I can say is that the 32-bit version of the ODBC connector works. > > I will look into ADO, I have never used it before. In this matter we are 2 sides of a coin. I have never used BDE to access mysql For using ADO I would recommend building a test file on the following pattern adodb = new adodatabase() //adodb.connectionstring = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=muneem;UID=root;PWD=;Port=3306;option=71303680" //adodb.connectionString = "Driver={MySQL ODBC 8.0 Unicode Driver};Server=localhost;Database=muneem;UID=root;PWD=;Port=3306;option=71303680" adodb.connectionstring = "Driver={MariaDB ODBC 3.1 Driver};Server=localhost;Database=muneem;UID=root;PWD=;Port=3306;option=71303680" adodb.active = true q = new adoquery() q.database = adodb q.sql = "select * from reminder order by due_date " q.active = true The above lines have multiple connection strings for variety of drivers. Use the one you are using and remove the rest. You would be required to change other info like the database name, userid etc. to suit your needs. If it runs without error then you can use the executesql method of adodb object to execute sql. These sql can be for anything insert update or delete. Once you have  working connection then you can use a single query to insert multiple lines that would run faster than inserting 1 row per query. Regards Akshat