Lazarus Pascal / Delphi - Error connecting to database

Question

I'm trying to connect to my postgresql database using Lazarus pascal. I get this error towards the end of compilation (F9).

mainform.pas(112,35) Error: Wrong number of parameters specified for call to "Create"

Here's my code:

  dbConn:= TSQLConnection.Create(nil);    
  dbConn.HostName := '<IP goes here>';    
  dbConn.DatabaseName:= 'dbMydb';    
  dbconn.UserName:='me';    
  dbConn.Password:='pas';    
  dbConn.Open;

  //Bind the Transaction AND Query components to the DB connection

  dbQuery_Menu := TSQLQuery.Create; //This is the line with the error    
  dbQuery_Menu.Database := dbConn;    
  dbQuery_Menu.Transaction := dbTrans ;

I'm really exhausted trying to figure this out... Any help please...

The above code was adapted from here.

For those who bump into the same issue or would like to fix this, here's the code: pastebin.com/RSBkusDM — itsols

RRUZ RRUZ · Accepted Answer · 2012-10-30T21:45:42

It seems which the documentation is outdated, the TSQLQuery descends from the TCustomSQLQuery class where the constructor is defined like

 constructor Create(AOwner : TComponent); override;

So you need to modify your code like this

dbQuery_Menu :=TSQLQuery.Create(nil);

Lazarus Pascal / Delphi - Error connecting to database

1 Answers