Graham Brown (CompSYS) <> wrote:
> Hi
>
> Thanks Stephen
>
> Just thinking about this, isn't the basic design of a foxpro app to
> assign the fields to the control source and then issue a tableupdate
> to commit.
>
> Changing the app to native datetimes means I can't use control source
> for any dates as I'd have to assign the date time to a variable, cast
> it to a date then place this in the text.value property.
>
> Does this mean the select statement in the ca is ignoring the
> cursorschema property when its fetching data?
>
> VFP not being able to handle dates when talking to SQL server sounds
> fairly major?
> Sounds nasty! I was looking to have one app with two sets of CAs so
> it's a quick swap but that doesn't sound feasible with this?
What I tried to say is that you need to have fox mimic your other backend in
the date column. Presently you have a date only in Fox and find that no
other backend is like that.
So you have to go the next step in your coding and change the date column to
be datetime, fix the gui issues as needed and you should be good to go.
I've done this before the cursoradaptor was available, and it's the only way
that it made sense.
The code I gave you makes a datetime value for midnight of that date BTW.
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
"A good way to judge people is by observing how they treat those who
can do them absolutely no good." ---Unknown
http://spaces.msn.com/members/srussell/
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.12/654 - Release Date: 1/27/2007
5:02 PM
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
