Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying data on second monitor
Message
From
28/02/2023 06:03:49
 
 
To
28/02/2023 04:01:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01686274
Message ID:
01686292
Views:
34
It could be done without exclusive rights but...
Scenario is couple POS (on network) with about 200-300K item sales records per month on each POS. If I use DELETE instead of ZAP after each sale, calculate size of local table after one year. This is one quick reason.

>>I have a local table which is open exclusive. INSERT, DELETE, ZAP is used on that table.
>>Any ideas how to display those data on second monitor on a fly with all changes applied? I prefer another program which is displaying on a second monitor (extend monitor).
>>
>>Thanks.
>
>May I ask WHY you have chosen to use a table exclusive? Zapping on a regular basis sounds like a bad choice, why don't you use a cursor instead? In "my book", zap is a command that should only be used maximum once or twice per year, in a specially designed table maintenance module. If ever..., I haven't used zap since the last millennium, actually I can't remember ever having used it. It's on my "commands to avoid" list, which also includes Insert. Unless by Insert you mean the SQL version, Insert in VFP comes in two completely different flavors.
>
>In my applications, the only table that is ever opened exclusive, is the table that keeps track of the last used invoice number and other numbers that has to be sequential. This table only has one record, and is never open more than a few milliseconds, before it's closed again.
>
>Maybe if you provide more information, I can give you some more assistance.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform