Table editing in IDE

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using

Table editing in IDE

Postby ylockson » Fri Mar 01, 2013 7:40 am

1. create a new table and save it
2. edit the table (delete columns, etc...)
3. then, when adding new columns, the IDE does not permit un-ticking of the 'Allow Null' property
ylockson
 
Posts: 59
Joined: Thu Mar 01, 2012 8:40 am

Re: Table editing in IDE

Postby jcompagner » Tue Mar 05, 2013 11:35 am

because in an existing table you can't easily create an extra column where allow null is false
Because what values should then go into the existing rows?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8833
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Table editing in IDE

Postby ylockson » Tue Mar 05, 2013 3:38 pm

Johan,

But Servoy does not first verify whether the table contains data...
ylockson
 
Posts: 59
Joined: Thu Mar 01, 2012 8:40 am

Re: Table editing in IDE

Postby jdbruijn » Tue Mar 05, 2013 3:45 pm

Maybe this would be usable when the column has a default value (say 0 for NUMBER, or 'Y' for TEXT) than Servoy can update the column and use the default value for all rows that have a NULL value.
Jos de Bruijn
Focus Feedback BV
Servoy Certified Developer
Image
jdbruijn
 
Posts: 492
Joined: Sun Apr 11, 2010 6:34 pm


Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: No registered users and 7 guests