Reinier Olislagers wrote:
But I can't do that last step from a TIBConnection. There's obviously a
possibility that I'm Doing It Wrong: what's the Firebird equivalent of
PQExec(), I'm using isc_dsql_execute_immediate()?
Strange.
Setting the user to borg_um, the role to RDB$ADMIN, correct password,
the db to the newly created db, then connecting with the right
transactions etc and doing something like TIBConnection.Execute('CREATE
USER...') (or whatever the actual command is) should work.
I'd very much like to be able to use SQL commands for this, since it
makes management and logging far easier.
If you don't get it sorted, let me knoe & I'll try and set up a demo
program.
I think I've got it, the correct procedure for a resultless SQL command
is ExecuteDirect(). The reason that I'd been trying to use a different
function was as a legacy of experimentation a year or so ago with
Firebird events, i.e. finding how compatible I could make them with
PostgreSQL async notifications, where if sharing a connection object
with queries etc. one has to be careful about the handle's lifetime.
So thanks for the moral support, once I've checked over the
documentation I should be able to press on.
As background, what I'm trying to do is set up a tree of servers and
apps with messages passed around by journal tables and notifications.
Only hitch is that a user has to have an initial ID before he can start
using that type of arrangement, which I'm allocating by what is
basically a fancy finger daemon.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal