remobjects / pascalscript

pascalscript
Other
447 stars 178 forks source link

i am getting this error #254

Open relativ opened 2 years ago

relativ commented 2 years ago
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