NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: ntnewbies on December 18, 2018, 06:10:03 AM

Title: SQL DATE issue in C11?
Post by: ntnewbies on December 18, 2018, 06:10:03 AM

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?

Title: Re: SQL DATE issue in C11?
Post by: Bruce on December 19, 2018, 01:58:19 AM

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

Title: Re: SQL DATE issue in C11?
Post by: osquiabro on December 19, 2018, 04:38:59 AM

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

Title: Re: SQL DATE issue in C11?
Post by: ntnewbies on December 19, 2018, 08:07:22 PM

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  :-[