AutoInc fields are evil in a multi-user situation (at least for paradox - not sure about dbase)
Alister Christie Computers for People Ph: 04 471 1849 Fax: 04 471 1266 http://www.salespartner.co.nz PO Box 13085 Johnsonville Wellington Jeremy Coulter wrote: > Another thought would be to make the "JobNo" field an auto > incrementing field? I have to admit I cant remember too much about > DBase but I am sure it has auto incrementing fields. This would save > you needing to calculate the job number. > > Jeremy > ------------------------------------------------------------------------ > *From:* [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] *On Behalf Of *Marshland Engineering > *Sent:* 27 October 2008 18:35 > *To:* [email protected] > *Subject:* [DUG] Dbase File Data Update > > I am trying to increase a value in a dbaseIII file. When I press the > Inc button, the referenced dbEdit field increases with each click. > > However on exiting the program, the tblData['Jobno'] does not reflect > the new value. > > > From data module. > > begin > tblData.open; > end; > ------------------------------------ > > procedure TForm1.bIncClick(Sender: TObject); > > var iCurrJobno:integer; > > begin > iCurrJobno:=dm.tblData['Jobno']; > iCurrJobno:= iCurrJobno+1; > dm.tblData.edit; > dm.tblData['Jobno'] := iCurrJobno; > end; > > > There are probably other ways of doing this, but I would like to know > why this does not work. > > Thanks Wallace > ------------------------------------------------------------------------ > > _______________________________________________ > NZ Borland Developers Group - Delphi mailing list > Post: [email protected] > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
