So far i found a lot of things not working with Stored Procedures, but
finaly :-) i got a sort of workaround for a Stored Procedure on MySql
with parameters.
SUB TESTstoredprocedurecall
oBaseContext = CreateUnoService(com.sun.star.sdb.DatabaseContext)
oDB =
Am Dienstag, den 16.02.2010, 11:52 +0100 schrieb Fernand Vanrie:
So far i found a lot of things not working with Stored Procedures, but
finaly :-) i got a sort of workaround for a Stored Procedure on MySql
with parameters.
SUB TESTstoredprocedurecall
oBaseContext =
Am Samstag, den 13.02.2010, 18:22 +0100 schrieb Marc Santhoff:
And just here i am lost: how works this registering of the
parameters ?
Dunno, my assumption was that it is not strictly necessary ... I tink
someone else has to answer this question.
A quick look into chapter 8 of the HSQL
Am 12.02.10 08:29, schrieb Frank Schoenheit, Sun Microsystems Germany:
Hi Marc,
Maybe a third mode could help here: Semi-Native SQL, where base would
only scan for parameter definitions using the :name scheme.
Hmm, don't like this idea too much. Basically, it would be completely
Marc ,
you told : That makes, in consequence, stored procedures unusable with
OpenOffice base.
This is countrary to what the DEV guide tells us
Stored procedures are server-side processes execute several SQL commands
in a single step, and can be embedded in a server language for stored
you told : That makes, in consequence, stored procedures unusable with
OpenOffice base.
Well, I probably need to refine that a bit, indeed: It makes stored
procedures unusable in OpenOffice base using the query editor.
This is countrary to what the DEV guide tells us
Stored
Marc,
Its even worse ,after further investigation i found no code (API +
basic) to run a stored procedure with parameters.
So I would be very happy i someone could give a hint :-)
thanks for any help
Fernand
you told : That makes, in consequence, stored procedures unusable with
OpenOffice
Hi Marc,
Can the
internal SQL parser be changed to accept statements like
SELECT * FROM function(:parameter) ?
Probably, yes (but Ocke has a saying in this, he has deeper insights in
the parser implementation).
Feel free to submit an issue.
Ciao
Frank
--
- Frank Schönheit, Software
Am Freitag, den 12.02.2010, 15:42 +0100 schrieb Fernand Vanrie:
Marc,
I'm another one, but maybe I can give a little help. ;)
Its even worse ,after further investigation i found no code (API +
basic) to run a stored procedure with parameters.
So I would be very happy i someone could give a
Hi Marc,
I can, however, set the query editor
to native SQL mode, then the SQL code is passed as is to the database
backend and no error is output. But with native SQL mode, I loose the
possibility to have OpenOffice ask the user for parameters. I can only
use calls without parameters.
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
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
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 which are
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 and
14 matches
Mail list logo