JON wrote:
> I'm porting a Microsoft Access 2000 db to SAPDB and am stuck
> on what to do
> with a certain field type. They have an Autonumber type which
> is called a
> Replication ID which is a 128 bit number. I thought to stick
> it into a Fixed
> 16,0 field in SAPDB. I'm using ADO recordsets to move the
> data and when I
> use a statement like rsDest.Fields("FixedID") =
> rsSrc.Fields("RepID") I get
> a Type Mismatch error. Any clues?
I am not quite sure if I catch the problem correctly,
but you are sure that a 128 bit-number and a fixed (16) are able to store
the same data?
2byte integer = 16 bits needs fixed (5) for 5 significant digits,
4byte integer = 32 bits needs fixed (10) for storing its values,
-->
16byte number = 128 bits needs only fixed (16) ?
I think fixed (38) (the maximum) is needed.
Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
