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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Peter

2005-04-07, 8:05 pm

Hi Rick,

I know that SQL Server has DateTime only. I did the following steps to
duplicate this:

1. Enlarge one of the char column of the SQL Server table
2. Modify the property Width of that column in the remote view to match
with the column size.
3. Save the remote view.
4. Open the remote view and check the SQL statement and find all the date
fields which used to have DataType D(8) becomes DataType D.

"Rick Bean" wrote:

> 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...
>

Sponsored Links