I think I'm missing something....
I have been coding in VB6 for a couple of years, last year I started using Sybase ASA 7 for my database and I'm becoming very frustrated (no training).
The latest thing has been removing data from fields - specifically date fields. With character fields I have found moving " " to the field will blank it out, but now I have fields that have a space in them and not really blank. I get an error if I try to move nulls or an empty string. With the date fields, I have found that I can move a 0 to it, but that makes it equal 12:00 AM! I want to be able to remove a date and leave the field a null which is how it started out.
Am I missing a reference in my VB project? I'm using ADO 2.6. Is the only way to update these fields through SQL? Entering data for the first time is no problem, it's getting it back out.
I have been coding in VB6 for a couple of years, last year I started using Sybase ASA 7 for my database and I'm becoming very frustrated (no training).
The latest thing has been removing data from fields - specifically date fields. With character fields I have found moving " " to the field will blank it out, but now I have fields that have a space in them and not really blank. I get an error if I try to move nulls or an empty string. With the date fields, I have found that I can move a 0 to it, but that makes it equal 12:00 AM! I want to be able to remove a date and leave the field a null which is how it started out.
Am I missing a reference in my VB project? I'm using ADO 2.6. Is the only way to update these fields through SQL? Entering data for the first time is no problem, it's getting it back out.