Do you know the syntax for this?
SqlDataSource2.UpdateParameters.Add("DateCompleted", Now())
>Sorry, in your case you need a record rule. I'll post details a bit later.
>
>>>>Can someone tell me how to save the current datetime from an aspx page into a VFP database? I am trying
>>>>
>>>>
>>>>asp:Parameter Name="datecompleted" Type="DateTime" DefaultValue='>%=Now()%<'
>>>>
>>>>
>>>>
>>>>but it doesn't work. The error says the string is not recognized as a valid datetime.
>>>>
>>>>Thanks
>>>
>>>Just set the parameter in code behind, why do you need it in ASPX?
>>>
>>>BTW, which database we're talking about? May be you can just set it in the trigger instead?
>>
>>Its a VFP database, being edited via an aspx formview. If I create an update trigger with something like
>>
>>
>>repl datecompleted with datetime()
>>
>>wouldn't that create an infinate loop?