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
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