|
Home > Archive > FoxPro Help and Support > December 2005 > Help on Buffering in Multiuser environment
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help on Buffering in Multiuser environment
|
|
| Sandeep Gupta 2005-12-15, 3:25 am |
| Hi all,
Any help in the following case will be appreciated. Thanx in advance.
Using Visual Foxpro Version 6.0. , application is a Point of Sales being
used on some 10 System Concurrently. (hardware config is not the same for all
the PCs some are old P-II some P-III and P-IV)
I have a form which has 24 tables open in dataenvironment, most relevant to
my problem are belowmentioned
1. Invoices(Header) & invoice Line Items(detail) (currently have 70000 rec
in header and 400000 records in detail table)
2. Receipts(Header) and Receipt Line Items(detail) (currently have 68000 rec
in header and 600000 records in detail table)
3.Buffermode override for both tables is 5
My problem is that, suppose the user enter invoice No 10075001 with some 15
line items, sometimes it happens that when this new invoice is saved a
previous record header for ex. 10068045 has some 6 lines gets overwritten
with this new invoice no 10075001, while the detail lines of that record gets
added to this new record.
Meaning that invoice no 10068045 is no more in the table while the Invoice
no 10075001 has some 21 detail lines instead of 15.
This issue occured very rarely before when the records were less, now it
occurs quite frequently. Can it be because of slow computer on a network or
any other cause, kindly help.
Sandeep Gupta
| |
| Leonid 2005-12-16, 3:24 am |
| AFAIK this was a bug in VFP6 without any SP. In VFP6 SP5 it was fixed.
Install SP5 and don't forget to change runtimes on workstations
Leonid
"Sandeep Gupta" < SandeepGupta@discuss
ions.microsoft.com> wrote in message
news:690EA426-7572-4F6D-A1F8- 38BC99DAC4B1@microso
ft.com...
> Hi all,
> Any help in the following case will be appreciated. Thanx in advance.
>
> Using Visual Foxpro Version 6.0. , application is a Point of Sales being
> used on some 10 System Concurrently. (hardware config is not the same for
> all
> the PCs some are old P-II some P-III and P-IV)
>
> I have a form which has 24 tables open in dataenvironment, most relevant
> to
> my problem are belowmentioned
>
> 1. Invoices(Header) & invoice Line Items(detail) (currently have 70000 rec
> in header and 400000 records in detail table)
>
> 2. Receipts(Header) and Receipt Line Items(detail) (currently have 68000
> rec
> in header and 600000 records in detail table)
>
> 3.Buffermode override for both tables is 5
>
> My problem is that, suppose the user enter invoice No 10075001 with some
> 15
> line items, sometimes it happens that when this new invoice is saved a
> previous record header for ex. 10068045 has some 6 lines gets overwritten
> with this new invoice no 10075001, while the detail lines of that record
> gets
> added to this new record.
>
> Meaning that invoice no 10068045 is no more in the table while the Invoice
> no 10075001 has some 21 detail lines instead of 15.
>
> This issue occured very rarely before when the records were less, now it
> occurs quite frequently. Can it be because of slow computer on a network
> or
> any other cause, kindly help.
>
> Sandeep Gupta
| |
| Sandeep Gupta 2005-12-22, 1:24 pm |
| Hi Dear,
Thankyou very much for your help. I have done the necessary and am waiting
for a feedback from the client.
I have installed the SP5 on main PS from where the executable is running and
the data is residing, but on the client side the executable is running
directly from the server as I have mapped the POS folder on the server to a
local drive on the client.
Do I need to still install the SP5 on the local client, as client does not
have the VFP installed only the library files are present on the client side.
In this case I will have to install the VFP first on each client and the the
SP5, any help shall be highly appreciated.
"Sandeep Gupta" wrote:
> Hi all,
> Any help in the following case will be appreciated. Thanx in advance.
>
> Using Visual Foxpro Version 6.0. , application is a Point of Sales being
> used on some 10 System Concurrently. (hardware config is not the same for all
> the PCs some are old P-II some P-III and P-IV)
>
> I have a form which has 24 tables open in dataenvironment, most relevant to
> my problem are belowmentioned
>
> 1. Invoices(Header) & invoice Line Items(detail) (currently have 70000 rec
> in header and 400000 records in detail table)
>
> 2. Receipts(Header) and Receipt Line Items(detail) (currently have 68000 rec
> in header and 600000 records in detail table)
>
> 3.Buffermode override for both tables is 5
>
> My problem is that, suppose the user enter invoice No 10075001 with some 15
> line items, sometimes it happens that when this new invoice is saved a
> previous record header for ex. 10068045 has some 6 lines gets overwritten
> with this new invoice no 10075001, while the detail lines of that record gets
> added to this new record.
>
> Meaning that invoice no 10068045 is no more in the table while the Invoice
> no 10075001 has some 21 detail lines instead of 15.
>
> This issue occured very rarely before when the records were less, now it
> occurs quite frequently. Can it be because of slow computer on a network or
> any other cause, kindly help.
>
> Sandeep Gupta
| |
|
| the update gets installed only to your development computer (those with
the full vfp installed), then you prepare another runtime distribution
setup to install at each client, this will update the runtime libraries
on each client.
you cannot and should not install the full vfp product at each client,
as this is a violation of your foxpro license, and will actually
complicate your situation.
Sandeep Gupta wrote:[color=darkred
]
> Hi Dear,
>
> Thankyou very much for your help. I have done the necessary and am waiting
> for a feedback from the client.
>
> I have installed the SP5 on main PS from where the executable is running and
> the data is residing, but on the client side the executable is running
> directly from the server as I have mapped the POS folder on the server to a
> local drive on the client.
>
> Do I need to still install the SP5 on the local client, as client does not
> have the VFP installed only the library files are present on the client side.
> In this case I will have to install the VFP first on each client and the the
> SP5, any help shall be highly appreciated.
>
>
>
> "Sandeep Gupta" wrote:
>
>
|
|
|
|
|