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?
my_id int default serial
default serial will ensure that the coulmn is read-only and increments one by one. you can specifiy the value for the column if the row is created, but once filled, the column is read-only..
you can combine this with any field type (as far es know)
so
my_id fixes(16) default serial
should work too.
be sure that you use SAPDB >7.3.0.29, but not SAPDB7.4.3.7, because you will need to get the "last-insert-id".
This is done by using
SELECT table.currval FROM sysdba.dual
which is only supported by SAPDB >7.3.0.29 or >7.4.3.10 (which is not yet available to us :-( )
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
