Yes, that might be possible. I'll look at it further. Phil
[EMAIL PROTECTED] wrote: > Quoting Phil Longstaff <[EMAIL PROTECTED]>: > >> Remove constraint that lot.account_guid must not be null. >> Unfortunately, >> sqlite doesn't support ALTER TABLE which modifies column constraints, so >> existing databases can't be modified programmatically. > > Can't you alter the table by creating a new temporary table with the > new constraints and then renaming it back to the original table name? > > We really need a process to be able to automatically update the > database schema as we update it. > > -derek > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.169 / Virus Database: 270.6.21/1669 - Release Date: 9/12/2008 > 2:18 PM > > _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
