Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View
Message
 
 
To
03/10/2001 14:09:47
Douglas Salla
Folhamatic Sistemas
Americana, Brazil
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00563758
Message ID:
00563782
Views:
19
You do not need the DELETED() = .f. expression in any view or cursor or table. To filter out deleted records, make sure you put SET DELETED ON in the BeforeOpenTables of any form's data environment that is used to open tables or views. Typically, I put the following in the form DE:

set talk off
set deleted on
set exclusive on
set multilocks on
set database to MyDBC

>Good afternoon the whole ones.
>
>I have a Remote View and inside of that Remote View I have two tables
>related one with the other, in the filter of that Remote View I place the
>expression DELETED () = .F. for her not to bring the registrations deletados, me
>I show the data of that Remote View in a Grid, only that if I maintain the expression
>DELETED () = .F. Grid doesn't show the registrations and if I remove the expression
>DELETED () = .F. of Remote View the registrations appear, I already verified the
>it controls and the registrations are not deletados, it will be that that happens for some
>influence of the relationship?
>
>I am using Windows 98 IF, VFP 6.0 and the SP5, the base of data for server is the own
>DBC of FOX and the configuration of the driver ODBC the option is not checked DELETED
>
>Will it be that anybody can help me?
>
>Thank you.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform