In desperate need of Help with VB6 and Sybase!!!!!!!!!!!!!!!!!!!!!

[goldi]

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.

 

[SonOfEmidec1100]

Dont know about Sybase but SQL server has a similar problem, to overcome it I use soemthing like this.

update mytable set mydate = null where ......

maybe it works for you.

 

[goldi]

Worked like a charm! Seems silly to HAVE to do it that way, but at least it works.

Thanks

 

[chiph]

Uhh, that's how you set the contents of a column to NULL in ANSI SQL. Always been that way.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first