Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MikeB
Constraint Violating Yak Guru
387 Posts |
 Posted - 2001-11-30 : 14:32:54
|
| I am using c++ and ado to read and write to an access database. I need help with the following sql statement?this is return 0 records:csQuery.Format("SELECT * FROM Component_Sched_Tbl WHERE project_id = '%s' AND component_id = '%s' AND component_issued_date = NULL", csProjectId, csId);"AND component_issued_date = NULL" is the problem portion, up until I add this portion it works correctly! Any help with this?Mike B |
|
|
LarsG
Constraint Violating Yak Guru
284 Posts |
Posted - 2001-11-30 : 14:49:48
|
| component_issued_date is NULL |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2001-12-05 : 12:07:05
|
| orIsNull(component_issued_date) |
|
|
|
|
|
|
SQL Null date field, using ADO??