>> >>Then you should not be asking us. You are opening a table called "main1". >>If the table does not open or is not found, look to see why. It does not exist, or is not in the search path, or you are not using the correct table name, or... >> >>Another issue: Is main1.date a date-type field? >>If it is, you cannot do STRTRAN() on it as it only works for character fields. > >The problem is that you cant use the syntax alias.field = value . You need to use the REPLACE command to update a table value. If you wanted to use a memory varible use either m. or just the variable name.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry