Cursoradapter sees date type fields as character

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Cursoradapter sees date type fields as character

Message

08/08/2009 07:08:19

Yiorgos Kotsolakos
Athens, Grèce

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Cursoradapter sees date type fields as character

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows Server 2003

Network:

Windows 2003 Server

Database:

MS SQL Server

Application:

Desktop

Divers

Thread ID:

01416869

Message ID:

01416869

Vues:

224

SQLexpress 2008, ODBC, Sqlserver Native Client 10.0, VFP9 SP1

a) SQLEXEC(nhandle, "select ....","tempcurs") returns the DATE type fields as Character
b) When I build a cursoradapter from an SQL table characterizes (translates) the DATE type fields as CHARACTER.
Is this normal? Is it a bug?

Répondre

Fil

Voir

Click here to load this message in the networking platform