In this code I keep getting an SQL error on SQL Execute near $1:
DB.Connect Dim PS as PostgreSQLPreparedStatement = DB.Prepare("CREATE ROLE $1") PS.Bind(0, "Training") DB.SQLExecute(PS)
But I can’t see what’s wrong. Anybody have a clue?
(Why that does not look like regular API 1 code is because I subclassed PostgresqlDatabase to throw exceptions on DB errors - but I get the same thing if use the Supeclass directly)
BTW What I was trying to check is how Xojo handled strings in this case for PG IDs. Would it be equivalent to:
CREATE ROLE Training Or CREATE ROLE "Training"
In other words if the role name wound up being as typed or all lowercase.