[libreoffice-users] Re: How to show postgresql exception errors in 4.1 Base when using a form?

Le 03/09/13 22:29, Roger Nutbeam a écrit :

Hi,

> I have a form for entering some data. The data is checked using a trigger
> function in postgresql. If an exception is raised by the function, nothing
> is shown in the form. It just doesn't complete entering the data, i.e. move
> to the next row in the data grid. If no exception is raised the data is
> entered into the table via the form, and the cursor moves to the next row.
>
> Entering the data manually using SQL outside of Base, returns the exception
> when it's meant to. The postgresql function is working.

AFAIK, this is not currently supported by the postgres native driver,
and I'm not even sure it is by the more general JDBC driver ? How would
you tell the driver that the statement execution called by the trigger
has failed, when all of this is stored and executed on the server, about
which the driver knows nothing ?


Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted