Search results for query: *

Hi, I need a way to write the following query: The problem is that I pass a variable sized Comma separated list of Strings that I need to include in the IN clause of the query.The @RepList variable will look like '5674','2345','3455'.... and so on. However if I pass that as @RepList as a string...

Hi, Is there any way I can create an index which indexes on field1 OR field2? (As opposed to a composite index which indexes like AND on both fields in the order specified?)

Hi, I have a simple SELECT query in SQL(with a LIKE clause in it) that runs very fast if called natively on the database prompt.It also runs equally fast as a stored procedure,however, after a long period of DB shutdown or logging off from the server and logging back in again the stored...

Hi, I am installing a BHO on the computer and deploy it as a dll which registers itself in the administrative account. It runs perfectly fine in the administrative account. However, when I switch to the limited account, the BHO just does not run.I tried some other dlls for toolbars etc and they...

Hi, I am using a project that generates a BHO for IE and I need to register the dll in order to make it work.It works perfectly fine on a normal windows XP system in any administrator account by simply doing a "regsvr32 dllname.dll" in the appropriate location, namely C:\ ...however on the...

Hi, How can I convert from TCHAR to wchar_t ? Can someone please tell me? Thanks

Hi, Can someone tell me how to convert a TCHAR string to char?? Thanks!

Hi, I want to convert a TCHAR string to char . How can I do it? Thanks

Hi, I have a BHO which captures all kinds of events, including new windows such as those fired by pop ups, right-clicking on a link ans selectiing open in a new window etc. This is captured by the DISPID_NEWWINDOW2 event. What is the corresponding function for a window opened with Ctrl + N, or...

Hi, I really do not have any such options in the file menu. I am using Microsoft Visual Basic.NET for the crystal report and the file menu there doesnt contain any such option. Also the crystal report itself when viewed in the crystal report viewer does not have a File option itself(leave alone...

Hi again, For some more insight, what I am doing is actually I am connecting to a MYSQL database on a server and copying the data into text files on a local machine. I use a file DSN to configure the text database and run queries on it. The queries are executed and give the correct result when...

I dont see any option of saving the data as well with the export report option. Where exactly does it allow you to save data with report?? Thanks

Hi, I am using crystal reports with VB.NET. I get the data from a MYSQL database thru a select statement and set the datasource in the crystal report viewer and do a form show in the end.It gives me an "Unkown query engine error" at runtime. Everything is correct including the results...

Hi, I am wondering if it is possible to create a crystal report and save it on the disk, and then later retrieve the same report and view it in the crystal report viewer. I know I can save it as pdf etc but I dont want to do that. I have saved it as a .rpt file on my local machine but when I...

Hi, I am trying to set up a DSN for Microsoft text driver. If I write the following code, I get the error that DSN entry Failed: intret = SQLConfigDataSource(0&, ODBC_ADD_DSN, "Microsoft Text Driver(*.txt,*.csv)", "DSN=AppliedEDSN") If intret Then...

Found the answer! Had to import the DLL as follows in VB.NET <DllImport(&quot;ODBCCP32.DLL&quot;)> Shared Function SQLConfigDataSource _ (ByVal hwndParent As Integer, ByVal fRequest As Integer, _ ByVal lpszDriver As String, _ ByVal lpszAttributes As String) As Boolean...

Can someone point me out to compiling code for the Sprintf function in VB .NET? Thanks

Hi, I tried doing the chr(0) option as well as the semi colons, but none of them work and I still get the same error. Please help :-(

Hi, I have been getting a System.NullReferenceException with the SQLConfigDataSource function. Can somebody please help? The following is the code: Public Declare Function SQLCreateDataSource Lib &quot;odbccp32.dll&quot; (ByVal hwnd&, ByVal lpszDS$) As Boolean Public Declare...

Hi, I have been getting a System.NullReferenceException with the SQLConfigDataSource function. Can somebody please help? The following is the code: Public Declare Function SQLCreateDataSource Lib &quot;odbccp32.dll&quot; (ByVal hwnd&, ByVal lpszDS$) As Boolean Public Declare...