Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where Deleted()
Message
From
28/03/2003 12:51:51
Humberto Ramirez
H. Ayuntamiento de Colima
Colima, Mexico
 
 
To
28/03/2003 12:34:44
Liam O'Hagan
O'Hagan Programming Ltd
Ireland
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00771350
Message ID:
00771403
Views:
10
Ok Liam...

The other query:

&& Delete type's holidays.
Delete From BuyHolidays Where idBuy == BuyType.idBuy
Delete In BuyType

&& Go to top and reload the holidays.
Go Top In BuyType
Select * From BuyHoliDays ;
Into Cursor curHolidays ;
Where idBuy == BuyType.idBuy And !Deleted('BuyHoliDays')
...
...
After this, the curHolidays is empty, but if I quit of the form and open it again the query work fine. And there are more than one Holiday in the table for the first BuyType (go top).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform