RE: VFP SQL SERVER DATE UPDATE

Can you post the code where you update SQL Table?

> I have set the date to british in the load, yet I'm not getting the expected update.
>
> The sql datafile is updated with the exact datefield when you use the

insert

command.
>
> The

update

command is just not picking the chages made to the date fields.
>
> Thanks
>
>
>
> > > Dear Expert,
> > >
> > >
> > > I have a british date format which only updates when the date format "dd/mm/yyyy" does not exceed say 12/12/2005, for the day side and month side
> > >
> > >
> > >
> > > If say the date is say 15/12/2005, the update condition will return an update. However when you observe the record there is no update.
> > >
> > > I have tried the following approaches to resolving this issue,but there is no light at the end of the tunnel.
> > >
> > > 1.
> > > m39 = transform(thisform.pageframe1.page1.appdate1.value, '@D')
> > > m40 = transform(thisform.pageframe1.page1.datebth1.value, '@D')
> > > m41 = transform(thisform.pageframe1.page1.dateconf1.value, '@D')
> > >
> > >
> > > 2.
> > > m39 =DTOT(GOMONTH(THISFORM.pageframe1.page1.appdate1.value,12))
> > > m40 =DTOT(GOMONTH(THISFORM.pageframe1.page1.DATEBTH1.value,12))
> > > m41 =DTOT(GOMONTH(THISFORM.pageframe1.page1.DATECONF1.value,12))
> > >
> > >
> > > What is the way forward in resolving this problem?
> > >
> > >
> > > I will be most delighted if an Stored procedure will in addition be used to save date
> > >
> > >
> > > Than you and God Richly bless you.
> >
> > Fred,
> >
> > Take a look at the command SET DATE. Note that this command is scoped to the data session, so if you are using private data sessions, you will need to re-issue this command in your form's .load()
> >
> > Ken
> >
> > You shall know the truth - and the truth shall set you free. (John 8:33)
>
>
>
> ggggggggggg



Borislav Borissov