|
-
August 13th, 1999, 10:10 AM
#1
Invalid use of Null
When I want to recover a datum from a database, which contains a Null value, the program shows an error message: Invalid use of Null.
For example:
Dim rstTemp as Recordset
sentence = "SELECT * FROM aaaa WHERE city='MZA'"
...
txt_phone.Text = rstTemp!phone
The data field "phone" has a null value. (no 0, no "")
¿What can I do? Thanks in advance!
-
August 13th, 1999, 12:59 PM
#2
Re: Invalid use of Null
I have the solution : the IsNull function.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|