check if no results found on mysql quey

Trainee

Date of registration: Aug 14th 2012

Wednesday, October 24th 2012, 5:25pm

Good afternoon !

Does anybody know why this does not work on me?

If (Data.wasNull()) Then
MsgBox "NULL"
Else
MsgBox "not NULL"
End If

i want to check if msql query is nothing because when i tried to compare with NULL OR "" nothing happened.
*****when it finds a record it appears not NULL but when it does not find any record it does not appears the
MsgBox "NULL" *******

Thanks in advanced

Go to the top of the page

Similar threads

- General topics, questions and discussions »
- msgbox with the value of selected item of a combobox (Oct 16th 2012, 3:52pm)
- General topics, questions and discussions »
- date format from yyyy-mm-dd to dd-mm-yyyy (Oct 4th 2012, 10:14am)
- Suggestions »
- Translate Jabaco into your native language (Nov 25th 2008, 3:53am)
- General topics, questions and discussions »
- Connect to MySQL database (Jan 27th 2009, 4:41am)
- General topics, questions and discussions »
- Connect to MySQL Database without Database component (Jun 18th 2009, 6:55pm)