[DUG] Dbase File Data Update

[Alister Christie]

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:* delphi-bounces at delphi.org.nz 
> [mailto:delphi-bounces at delphi.org.nz] *On Behalf Of *Marshland Engineering
> *Sent:* 27 October 2008 18:35
> *To:* delphi at delphi.org.nz
> *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: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe