Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieve .NULL. from varchar fields
Message
From
09/04/2007 18:42:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Retrieve .NULL. from varchar fields
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01213726
Message ID:
01213726
Views:
72
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
Next
Reply
Map
View

Click here to load this message in the networking platform