jeffhg582003 wrote:
>Hi, > >I am developing a python script which add records to >a microsoft access tables. All my tables have autogenerated number >fields. I am trying to capture the number generated from the insert but >I am not exactly sure how to do that after an insert. > >Thanks, >Jeff > > > > > I had to do something similiar in sql server and the experts back then told me that the only way is to write a stored procedure. aparently sql server does not have sequences and I am guessing that access is the same. cheers albert -- Albert Leibbrandt Data Manager CompuScan Holdings (Pty) Ltd Brandwacht Office Park Stellenbosch. South Africa. Tel;+27 (0)21-8886000 Fax;+27 (0)21-8832336 National: 0861 51 41 31 E-Mail : [EMAIL PROTECTED] www.compuscan.co.za - reducing credit risk and fraud, at the same time protecting the consumer against over-indebtedness and reckless borrowing www.techtonic.co.za - a software design and development, information management and internet solutions company www.csti.co.za - a skills training and development provider to the Micro Finance sector (BANKSETA accredited) Confidentiality: "The information contained in this e-mail and any attachments thereto is private and confidential and is intended for the eyes of the addressees only. Access to this e-mail by any other person or any attachment is not authorized and accordingly prohibited. If you are not the authorized and intended recipient, any disclosure, copying, dissemination or distribution, any other action of omission by you with respect to the information in this e-mail and attachments is prohibited and unlawful." -- http://mail.python.org/mailman/listinfo/python-list
