Hello See your table metadata for time field is not null or nullable. If is not null ypu must chane to nullable.
________________________________ From: kukiejko <[email protected]> To: [email protected] Sent: Sunday, 23 June 2013, 22:27 Subject: [firebird-support] Check previous records in the table before table update Hello, I use Firebird 2.5 for Windows. I need to create UPDATE TRIGGER for Table A, but UPDATE for the Table A for row ID=x is only possible if TIME column for ID<x is >not< [null]. For example I can update Time column for row ID=234 but it should be not possible to update Time column for row ID=235. How can I do it on the Firebird server (using eg. Trigger, functions or procedures)? -------------------------------------------- TABLE A: ID | TIME ========================================== 229 | 07.06.2013, 18:06:35.871 230 | 07.06.2013, 16:42:52.941 231 | 07.06.2013, 16:42:53.286 233 | 07.06.2013, 16:42:53.607 234 | [null] 235 | [null] 236 | [null] ------------------------------------------ Thank you for any feedback or example Kukiejko [Non-text portions of this message have been removed]
