i am getting this error
relativ opened this issue · 0 comments
relativ commented
Program IFSTest;
var
SQLConnection: TDBConnection;
SQLQuery: TDBQuery;
Begin
SQLConnection:= TDBConnection.Create();
SQLConnection.ProviderName := 'MySQL'; // Access, Advantage, ASE, DB2, DBF, InterBase, MySQL, NexusDB, ODBC, Oracle, PostgreSQL, SQL Server, SQLite, MongoDB
SQLConnection.UserName := 'root';
SQLConnection.Password := '';
SQLConnection.Server := 'localhost';
SQLConnection.Database := 'mysql';
SQLConnection.Open();
SQLQuery:= TDBQuery.Create();
SQLQuery.Connection := SQLConnection;
SQLQuery.SQL.Text := 'select * from user';
SQLQuery.Open;
while not SQLQuery.Eof do
begin
Memo1.Lines.Add(SQLQuery.FieldByNameAsString('User')) ;
SQLQuery.Next;
end;
SQLQuery.Close();
SQLQuery.Free();
SQLConnection.Close();
SQLConnection.free();
End.
Failed when compiling
[Error] (7:16): Unknown identifier 'PROVIDERNAME'
please help thanks