Looking to delete information from three databases at the same time based on
the date. This is on a foxpro database on a Windows platform.
Databases:
* invoice.dbf
* shipments.dbf
* packages.dbf
I believe the relationship between them is the shipmentsid feild. The
closest thing I and another tech have come up with is this:
$ship_id=shipmentsid.invoices
DELETE * from invoices WHERE
shipmentsid.shipments=$ship_id AND
shipmentsid.packages=$ship_id IF
shippingdate>two weeks ago
This is where it breaks down:
Not sure is assigning the variable is necessary and if I have even done it
in the right place or if I am missing something. The script shhould grab
the date from the system that it is on and delete anything that is earlier
than two weeks from the date (i.e. 08-09-2005)
ANy thoughts or ideas would be great!
Cameron
_______________________________________________
clug-talk mailing list
[email protected]
http://clug.ca/mailman/listinfo/clug-talk_clug.ca
Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
**Please remove these lines when replying
