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: [email protected] 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
