could be because of the {9/9/99}, you cannot do that anymore in VFP, you could in FPDOS but not anymore

see this

Example
? DTOT({^1998-02-16}) && Displays 02/16/1998 12:00:00am

you have to include the ^ and specify date like yyyy-mm-dd

{^yyyy-mm-dd}

try also living an space between the tablename and the (fields), same in the values ()