Hello all,

maybe has anybody encountered the same problem as I did and knows the
solution:

For editing purposes I copy selected record to memory table which I create
at run time by assigning fieldDefs from the source table. In source table
there is an integer field with value greater than 32767. This value was
entered by a program and I can put such great value with DBSYS as well.

When I want to assign value at run time from source table to memory table I
get an exception telling me that value is greater than alowed value for
integer field which is in range -32766 .. 32767. The both statements below I
get the same exception:

memTable.fields[i].asInteger :=
sourceTable.fieldByName(memTable.fields[i].fieldname).asInteger;
memtable.fields[i].assign(sourceTable.fieldByName(memTable.fields[i].fieldname));

Thanks for suggestions
Iztok Lajovic

Iztok,

<< When I want to assign value at run time from source table to memory table
I get an exception telling me that value is greater than alowed value for
integer field which is in range -32766 .. 32767. The both statements below I
get the same exception: >>

It sounds like the field defs copy isn't working exactly as you would think.
Do you have any ftSmallInt fields in the table ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> << When I want to assign value at run time from source table to memory
> table I get an exception telling me that value is greater than alowed
> value for integer field which is in range -32766 .. 32767. The both
> statements below I get the same exception: >>
>
> It sounds like the field defs copy isn't working exactly as you would
> think. Do you have any ftSmallInt fields in the table ?
>

Yes, one at the end of field list, but the field with problem is ftInteger
type.

Iztok

Iztok,

<< Yes, one at the end of field list, but the field with problem is
ftInteger type. >>

Yes, but are you sure that you're assigning the value to an ftInteger field
and not an ftSmallInt field ?

Perhaps you could post the entire code that you're using.  That should help
a bit.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Yes, but are you sure that you're assigning the value to an ftInteger
> field and not an ftSmallInt field ?

I found it. There was a side effect with TwwDBLookupcombo where the source
field was integer field in question and lookuptable had a ftSamllInt field
in primary key.

Thanks for help
Iztok Lajovic