Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete Month
Message
From
21/08/2007 08:02:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Delete Month
Miscellaneous
Thread ID:
01249317
Message ID:
01249317
Views:
58
Dear Experts

Table1 has only one field as

month c(7)

and data in table is as

06-2007
06-2007
07-2006
07-2007
07-2007
08-2007
07-2007

Now I want to delete all enteries containing 07-2007
For this, I use this command but it does not work
curmon=07-2007
lnMonths3 = Val(Substr(curmon , At("-", curmon )+1)) * 12 + Val(curmon ) - 1
CVAR3 = Str(Int(lnMonths3 / 12), 4)+Padl(Int(lnMonths3) % 12 + 1, 2, "0")
Select Table1
delete for month=m.cvar3
pack
In 07-2007, 07 is month and 2007 is year
I use British date

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform