Can't delete column

Classic Servoy
1

Hi

Am I doing something wrong? See the attached image - I cannot do three things on this screen (looking at table ‘Project’) that I was expecting.

  1. A delete button so I can delete a column in the table…
  2. I cannot tag a column to not allow nulls.
  3. Minor - but I cannot reorder the columns.

I have really been fighting with problems today and would really appreciate someones help.

Kind Regards
Jonathon

NoDelete.gif
NoDelete.gif1680×1020 278 KB

2

Jonathon,

  1. Red X deletes the column :D
  2. Try it on a new table or a table without data
  3. No can do.

Cheers,

3

Hi Omar

The delete button wasn’t where I expected - LOL - thanks… I expected the button to be close to the “add button”…

I still cannot set a column to Not Except Null???

I tested SQL explorer on the sample databases and it worked well. SO it suggested that my table was some what corrupted. How did I fix it? I deleted all the records - that did not work on its own. I copied the table. Deleted the original. Renamed the copy back to its original name. Then the SQL data tab worked. I lost my calculations. Is there a better way of fixing corrupt tables? I hope this doesn’t happen often on live data?

Spending a lot of time NOT developing - hitting issues. :( I hope I am just being a little unlucky.

Thanks :) and Cheers
Jonathon

4

Hi Jonathon,

There are some restrictions to when you can set a column to null. I did a little test where I could set the column to null:

  1. Create a new table (through the Servoy interface)
  2. Besides the PK which is generated for you add a new column and give it a name
  3. Now you should be able to check Allow Nulls

I have never had corrupted data with postgreSQL. Be careful with making changes to the database outside of Servoy. If you do then do the following (if neccessary):

  1. Right-click the database connection
  2. From the popup menu choose “Reload tables/table structure from DB”
  3. Select the option “Synchronize with DB server information”
  4. If records have been added outside of Servoy also select “Update Servoy Sequences”