Tim,
How about using Parameters? That *should* work ... (caveat: I haven't done any Fox w/ .NET, so take it with a grain of salt <g>)
~~Bonnie
>Ok I know I have been away from foxpro for awhile now and we still have a few fox tables around we use. I need to add a row to a fox table that contains a date. I am using a simple Insert command. Problem is the dot net DateTime structure is so different. Is there a way to change the format of get a format in C# Dot net that allows me to insert or update a fox table?
>
>DateTime myDate = DateTime.Now;
>Looks like 2/12/2008 11:35:44AM
>
>fox expects a date to look like this {^yyyy-mm-dd, hh:mm:ssa}
>I could parse this all out with a bunch of conversions but what a pain
>
>string foxDate = "{"
>foxDate += myDate.Year.ToString();
>foxDate += myDate.Month.ToString();
>etc. but this also would not quite conform since the month is 2 and would convert to "2" and not "02"
>
>Ideas welcome.
>Thanks
>Tim