Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No table is open in the current work area
Message
From
08/01/2008 07:32:46
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
08/01/2008 06:30:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01280061
Message ID:
01280164
Views:
28
Hi Marcia,

What's wrong with Views or CAs?

A simple REQUERY() or Cursorrefresh would do it.

Agnes
>Hi Ture.
>
>Naomi's URL points you to an article which describes both how and why you should use another techniques than setting the recordsource to empty. To ease the reading pain, this is the short version of this technique:
>Select whatever into cursor curdummy && Your usual select statement, but into a dummy cursor
>Select yourcursor && yourgrid.recordsource
>Zap
>Append from dbf('curdummy')
>yourgrid.refresh()

>
>Actually, in VFP 9, the code can be optimized even more:
>
>
>SELECT yourcursor && yourgrid.recordsource
>ZAP
>INSERT INTO yourcursor SELECT Yada, Nada, Blah FROM SomeTables WHERE SomeCondition
>yourgrid.refresh()
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform