Stephen the Cook wrote: > 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. > Not exactly. MySQL has a DATE field as well as DATETIME!
> 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. > Yes, certainly keep Stephen's CONVERT function handy as you'll need it if you're using SQL Server (as you said you were iirc). Also, Dave Crozier gave me a tip recently for setting the controlsource to a value with =TTOD() or a similar function. Check out Dave's posts for this month searching for controlsource (or control source--can't recall how he spelled it) and you should find it. http://leafe.com/archives/search/profox -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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.
