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

Hi :)
I thought the postgresql connector got a fairly massive upgrade about a year or so ago?  It might 
be worth contacting the postgresql forums/mailing-list to see if any of their devs are able to do 
some more work on their connector or to see if we are just missing something about the current one. 
 
Regards from 
Tom :) 




________________________________
 From: Alexander Thurgood <alex.thurgood@gmail.com>
To: users@global.libreoffice.org 
Sent: Wednesday, 4 September 2013, 10:45
Subject: [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
-- 
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