Tip: Source Change!

rbuser

Hi;
When I tried to get table names from MS SQL 2000 with RB 7.01, I could not
get anything (through dbExpress). I found the problem on daDBExpress unit
(MSSQL wants schema name (dbo)) and chanced the code below:
(line:286, procedure TdaSQLSession.GetTableNames)

//********************************
// Original
if lSQLConnection.Connected then
lSQLConnection.GetTableNames(aList, False);

// Modified
if lSQLConnection.Connected then
if lSQLConnection.DriverName = 'MSSQL' then
lSQLConnection.GetTableNames(aList, '[dbo]', False)
else lSQLConnection.GetTableNames(aList, False);

//***********************

Best Regards,
Faruk