Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to handle .NULL. values in ODBC
Message
From
22/05/2001 18:14:04
Patrick O'Neil
American Specialty Information Services
Roanoke, Indiana, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to handle .NULL. values in ODBC
Miscellaneous
Thread ID:
00510117
Message ID:
00510117
Views:
29
created a database and in that, created a remote view (odbc) to
an access97 table.

when i browse the view, i can see all fields ok, but the fields
in the access table that have .null. values show up in my view
as character fields with value ".null."

how can i substitute a given value in this case ? (e.g. set
the value to 0 if the access field is .null.) ??
patrick
Next
Reply
Map
View

Click here to load this message in the networking platform