|
Im wondering you are using same code in two place parent and child in parent its working and in child its not working you can show context_menu but you cant run items in this menu on child menu.I tested like you step to step and it worked
|
|
|
|
|
Can you explain me your design if it differs from mine in some way?
thanks for your help.
Gajendra
|
|
|
|
|
well im writting a program (a parent dialog and a child) and then:
(1)Create a menu in resource and declare handler for items in main class
(2) im creating a button and insert these codes to it
<br />
<br />
CMenu m_Fpln_Revn_Menu, *m_Ptr_ContextMenu;<br />
<br />
CPoint point;<br />
GetCursorPos(&point);<br />
<br />
m_Fpln_Revn_Menu.LoadMenu(IDR_MENU1);<br />
m_Ptr_ContextMenu = m_Fpln_Revn_Menu.GetSubMenu(0);<br />
<br />
m_Ptr_ContextMenu->TrackPopupMenu(TPM_LEFTALIGN | TPM_LEFTBUTTON, point.x, point.y, AfxGetMainWnd());<br />
(3) and running my program
(4)when im clicking this button i can see a context_menu and when i click on items these works
(5) then im writting like these codes for child dialog and its working
Now you have this prolem with all your programs or only this program
|
|
|
|
|
I have problem with only this one becuase it works on others. I can't reveal the complete code to you 
But its ok, I think I know the solution what needs to be done.
Thanks much for your time and help. 
Regards,
Gajendra
|
|
|
|
|
if you create a new menu and repeat this stage whats happen?same problem
|
|
|
|
|
Till now I had only single context menu for that dialog. Will try to add another one for another dialog and lets see then.
Regards,
Gajendra
|
|
|
|
|
Hi,
I am trying to use bellow SQL in VC++ but when the I run it does not read the % which will not gave me the correct results:
SELECT * FROM ABC WHERE (CC LIKE N'%'"+ txt +"'%')
I looked on the net for similar situation but all use the text it self not variable (txt is CString), any suggestions to solve this.
Thanks and Best Regards,
Rasha
|
|
|
|
|
I don't think that the SQL syntax is correct. Have you tested it before? Are you trying to select records where the CC field starts with N and in has the provided text inside it?
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
is it mr Marcdev?
<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[![Jig | [Dance]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif) ]--
[My Current Status]
|
|
|
|
|
Touché!! 
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Your Sig said that!
<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[ ]--
[My Current Status]
Link2006 wrote:Let's take it outside of CP
Jeremy : Please don't.I would love to see this.I'm making the popcorn already.
|
|
|
|
|
I think your statement has problem if you run this line in Query Analyzer whats happen it work or no
|
|
|
|
|
it will work fine in query analyzer but in VC code it does not recognize the % singe so the result will look like this:
SELECT * FROM ABC WHERE (CC IKE N'miss')
NOT
SELECT * FROM ABC WHERE (CC IKE N'%miss%')
where miss is the value of the variable txt
tahnx
|
|
|
|
|
Can you provide the piece of VC++ code where there's the SQL statement and not just the SQL itself.
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
kindly find the function:
CString CGamesDlg::SetFlagCorrect(CString sms,CString level,CString Lang)
{
CString strConnect,sqlS,mDate,mQuestion,mContest,mTime,mLDate;
CDatabase db_mssqlx;
CTime T=CTime::GetCurrentTime();
mTime.Format("%02ld%02ld%02ld",T.GetHour(),T.GetMinute(),T.GetSecond());
mDate.Format("%ld%02ld%02ld",T.GetYear(),T.GetMonth(),T.GetDay());
mLDate.Format("%ld%02ld%02ld",T.GetYear(),T.GetMonth(),T.GetDay()-1);
CString xDT = mDate+mTime;
CRecordset *m_rec = new CRecordset ( &db_mssqlx ) ;
strConnect = _T(SQLConn);
sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%"+ sms +"%')" ;
AddToLog("sqlS:"+sqlS);
BOOL F1=db_mssqlx.OpenEx(strConnect,CDatabase::openReadOnly | CDatabase::noOdbcDialog);
m_rec -> Open( CRecordset::snapshot, sqlS, CRecordset::none ) ;
int count = m_rec ->GetRecordCount() ;
if (count==0)
{
m_rec -> Close( ) ;
db_mssqlx.Close( ) ;
return "1";
}
else
{
m_rec -> Close( ) ;
db_mssqlx.Close( ) ;
return "0" ;
}
}
|
|
|
|
|
rasha2003 wrote: AddToLog("sqlS:"+sqlS);
Using the debugger, what does sqlS look like at this point?
"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
it will look like
SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'أ')
|
|
|
|
|
rasha2003 wrote: sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%"+ sms +"%')" ;
If you are trying to search the records that starts with N and that contains the sms text inside, it would have to be the N inside the quotes:
="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE 'N%"+ sms +"%')"
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Hi Marc ...
i try that it generat the sql as bellow
SELECT * FROM Games_Qst WHERE (AnsTxt LIKE 'Nأ')
mean still not reading the %
|
|
|
|
|
I've also tried to debug it and the % appears ...
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
try this one
sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%باب%')" ;
or make sms value anything else than English
|
|
|
|
|
I can't  Does it work to you if you use English text?
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
even with English its not reading the value, send me the sql u used and worked with u pleas
|
|
|
|
|
It's yours !!! I haven't changed a word. I've ddebuged and stopped it at
sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%"+ sms +"%')" ;<br />
AddToLog("sqlS:"+sqlS);<br /> and it has the %s
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
rasha2003 wrote: mean still not reading the %
What exactly does "not reading the %" mean? Are you trying to select rows where the AnsTxt column begins with N? Is this with Access, Microsoft SQL, or MySQL?
"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
