>Hi to all:
>I'm working with the oledb provider for VFP databases and when I insert into a table a date in DD/MM/YYYY format it stores the data in MM/DD/YYYY format althoug I set date to british in the main prg.
>When I read dates ,it works fine but not when I insert new records.
>Some help needed.
>Thanks.
>Pedro
The VFP OLEDB provider has it's own settings including SET DATE and they are not affected by settings in the calling program. You've to SET DATE TO BRITISH for VFP OLEDB provider either by setting it's properties or by sending SET DATE TO BRITISH command to it.
--sb--