Hi,
I started using 2019 R2 and I have noticed that the doc regarding PostgreSQL Prepared Statements has been only updated partly.
Just to let you know.
Here is a sample of the actual doc :
[quote]Var db As New PostgreSQLDatabase
db.Host = “127.0.0.0”
db.UserName = “admin”
db.Password = “admin”
Try
db.Connect
db.SQLExecute(“BEGIN TRANSACTION”)
db.SQLExecute(“CREATE TABLE Persons (Name TEXT, Age INTEGER)”)
Dim insertPerson As PostgreSQLPreparedStatement = _
db.Prepare(“INSERT INTO Persons (Name, Age) VALUES ($1, $2)”)
// Add some sample data
insertPerson.Bind(0, “john”)
insertPerson.Bind(1, 20)
insertPerson.ExecuteSQL
[/quote]