Hi Anthony,
did you try the postgresql driver
http://dba.openoffice.org/drivers/postgresql/index.html?
Best regrads,
Ocke
Anthony E. Greene wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 2006-11-07 08:07, Anthony E. Greene wrote:
I want to generate unique keys for a table in a PostgreSQL DB
[snip]
I ended up assigning a macro to the form's "before record action" event.
The macro calls a shell script that uses psql to retrieve/increment the
sequence value and output it to a file. The macro then reads the file and
puts the value into the "id" control on the form.
In order to make this work, I had to make the id control the last in the
tab order on the form, so that tabbing through the form triggers the macro
then [tab] submits the completed form.
What a kludge. I've used perl/CGI for this kind of work in the past. For
now I'll continue to do so. I only use these tools for small projects
anyway. Using perl/CGI can be a little tedious, but it's a reliable and
well-understood solution set. I'll try OOo again when the DB support is
significantly improved.
- --Tony
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Anthony E. Greene <mailto:[EMAIL PROTECTED]> 0x6C94239D
iD8DBQFFUfK1pCpg3WyUI50RAiONAKDqHD5LmGJbRRdUAguXY75ocL4+DQCgw0Ha
jFIj64LttNNuEt3vDDgK3fE=
=MaM3
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems GmbH
Nagelsweg 55 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
