Database types

[oz8hp]

I have defined
type
TDBType = (dbMySQL, dbMSSQL, dbSQLite, dbMSAccess);

const
arrDBProvider: array[TDBType] of string = ('MySQL', 'SQL Server', 'SQLite', 'Access') ;

But now I began wondering if there might be some type/const already defined that I could use. I haven't been able to find anything in manual or in the forum.

[AlexP]

Hello,

There is no such list of supported databases. However, you can use the following code to get the list of registered database providers:

var
lst: TList;
i: integer;
begin

lst:= UniProviders.LockList;
for i:= 0 to lst.Count -1 do
begin
ShowMessage(TUniProviderDesc(lst).ProviderName);
end;
end;

[oz8hp]

OK - will have a look to see what I can do with that

[oz8hp]

The purpose of my code is that I have made a generic databasesetup form and the type/const is used to allow me to decide the number of databasetype that the user can select in each of my apps.

It is all down to having as little work as possible