Resizing Table Columns

Classic Servoy
1

Newbie question. New to Servoy and SQL (from FoxPro background).

How do you resize a table column (say from 20 characters to 50 characters) without losing data? In FoxPro, you simply changed the table structure. How is this done in SQL?

Thanks!

2

Servoy does not support resizing columns other than via dropping and recreating columns which clears the data in the column.

If the database used supports it, you can modify the column width using sql directly in the database. After a restart of developer, Servoy will pick up the new column size.

Rob

3

Thanks for the quick reply and the tip, Rob. The tip will fix my current situation.

It’s too bad Servoy does not allow table column resizing. Our current product is based on FoxPro (we’re currently converting to Servoy), and one of FoxPro’s features is that you can resize table columns dynamically and programmatically without loss of data when going from smaller to larger column sizes. So, whenever we changed table strutures, it was included as part of our product’s update program.

Can anyone recommend a method (or methodology) for programatically expanding SQL table columns without loss of data across various SQL database back-ends (how are others doing this)? I apologize for asking what is probably a lame question, but I am new to SQL and am looking for guidance in this area.

Thanks!

4

Hi,
we use the rawSQL plugin for that.
with every update (that contains table structure changes) we fire once an update SQL query!

Hope this helps

5

Hi

Almost all back end tools will allow you to resize table columns, change number types etc. without losing any data, just that servoy doesn’t allow you to do it within the servoy app. On restart of Servoy it will pick up the changes you have made.