Can I change a field name?

Classic Servoy
1

Hello - is it possible to change a field name or character limit once I’ve actually started using it? I’m using the standard Firebird database as the backend.

If it’s not possible, could you please tell me how you get around this / deal with it as I’m so used to being able to change names and attributes as needed.

Thank you.

2

No you can’t!

You can make a workaround.
Make a new field (with an other name, and the right properties) and a method which is started the first time the customer opens the solution.

method: make a loop that copies the data from the old to the new field.

This is, as far as I know, the only way to do this, without loosing the data.

3

Aha! Found out you can change table names. Just execute an SQL statement like this:

ALTER TABLE table1 ALTER [COLUMN] field1 TO field2;

4

Is only possible on 1 or 2 databases, the method described by HJK always works.

5

chris:
Aha! Found out you can change table names. Just execute an SQL statement like this:

ALTER TABLE table1 ALTER [COLUMN] field1 TO field2;

Does it hold the content of the field?

6

Jan Blok:
Is only possible on 1 or 2 databases, the method described by HJK always works.

Jan, can you be more specific? What do you mean by 1 or 2 databases?

7

Firebird and postgress are as far as I know the only 2 databases which support column rename