FE/BE Problem: Can't change field type in linked tables

[andrey_anikin]

Hello all,

I have an issue with my DB which is split into FE/BE: on the stage of initial design, when I created the data tables, for some of the fields I chose the text type which, as I later discovered, only allows the record to be <=255 characters. I need to have a longer text saved to the DB sometimes, so I tried to change the filed type where I need that - changed it to MEMO, which is obviously supposed to solve the problem. I did that in the BE and thought that was that, but I still have the same 255 char limitation when I type the text in the form and save it! When I checked the FE table links, I saw that I still had the old field types where I had changed them in the BE. Is this the the thing that causes the problem? Is there a way to update the table links so that the field types will get updated as well (I have tried the Linked Table Dispatcher but it didn't help).

Thanks in advance!

 

[John Big Booty]

Having changed the properties in the BE, you should now be able to change the properties of the associated field in the design area of the FE. You may need to refresh the links between the FE and BE first.

 

[maxmangion]

try re-linking the table in your FE.

 

[andrey_anikin]

try re-linking the table in your FE.

Thanks, that did help - now I see updated field types when I check the likned tables in the FE. But it didn't solve the problem as such - I am still unable to save remarks having more than 255 characters. The text field control I use for text input on the form is not bound to any datasource - I use its value as a paramter for SQL stuff to edit the tables in BE. Can it be something related to the text control itself? I didn't find anything in its properties... but it doesn't by default mean there's nothing there

 

[andrey_anikin]

Doesn't anyone have a suggestion? I have double-checked the texbox properties and I don't see anything there that can limit the length of the typed-in text to 255 symbols... and yet all that exceeds that size gets cut off! That's really annoying