>We are converting a FoxPro 2.6 application that used FPSQL.FLL to retrieve info. from SQL-Server tables into Visual FoxPro 5.0.
>
>FPSQL retrieved DateTime fields with a precision of 1/1000th. of a second. We don't seem to be able to get more than a second in precision with VFP 5.0. Is there any way to get better?
>
>Thanks.
>
>Jacques Mainguy.
Not sure what the precision of date/time field is. You can use the seconds() function and store that to a charcter field. Is a bit of a pain in string manipulation in coding but you can get to 1/1000th second easily.
HTH