Why does COUNT(*) via SPT yield a character field? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Why does COUNT(*) via SPT yield a character field?

Message

De

06/11/2010 02:32:21

Dennis Lim
D-Labs, Inc.
Manila, Philippines

À

05/11/2010 08:12:55

Naomi Nosonovsky
Wisconsin, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

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

Titre:

Re: Why does COUNT(*) via SPT yield a character field?

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows 7

Network:

Windows 2003 Server

Database:

MySQL

Application:

Desktop

Divers

Thread ID:

01488353

Message ID:

01488432

Vues:

42

Naomi,

Are you using SQL Server? Is so, the dates are in the wrong format and also this condition YEAR(PostDate) > 0 is strange. What is the reason for this?

Hi. I am using MySQL and I believe that is how its dates are structured. Since there is no EMPTY() function in MySQL, I have been using YEAR( date ) > 0 as a way to check if a date field has been populated. =)

Dennis

Click here to load this message in the networking platform