Click here to Skip to main content
15,887,821 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Allocate memory Pin
Maer7278-Nov-01 17:02
Maer7278-Nov-01 17:02 
GeneralRe: Allocate memory Pin
Tim Smith8-Nov-01 7:56
Tim Smith8-Nov-01 7:56 
GeneralRe: Allocate memory Pin
Maer7278-Nov-01 17:06
Maer7278-Nov-01 17:06 
Generalsubitems in list control Pin
8-Nov-01 1:34
suss8-Nov-01 1:34 
GeneralRe: subitems in list control Pin
Ravi Bhavnani8-Nov-01 2:06
professionalRavi Bhavnani8-Nov-01 2:06 
GeneralRe: subitems in list control Pin
8-Nov-01 2:37
suss8-Nov-01 2:37 
GeneralSurpressing dialog keypress beeps Pin
andysolman8-Nov-01 1:03
andysolman8-Nov-01 1:03 
GeneralCRecordset params Pin
Jimmy Ehrnström8-Nov-01 0:28
Jimmy Ehrnström8-Nov-01 0:28 
I'm using a CRecordset with three parameters to read and write data to a database table, but I'm having some problems selecting records where one of the columns contains no value (NULL).

How do I set my filter when I want one of my specified paramters to be NULL in the database?

This is my filter now:

prsFoo->m_strFilter = "ColumnA=? AND ColumnB=? AND ColumnC=?";
prsFoo->m_ColAParam = m_ColumnA;
prsFoo->m_ColBParam = m_ColumnB;
prsFoo->m_ColCParam = m_ColumnC;


But what should I set m_ColCParam too if I want that column to have no value (NULL) in the selected set? My member variable m_ColumnC is a CString and when it's empty I want to select the records without a value in column c.

Any help would be greatly appreciated! Thanks!
GeneralRe: CRecordset params Pin
Tomasz Sowinski8-Nov-01 0:42
Tomasz Sowinski8-Nov-01 0:42 
GeneralRe: CRecordset params Pin
Jimmy Ehrnström8-Nov-01 2:52
Jimmy Ehrnström8-Nov-01 2:52 
GeneralRe: CRecordset params Pin
Tomasz Sowinski8-Nov-01 3:03
Tomasz Sowinski8-Nov-01 3:03 
GeneralRe: CRecordset params Pin
Jimmy Ehrnström8-Nov-01 3:09
Jimmy Ehrnström8-Nov-01 3:09 
GeneralRe: CRecordset params Pin
Tomasz Sowinski8-Nov-01 3:44
Tomasz Sowinski8-Nov-01 3:44 
GeneralRe: CRecordset params Pin
Carlos Antollini8-Nov-01 3:34
Carlos Antollini8-Nov-01 3:34 
GeneralSetFocus hassles Pin
Christian Graus8-Nov-01 0:12
protectorChristian Graus8-Nov-01 0:12 
GeneralRe: SetFocus hassles Pin
Tomasz Sowinski8-Nov-01 0:43
Tomasz Sowinski8-Nov-01 0:43 
GeneralRe: SetFocus hassles Pin
Christian Graus8-Nov-01 0:52
protectorChristian Graus8-Nov-01 0:52 
GeneralRe: SetFocus hassles Pin
Tomasz Sowinski8-Nov-01 0:58
Tomasz Sowinski8-Nov-01 0:58 
GeneralRe: SetFocus hassles Pin
Christian Graus8-Nov-01 1:01
protectorChristian Graus8-Nov-01 1:01 
GeneralRe: SetFocus hassles Pin
Tomasz Sowinski8-Nov-01 1:03
Tomasz Sowinski8-Nov-01 1:03 
GeneralRe: SetFocus hassles Pin
Christian Graus8-Nov-01 1:13
protectorChristian Graus8-Nov-01 1:13 
GeneralCombo box nightmare Pin
-Dy7-Nov-01 23:38
-Dy7-Nov-01 23:38 
GeneralRe: Combo box nightmare Pin
7-Nov-01 23:45
suss7-Nov-01 23:45 
GeneralRe: Combo box nightmare Pin
-Dy8-Nov-01 0:20
-Dy8-Nov-01 0:20 
GeneralFaking mouse movement and clicks Pin
7-Nov-01 22:50
suss7-Nov-01 22:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.