FiveTech Support Forums

Hi,

In ADO, text fieds longer than 150 chars are truncated to 150 chars length.

Thank you.

Are you using FWH1412?

Yes.

Up, please

I have installed FWH14.12 and verified the code.

This is the behavior:
If the defined size of the field exceeds 100, the field is treated as Memo field.
We need to use GET MEMO/TEXT to get the values of the field.

Thank your for your time.

With that solution, a new problem arises: when I select a memo field to edit, the cursor is placed in the position where I click.

However, in a normal text GET it always goes to the beginning, regardless of the click position.

The behaviour in MEMO should be the same.

At the resource level, in both cases they are defined this way: ES_AUTOHSCROLL | WS_BORDER | WS_TABSTOP

Do you want to treat the larger fields as character fields but not as memo fields?

What is the size of your VarChar fields? The present limit is 100 chars. Is a limit of 255 chars enough for you?

If I suggest modifications to the dararow.prg, will you be able to use the modified program in your project?

Yes, that´s right. Thank you.

Yes, 255 Will be fine.

Yes, I am able to modify the source code. Also we will renew our FTDN.

Also we will renew our FTDN

We need please this fix before updating, because updating will requiere further revision due changes.

Thank you.

You need to make these modifications in the METHOD ReadADO(...) in datarow.prg.
You will find this method from lines 596 to 693.

Please locate for "100" and replace with "255". You will find this at 4 places in the method.
Do not change anything outside this method.

Please try and let us know.

Thank you.

What about backing up and restoring tables to an external txt file via ADO, irrespective of DBMS? The lib does provide this feature now?
All the best,