Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieve .NULL. from varchar fields
Message
De
09/04/2007 18:42:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Retrieve .NULL. from varchar fields
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Divers
Thread ID:
01213726
Message ID:
01213726
Vues:
74
Hi..


when reading a mysql table and concating a character field, I'm trying to deal with null values... any test that I made isn't work fine..

how could I test if my gotten record of a mysql it is a null value? it isn't the same as vfp?

on my result I got that weird result... before null:

a= "record1 record2 record3 record4"

after null:

a=.NULL.

I'd like to:

if !myfield=NULL
a = a + a
endif

TIA

Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform