RE: SQLServer Cursor Adapters

2007-01-30 Thread David Stevenson
Graham, >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 i

Re: SQLServer Cursor Adapters

2007-01-28 Thread MB Software Solutions
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 nex

RE: SQLServer Cursor Adapters

2007-01-28 Thread Stephen the Cook
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 a

RE: SQLServer Cursor Adapters

2007-01-28 Thread Graham Brown \(CompSYS\)
looking to have one app with two sets of CAs so it's a quick swap but that doesn't sound feasible with this? Cheers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen the Cook Sent: 28 January 2007 15:49 To: 'ProFox Email List' Sub

RE: SQLServer Cursor Adapters

2007-01-28 Thread Stephen the Cook
Graham Brown (CompSYS) <> wrote: > Hi all > > I'm still working through the upsize to sqlserver. The first problem > I've encountered is that SQL upsized my dates to datetimes. I've > changed the cursoradapter so that everywhere it mentioned a time type > it now shows a date. > > The control s