Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Work with table
Message
From
26/02/2009 10:23:53
 
 
To
26/02/2009 10:12:35
Reza Meamar
Homa Programming Group
Shiraz, Iran
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01384299
Message ID:
01384311
Views:
35
>>>Dear all,
>>>I have a table with some fields in it. One of my field is Discharge (Logical), I have a main form with a timer on it. In the interval event of this timer I check records each 5 minutes and if Discharge field of one record is .T., I show a label on main form.
>>>This table is open in all portion of my program and some user maybe work on it in another section of the program.
>>>How I can manage this procedure?
>>>Thanks
>>
>>In the timer event:
>>Select count(*) from yourtable where discharge into array adummy
>>thisform.yourlabel.visible=_tally>0
>
>Thanks for your reply,
>and with this command my table dont lose record pointer ?

Right, that's one of the reasons why you should use SQL commands whenever possible. The disadvantage of SQL commands is that they leave the tables open afterwards, so you may have to add code to close the table.
Previous
Reply
Map
View

Click here to load this message in the networking platform