FoxPro database connector - Why do some date fields have DataType D(8) instead of DataType D?

Author

Why do some date fields have DataType D(8) instead of DataType D?

Peter

2005-04-07, 8:05 pm

I'm looking at the SQL statement of a remoteview to a SQL Server table
through View SQL of the View Designer and the prg generated from gendbc. I
notice that some Date fields are showing having DataType D or DataType
D(8). What is the difference between DataType D and DataType D(8)?

Thanks.

Rick Bean

2005-04-07, 8:05 pm

Peter,
I'm not sure about the designations, but MS SQL Server has no Date (D) =
field type only DateTime (T).

Rick

"Peter" <Peter@discussions.microsoft.com> wrote in message =
news:EF5EC67D-C7EB-469A-893D- 86BCC986D099@microso
ft.com...
> I'm looking at the SQL statement of a remoteview to a SQL Server table =

> through View SQL of the View Designer and the prg generated from =
gendbc. I=20
> notice that some Date fields are showing having DataType D or =
DataType=20
> D(8). What is the difference between DataType D and DataType D(8)?
>=20
> Thanks.

Sponsored Links