SQL DATE issue in C11?

[ntnewbies]

Hi friends,
Am I the only one facing this problem?
I have upgraded my nettalk application to use NT11.04 under C11.

In C10, i declare DATE for the field and put d6 and it works. In SQL, it was interpreted as DATETIME.

But now, in C11, when i open a database with date field, it gives me error invalid field descriptor (75)
When i change the date to LONG and maintain d6, then it works.

Why such a change? I know that we can create a group and put the date and time inside it.
However, why there was no such issue when i use C10 with older NT?

Any input friends?

[Bruce]

>> But now, in C11, when i open a database with date field, it gives me error invalid field descriptor (75)

Unfortunately I'm not a SQL expert so I can't really advise too much here, but I think this is the root of your question and perhaps it's worth asking about this in the skype chats.

cheers
Bruce

[osquiabro]

I always use a group with datetime to avoid these errors, all my projects are in the SQL server.

I think SV change the driver for support the new date data type..

[ntnewbies]

Thanks osquiabro. I think so too.
If i want to change my C10 application to C11, then i need to use FM3 again to convert the date before compiling