Re: AW: How common is Table Buffering with DBFs??

2019-11-26 Thread MB Software Solutions, LLC
That said...I do use buffering on those local cursors to allow me to revert to what it was prior to my changes (as per the last query). On 11/25/2019 5:29 PM, MB Software Solutions, LLC wrote: All are saying the same thing...but I know I use the method Charlie Coleman showed me probably 20 year

Re: AW: How common is Table Buffering with DBFs??

2019-11-25 Thread MB Software Solutions, LLC
hat's basically it.  But to be fair, I haven't use DBFs in my designs since seeing Bob Lee's n-tier demo at WhilFest in 2002 or 2003.  Prior to that, I used local VFP views (table-buffered) for my apps. On 11/25/2019 1:51 PM, Jürgen Wondzinski wrote: Table buffering is very common. Basi

AW: How common is Table Buffering with DBFs??

2019-11-25 Thread Jürgen Wondzinski
Table buffering is very common. Basically all frameworks are using it. Can't do any decent multiuser handling without it. Yes you could do a simplier record-buffering mode, but as soon as you are faced with the typical 1:n editform, then you would need to have tablebuffering a

Re: How common is Table Buffering with DBFs??

2019-11-25 Thread Frank Cazabon
The couple systems I have left using dbfs use table buffering On 25 November 2019 13:23:00 GMT-04:00, Matt Slay wrote: >For a while when my app was still on DBFs (instead of Sql Server) I >used >Table Buffering, with TableUpdate() and TableRevert() on all my CRUD >forms.  I reme

RE: How common is Table Buffering with DBFs??

2019-11-25 Thread Tracy Pearson
Matt, I use Buffering=5 in my product as well. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Koen Piller Sent: Monday, November 25, 2019 12:28 PM To: profoxt...@leafe.com Subject: Re: How common is Table Buffering with DBFs?? Matt, I

Re: How common is Table Buffering with DBFs??

2019-11-25 Thread Koen Piller
5 nov. 2019 om 18:23 schreef Matt Slay : > For a while when my app was still on DBFs (instead of Sql Server) I used > Table Buffering, with TableUpdate() and TableRevert() on all my CRUD > forms. I remember that it could get tricky keeping it all working > correctly in the UI, but i

How common is Table Buffering with DBFs??

2019-11-25 Thread Matt Slay
For a while when my app was still on DBFs (instead of Sql Server) I used Table Buffering, with TableUpdate() and TableRevert() on all my CRUD forms.  I remember that it could get tricky keeping it all working correctly in the UI, but in the end I had a pretty good pattern in place. I took the

Re: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread Fred Taylor
you are unhurt that's all that matters! > > Dave > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor > Sent: 21 August 2015 16:38 > To: ProFox Email List > Subject: Re: Table Buffering & FLUSH(ing the Toilet)! &g

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread Dave Crozier
Fred, Sorry to see the state of the car is it repairable? As long as you are unhurt that's all that matters! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor Sent: 21 August 2015 16:38 To: ProFox Email List Subject: Re:

Re: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread Fred Taylor
Thanks John! Fred On Fri, Aug 21, 2015 at 6:10 AM, John Weller wrote: > +1 > > John Weller > > Sent from my iPhone > > > On 21 Aug 2015, at 11:51, Dave Crozier wrote: > > > > On a completely different tack, Happy Birthday Fred from here in the UK > and I guess all other Profoxers. > > > > Hav

Re: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread Fred Taylor
Thanks Mike1 Fred On Fri, Aug 21, 2015 at 4:37 AM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 2015-08-21 06:51, Dave Crozier wrote: > >> On a completely different tack, Happy Birthday Fred from here in the >> UK and I guess all other Profoxers. >> >> Have a great day!!! >> >> Da

Re: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread Fred Taylor
Thanks Dave! Fred On Fri, Aug 21, 2015 at 3:51 AM, Dave Crozier wrote: > On a completely different tack, Happy Birthday Fred from here in the UK > and I guess all other Profoxers. > > Have a great day!!! > > Dave > > [excessive quoting removed by server] __

