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 giv
Am 12.02.10 16:35, schrieb Frank Schoenheit, Sun Microsystems Germany:
> 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 implement
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
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
> 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 ,
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
> If we talking about "General users" it could been a good start to make
> StoredProcedures visible in the GUI before we adding bells like
> parameters etc
I would not call parameters to function calls "bells", I would call it a
necessity.
> Other users (who have acces to there own Databases
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 : scheme.
>
> Hmm, don't like this idea too much. Basically, it would be completely
> intr
Frank , Marc
If we talking about "General users" it could been a good start to make
StoredProcedures visible in the GUI before we adding bells like
parameters etc
Other users (who have acces to there own Databases) do not need other
than Native Mode because they written already the Stored