Length of text fields

Classic Servoy
1

I notice that once a text field is defined of a particular length it can’t be changed.

Do you have “best practice” recommendations for choosing field lengths?

2

look where it is for.
And what the max length would be for youre data.

for example if you want to store lastnames then 50 should be enough for most names…

3

Morley:
I notice that once a text field is defined of a particular length it can’t be changed.

Do you have “best practice” recommendations for choosing field lengths?

Morley,

You can’t change it in the SERVOY interface - but you CAN change it using a backend editor to “talk” to the database directly.

For example, if you’re using Sybase, then download “Sybase Central” (part of the Developer Studio) - and you can change column names, change data types, change data lengths, etc.

Bob Cusick

4

I followed Bob Cusick’s advice from an old topic about changing the length of a text column in the back end database (MS SQL), but I can’t get Servoy to see the new length. I did it once by creating a new column, moving text to it, and deleting the old, but there’s got to be a better way.

Thanks,

Kurt

5

Did you restart developer or server?
Else it does not see the changes to the backend.

Hope this helps

6

That’s so obvious it didn’t even occur to me! :oops: When I quit developer and reopen it, it sees the new length.

Thanks,

Kurt