Re: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread John Weller
+1 John Weller Sent from my iPhone > On 21 Aug 2015, at 11:51, Dave Crozier wrote: > > On a completely different tack, Happy Birthday Fred from here in the UK and I > guess all other Profoxers. > > Have a great day!!! > > Dave > > [excessive quoting removed by server] ___

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread mbsoftwaresolutions
On 2015-08-21 06:51, Dave Crozier wrote: On a completely different tack, Happy Birthday Fred from here in the UK and I guess all other Profoxers. Have a great day!!! Dave +1 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http:/

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-21 Thread Dave Crozier
On a completely different tack, Happy Birthday Fred from here in the UK and I guess all other Profoxers. Have a great day!!! Dave ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Kurt Wendt
t...@leafe.com Subject: RE: Table Buffering & FLUSH(ing the Toilet)! Kurt Wendt wrote on 2015-08-20: > Hey Fred - Thanks for that input. I just spoke to my Manager about > this issue - and we both agreed that I may just stop doing the Table Buffering - and that will help avoid the curr

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Tracy Pearson
Kurt Wendt wrote on 2015-08-20: > Hey Fred - Thanks for that input. I just spoke to my Manager about this issue - and we both agreed that I may just stop doing the Table Buffering - and that will help avoid the current problem. But, before doing so - I will try doing the TableUpdate() comm

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Kurt Wendt
Hey Fred - Thanks for that input. I just spoke to my Manager about this issue - and we both agreed that I may just stop doing the Table Buffering - and that will help avoid the current problem. But, before doing so - I will try doing the TableUpdate() command. Understood about FLUSH not

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Dave Crozier
Behalf Of Fred Taylor Sent: 20 August 2015 16:50 To: ProFox Email List Subject: Re: Table Buffering & FLUSH(ing the Toilet)! Sounds more like you're missing a TABLEUPDATE() somewhere. FLUSH won't commit an uncommitted record. Fred On Thu, Aug 20, 2015 at 8:42 AM, Kurt Wendt wrote

Re: Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Fred Taylor
Sounds more like you're missing a TABLEUPDATE() somewhere. FLUSH won't commit an uncommitted record. Fred On Thu, Aug 20, 2015 at 8:42 AM, Kurt Wendt wrote: > So - this App I'm working on - I'm having an issue where a VFP error is > being reported: Table...contains uncommitted changes. > > And

Re: Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Peter Cushing
On 20/08/2015 16:42, Kurt Wendt wrote: So - this App I'm working on - I'm having an issue where a VFP error is being reported: Table...contains uncommitted changes. And, the Buffering is on. There is code that's supposed to properly commit the changes - but, it's not working. What actual comm

RE: Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Dave Crozier
ssage- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: 20 August 2015 16:43 To: profox@leafe.com Subject: Table Buffering & FLUSH(ing the Toilet)! So - this App I'm working on - I'm having an issue where a VFP error is being reported: Table...contains

Table Buffering & FLUSH(ing the Toilet)!

2015-08-20 Thread Kurt Wendt
So - this App I'm working on - I'm having an issue where a VFP error is being reported: Table...contains uncommitted changes. And, the Buffering is on. There is code that's supposed to properly commit the changes - but, it's not working. So - just now - I tried implementing the FLUSH Command. B

User defined, data driven fields and optimistic table buffering

2010-06-17 Thread Ricardo Aráoz
Hi, this is not actually a "real" question given that I was able (due to the app's characteristics) to go another way. But the question is still bumping inside my head. This is VFP 6.0, and there is no DBC for this app (though I guess I could create it if necessary). I have : Flds.dbf :

Re: table buffering

2006-07-12 Thread Peter Cushing
Judith Barer wrote: I realize that I do have to update more than one table. So I can use table buffering but can I still use the SQL update, insert and delete commands. It says the following in the help file on cursorsetprop "Note Buffering is not applied to tables that are opened impli

RE: table buffering

2006-07-11 Thread Judith Barer
I realize that I do have to update more than one table. So I can use table buffering but can I still use the SQL update, insert and delete commands. It says the following in the help file on cursorsetprop "Note Buffering is not applied to tables that are opened implicitly, for example,

Re: table buffering

2006-07-11 Thread Peter Cushing
Judith Barer wrote: I have developed a VFP 8.0 app with table buffering used in most of the forms. This all works fine. I use transactions and tableupdate and it's working fine. I have to write a program that will read in an xml file every day and update appropriate records in a table th

table buffering

2006-07-10 Thread Judith Barer
I have developed a VFP 8.0 app with table buffering used in most of the forms. This all works fine. I use transactions and tableupdate and it's working fine. I have to write a program that will read in an xml file every day and update appropriate records in a table that is used in the mai