The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

Hi, Visual Basic 6; mysql = ( select something from table )

which will return some columns with some 'NULL's . Expected, no problem.

My If mysql(index) = NULL then else end if.

FAILS all the time.

Am I having a stupid moment?

I can get this to work:

if mysql(index) = "" then else end if

this seems to work, but I can not test on the "null" word. Have I looked at it too many hours? SMILE

asked 07 May '12, 17:32

George's gravatar image

George
165101017
accept rate: 0%


Use VB IsNull() method. i.e.,

dim rs as ADODB.recordset

set rs=new adodb.recordset
rs.open {mysql}
do while not rs.EOF
    if IsNull( rs.Field(1).value) then ...

  rs.movenext
loop
permanent link

answered 07 May '12, 21:56

Chris%20Keating's gravatar image

Chris Keating
2.9k1650
accept rate: 29%

edited 07 May '12, 22:21

I was concerned that null in sybase was different then in MS SQL, the statements do not work the same. I will try the IsNull. Starting at 6am and going until my eyes and brain give out.... is not good any more. thanks I will do it this way. I don't know why I could not see it. SMILE Again thanks

(07 May '12, 22:31) George

If IsNull(myRSTM(8)) Then Else Me.txtCustomerName = myRSTM(8) End If Works; I am reading a single record and filing out text boxes only. For some reason me.txtValue fails when the field is null. Even Dim string fails. Same code for MS SQL, that is what way throwning me. I don't now this voting thing, your IsNUll fixed it.

(07 May '12, 22:39) George
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×21
×18
×3

question asked: 07 May '12, 17:32

question was seen: 6,468 times

last updated: 07 May '12, 22:39