Yep. I understand what you're saying about the default serial. My problem is why do I get the Type Mismatch error when trying to assign the Replication ID field to the Fixed(16,0) field?
Thanks, jon "Sven K�hler" <[EMAIL PROTECTED]> wrote in message b0s24r$4sr$[EMAIL PROTECTED]">news:b0s24r$4sr$[EMAIL PROTECTED]... > > 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? > > To have somethin like the Autonumber-field you could use a column like > 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
