Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Handling null values in dBase IV through VB 6.0 or Cypress

Status
Not open for further replies.

saekbote

Programmer
May 8, 2003
1
PL
Hi

I am very new to dBase so I don't know how the fields and data types are classified in it.

I am writing an application using dBase IV and VB 6.0 and Cypress. I am using the Microsoft dBase ODBC driver (v. 4.00.6200) to connect to the DB file. My OS is W2K Server (Polish) with SP3.

I have a date field in a dBase IV database that sometimes contains null values. If I compile my application code using VB 6.0, then I can see that a particular record has null value in the date field (using debug mode as also using other methods to check the value of the variable). But if I use the same code in Cypress, it doesn't even recognize that the field has a null value!

I would like to know if:
a) I am using the right ODBC driver
b) there are other resources on the web about dBase field types
c) it is possible to handle null values differently (maybe treat it as "0" or a space character or something else...
d) Cypress can be used to write application for dBase IV
e) the Polish OS is giving the trouble

Please, someone help me !!!

Thanks in advance for a quick reply. :)

saekbote
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top