how to set null value from vb to sql server

21 Jul 2006 7:47 AM

vincentstudy

hi to all,

i am using sql 2000 server now i want to set null value
to my table from visual basic code. i am try to some update query shown
below.

my table name

rs.open "update student set newid = null where sname='raja'"
rs.open "update student set newid = 'null' where sname='raja'"
rs.open "update student set newid is null where sname='raja'"

but any one not update null value to table . i want solution to this
problem.

regards,

vinci

21 Jul 2006 8:04 AM

vincentstudy

hi to all,

now my first query is run successfully because my
variable name is wrong that is problem . ok thanks to all do to try
this one.

by

vinci

vincentstudy wrote:
Show quote

> hi to all,
>
> i am using sql 2000 server now i want to set null value
> to my table from visual basic code. i am try to some update query shown
> below.
>
> my table name
>
> rs.open "update student set newid = null where sname='raja'"
> rs.open "update student set newid = 'null' where sname='raja'"
> rs.open "update student set newid is null where sname='raja'"
>
> but any one not update null value to table . i want solution to this
> problem.
>
>
> regards,
>
> vinci

21 Jul 2006 3:13 PM

Arnie Rowland

Thanks for following up your own post. It prevents others from wasting their
time trying to help you after you have solved the problem, and it helps
others when you share your solution.

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"vincentstudy" <vincentst***@gmail.com> wrote in message
news:1153469052.464694.176310@75g2000cwc.googlegroups.com...
> hi to all,
>
> now my first query is run successfully because my
> variable name is wrong that is problem . ok thanks to all do to try
> this one.
>
> by
>
> vinci
>
>
>
> vincentstudy wrote:
>> hi to all,
>>
>> i am using sql 2000 server now i want to set null value
>> to my table from visual basic code. i am try to some update query shown
>> below.
>>
>> my table name
>>
>> rs.open "update student set newid = null where sname='raja'"
>> rs.open "update student set newid = 'null' where sname='raja'"
>> rs.open "update student set newid is null where sname='raja'"
>>
>> but any one not update null value to table . i want solution to this
>> problem.
>>
>>
>> regards,
>>
>> vinci
>