Please see my problem below: Table structure: tmpItemPrice(ItemPriceID bigint not null , Thickness varchar(255)) Row1 ItemPriceID: 1 Thickness: xyz Select ItemPriceID From tmpItemPrice Where IsNumeric(Thickness) = 1 and Cast(Thickness as float) <= 0 When above query runs it give my type conversion error which is logical as Thickness is not numeric. But when we use this query in IN clause as shown below it works fine. select * from tmpItemPrice Where ItemPriceID in ( Select ItemPriceID From tmpItemPrice Where IsNumeric(Thickness) = 1 and Cast(Thickness as float) <= 0 ) So my question are: - what is the reason behind it? - Is it right to use it in this way? Thanks

How can i capture the audio (in/out) from USB headset. Can this be done using DirectSound technology, if not then how can I do that. I am new in this area, So if you can provide me any article or sample code, it would be helpfull for me. qur

I have developed the web service and secured it using the WSE 2.0. Problem is client of this web service is in Delphi 6.0. What should i do to call this web service from the Delphi client. Thanks in advance.

I have developed the web service and secured it using the WSE 2.0. Problem is client of this web service is in Delphi 6.0. What should i do to call this web service from the Delphi client. Thanks in advance.

I am trying to map my ArrayList of type CRelation to data grid. CRelation class has two properties Child and Parent, both are of type CTable public class CRelation { public CRelation() { // // TODO: Add constructor logic here // } private CTable m_oPrntTbl; public CTable Parent { set {m_oPrntTbl=value;} get{return m_oPrntTbl;} } private CTable m_oChldTbl; public CTable Child { set {m_oChldTbl=value;} get{return m_oChldTbl;} } } public class CTable { public CTable() { // // TODO: Add constructor logic here // } private string m_szName; public string Name { set{m_szName = value;} get{return m_szName;} } } Now i want to map the grid column to Name property of the Child I am using following code to map the property DataGridTextBoxColumn dgcCol = new DataGridTextBoxColumn(); dgcCol.MappingName = "Child.Name"; Code above does not work. Am i doing something wrong here? Thanks

I have develop a List view control. Control has propert Columns which implements the IColumns interface. Now i want to persist this property by including it in Prop map. Below is the code BEGIN_PROP_MAP(CGridAdv) PROP_ENTRY("Columns", 14, CLSID_ColumnsProp) END_PROP_MAP() After doing that control crashes whenever container try to dislay it. Can anyone tell me how to do that? thanks qur

I have a Class CMyEdit which is inherit from CWindowImpl class and contains the Message Map for LButtonDown message. Now at run time I want to attach this class with Edit box using its window handler and want to capture the LButtondown event. Problem is i am not able to capture the LButtonDown message even if CMyEdit class is attached to Edit box. Code below show the way i am doing it. class CMyEdit : public CWindowImpl <CMyEdit> { BEGIN_MSG_MAP(CMyEdit) MESSAGE_HANDLER(WM_LBUTTONDOWN, OnLButtonDown) END_MSG_MAP() }; //Now at runtime: CMyEdit oMyEdit; oMyEdit.Attach(hWdnEdit); //Assuming hWndEdit is Edit box handler thanks qur

What is the way to give flat look to DateTime control. Thanks

I am trying to develop the gird control in which Comboboxes are displayed over each subitem. In DrawItem event i am displaying the combobox for each subitem, which is i think cause the flickering problem. Anyone knows the solution to remove the flickering in this scenario. for(int nRow = 0; nRow < rows; ++ nRow) { for(int nCol = 0; cols; nCol++ ) { //Drawing combos by ShowWindow(SW_SHOW) call } }

I am doing it in hardest way by capturing the OnDrawItem event. i am trying to dislay the Combos over the cell in this event, but problem is that when i resize the other column combos did not refreshed properly. What is the solution for this. thanks

Thanks.... I have try this code it works fine... but When i tried to draw a rectangle around the subitem in POSTPAINT event it did not work. Please see the code below else if ( (CDDS_ITEMPOSTPAINT | CDDS_SUBITEM) == pLVCD->nmcd.dwDrawStage ) { if ( 0 == pLVCD->iSubItem ) { RECT rc; HPEN newPen, oldPen; newPen = CreatePen(PS_SOLID,1, RGB(0,0,0)); oldPen = (HPEN)SelectObject(pLVCD->nmcd.hdc, newPen ); Rectangle(pLVCD->nmcd.hdc, pLVCD->nmcd.rc.left, pLVCD->nmcd.rc.top, pLVCD->nmcd.rc.right, pLVCD->nmcd.rc.bottom); SelectObject(pLVCD->nmcd.hdc, oldPen ); } else if ( 1 == pLVCD->iSubItem ) { HPEN newPen, oldPen; newPen = CreatePen(PS_SOLID,1, RGB(0,0,0)); oldPen = (HPEN)SelectObject(pLVCD->nmcd.hdc, newPen ); Rectangle(pLVCD->nmcd.hdc, pLVCD->nmcd.rc.left, pLVCD->nmcd.rc.top, pLVCD->nmcd.rc.right, pLVCD->nmcd.rc.bottom); SelectObject(pLVCD->nmcd.hdc, oldPen ); } *pResult = CDRF_SKIPDEFAULT; } Please tell me whats wrong with this code.... Secondly can i display combo on one of the column using the CustomDraw event.

I am creating the control based on SysListView32. Can some tell me how can i draw the subitems in OnDrawItem event.

Can we use Common Dialog for folder selection? if yes then how. -qur

Hi All I am calling the function from DLL using InteropServices. But when i called the function that accept the string as parameter NullReference exception is thrown. Actual function signature: int GetName(int pModel, int iVar, char *pszVarname); Function Signature for C#: [DllImport("C:\\MyFunctions.dll")] public static extern int GetName(int nProb, int nIndex, ref string sVarName); Fuction Call: string sVarName; int nErrCode, i; i = 14; sVarName = "x123456"; nErrCode = GetName(nProb,i, ref sVarName); //Getting NullReferenceException Thanks in advance qur

I have little confusion that i wanted to clear out. Please see the following code: //defination SetMstrRS(IMstrRS * pMS); CComPtr <IMstrRS> pMS; pMS.CoCreateInstance(...); SetMstrRS(pMS); Now in the last statment is AddRef called by SmartPointer before it is passed to the method. thanks in advance qur

I am writing the addin in ATL. To implement the desired feature i want to access the information about the classes included in the workspace. Anyone knows how to get the information. Thanx -qur

I have checked it at the specified location it exists. One more thing i have registered same dll on some other machine and it works on it.

DLL is registered and same code is working fine when called from VB client.

I have made component using ATL Com bu when i called it from ASP, i am getting follwoing error: Server object, ASP 0177 (0x8002801D) Library not registered. Code: dim objTrim set objTrim = server.CreateObject ("MY_TRIM.TrimMain") What am i missing here Thanx

I have to question: 1- If I chose "yes" in aggregation section of ATL Object Wizard then should a create the coclass object using CComAggObject or CComObject? 2- Do same reference counting rules apply when creating coclass object through CComObject as with interface pointers? Thanx in advance. qur