...DateTime dend = new DateTime(2007,2,13); comd.CommandText = "insert into mytable (datbegin,datend) values(@dstart, @dend)"; comd.Parameters.AddWithValue("@dstart", dbeg); comd.Parameters.AddWithValue("@dend", dend); This will make sure the data is passed as a DateTime. 2) Another ...

...DateTime dend = new DateTime(2007,2,13); comd.CommandText = "insert into mytable (datbegin,datend) values(@dstart, @dend)"; comd.Parameters.AddWithValue("@dstart", dbeg); comd.Parameters.AddWithValue("@dend", dend); This will make sure the data is passed as a DateTime. 2) Another option ...

...the date as a string. DateTime sbeg = new DateTime(2007,2,8); comd.CommandText = "insert into mytable (datbegin,datend) values(@dstart, @dend)" comd.Parameters.Add(new SqlParameter("@dstart", dbeg)); comd.Parameters.Add(new SqlParameter("@dend", dend)); This will make

... in VFP 7 when i try to execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; ...

... fine in VFP 7 when i try to execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; ...

...works fine in VFP 7 when i try to execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; ...

... works fine in VFP 7 when i try to execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM ...

...thing works fine in VFP 7 when i try to execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ;...