And attached is the simplest most generic procedure I could come up with.
So this routine just creates an SQL INSERT STATEMENT
No prepared statement.
No support for IMages or other varbinary data.
Everything is a string.
No use of a cataloge (schema) name
Ran it against a few forms I had for ea
Am 08.02.10 13:35, schrieb Fernand Vanrie:
> We uses also "Stored Procedures" on a Msql server To make all things
> work , we handles all user input (parameters calculatutions,
> translations etc...) with OO-dialogs and some macro's to create the SQL
> statements writen to please the ODBC driver
Hwody,
Alright - don't say it - I tossed pretty much all of that.
*IMPORTANT *
Unlike the jdbc/access drivers the odbc(all?)/SQLite3 combination is the
worse possible situation.
The user has a Data Inert Only form.
They try to commit it throws the error.
(Under JDBC/Access only the first try
> SELECT * FROM acf_balance_all()
>
> To get the balance from only on account, you would use
>
> SELECT * FROM acf_balance('1000')
>
> ('1000' is the account number).
>
I'd guess the problem is the ability of DBA to bind columns for display.
That is, while postgres understands the columns wh
Marc ,
We uses also "Stored Procedures" on a Msql server To make all things
work , we handles all user input (parameters calculatutions,
translations etc...) with OO-dialogs and some macro's to create the SQL
statements writen to please the ODBC driver and the Msql server :-)
Good day
We de
Hello Marc Balmer,
It would be great if you could submit an issue and perhaps could add a
sample db dump (only with dummy data and one sample procedure) for a
test case. And assign it to me o...@openoffice.org.
Best regards,
Ocke
Marc Balmer wrote:
Good day
We develop point of sales (POS)
Good day
We develop point of sales (POS) applications using PostgreSQL as the
database backend. We thought it could be interesting for our customers
to access the database directly from OpenOffice Base to create their own
reports etc. But it turns out that OpenOffice Base and PostgreSQL are
not