nuAnonymous's Q&A profile

• .NET Development ADO.NET/Access DB Insertion Exception

  I’m working with an Access Database and ADO.NET. I have a record insertion routine that works on some tables and not others. The exception is “syntax error in Insert Into Statement” and it’s from an improperly constructed string. Public Function InsertRecord( ByVal NewRow As DataRow, ByVal Table As DataTable, Optional ByVal Update As Boolean = True ) As Boolean 'works NewRow(DataRecords.ciRecordNum) = Ta ...Show All

• SQL Server Sql date substract question

  Hi everyone, I need to substract one day from de system date(yesterday). example: execute spGetCustomers GetDate()-1,null,null --system date less one day(yesterday) Can someone tell what is the SQL sintax to do that. Thank's Hey, Your example itself is right !! you can use getdate(). anyways, this is the syntax. dateadd(dd, -1, getdate()) Amarnath ...Show All

• SQL Server How can I avoid using a CURSOR inside of another CURSOR

  I am trying to avoid using a CURSOR inside of another CURSOR. Here's what I have to do... I have 3 tables: Table1 has 500,00 rows Table2 has 25 rows Table3 is empty For each row in Table1, I want to INSERT 25 rows (from Table2) into Table3. Using a CURSOR inside of another CURSOR, my code looks like this... Define and open CURSORA for TABLE1 FETCH the first row from TABLE1 using CURSORA WHILE (@@FETCH_STATUS&l ...Show All

• Visual Studio Tools for Office Best way to do this?

  Hello, Hopefully someone would have some advice, I'd like to trigger an action inside outlook from outside outlook. I.e. pop-up a new contact window for the user to access. Should I approach this from a mapi standpoint or use IPC with a VSTO add-in inside of Outlook... I'm not sure what the "most correct" way to go about this is. Thanks! Well, I'm far from being an expert, but in my opinion an Outlook ...Show All

• .NET Development How distribute Configuration Manager?

  Hi all, I need to distribute .Net framework 2.0 configuration manager. This tool is not included in redistributable file but only in sdk. Is it posible to distribute only Net framework 2.0 Configuration mmc   Thanks. What tool are you wanting to distribute   The .NET 2.0 Configuration component for MMC ships with the .NET 2.0 runtime.  The SDK itself doesn't contain the tool (other th ...Show All

• Visual FoxPro Enhancement Request: Ability to pass cursors as parameters

  The ability to pass a cursor to a method of an object belonging to another data session would be a great addition for a future versions of VFP. Today, we have to resort to arrays, which is kind of a kludge, or CursorToXML/XMLToCursor, which is way too slow for large data sets. If cursor could be passed between data sessions, n-tier apps would benefit greatly. Any thoughts Eyvind.   Craig Berntson wrote: ...Show All

• .NET Development Getting the type of a value entered in a Textbox?

  Hi there, Well, i'm using VB.NET2003. I'm trying to get the datatype of a value that I've entered in a textbox, and according to the value the resultset returns, it must validate to see if the value are in fact numeric, or an integer value, if it's anything else, I want to notify the user that the value entered are in fact not a valid entry, and that the value must be re-entred. If someone can please help me. Thanks SJB ...Show All

• Windows Forms memory consumption and windows forms

  Hi all, I'm using Visual Studio 2005 and .NET framework 2.0. I have a windows form application in which I load a form that has a dynamic user control array. I may have hundreds of instances of my user control on the form depending on the user. The control is a simple array of text boxes but when I have hundreds of instances it uses several megabytes of memory, up to 20 MB depending on the number of instances. In the task manager, I've note ...Show All

• .NET Development AutoInstallation of framework

  Hi. I want to make a setup for my application that automatically and in background installs .Net Framework 2 with my application. Can you help me, please Best wishes Something like this: http://www.codeproject.com/dotnet/dotNetInstaller.asp or this: http://www.microsoft.com/downloads/details.aspx familyid=cd11be5a-c735-48d9-9cdd-a6d211c2e1c1&displaylang=en     You can't put the framework install as part of you ...Show All

• Microsoft ISV Community Center Forums Problem with VBA script

  Dear all, Can you please help me with the following problem I wrote a script to get the data out from the SQL Server and then format the cells. However, it seems it doesn't run the part B to format the cells. Any idea Thanks. 'Part A : Get the data from the SQL Server sqlstring ="select custid, custname from customer" connstring = "ODBC;UID=uid;PWD=p123;DATABASE=prod;DSN=HK0001" With ActiveSheet.QueryTables.Add( ...Show All

• Visual C++ DLL Compatibility?

  I am converting an app from vc6 to vc8 (vs2005). I've got everything to compile fine, and most of the testing looks good. While system testing in Release mode, I get an occasional crash. The dialog box says "PCSMain.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created". Even though I have drwtsn turned on, I don't see any error logs being created. Even while ...Show All

• Visual C# hint in controls

  good afternoon How could I put hints in my visual controls In Delphi I used to putting in hint property, but in C# I couldn't find this property. Thank You, Ederaldo Drag and drop tooltip control from ToolBox. By default tooltip control will be named as tooltip1. Then view the properties of text box . You will find tooltip property. Enter the text text of what you want to display. These things can be done dynamically also (*i. ...Show All

• Visual J# J# MSPress "Build a Program Now" and J# Express edition Forum

  Hi everyone, Anyone know if there is an MSPress "J# 2005 Build a Program Now" book coming out in the not too distant future. The VB and C# books are wonderful for beginners and they have the program CD along with SQL express included for about $16. Very thoughtful of Microsoft and they should be congratulated for making it easier for folks to begin to convert over from Java taught in most lower level college classes. Also anyb ...Show All

• Visual C++ Help w/ Code

  //WaveIn.h #ifndef _WAVEIN_H #define _WAVEIN_H #include <windows.h> #include <mmsystem.h> typedef struct { WORD wFormatTag; WORD nChannels; DWORD nSamplesPerSec; DWORD nAvgBytesPerSec; WORD nBlockAlign; WORD wBitsPerSample; WORD cbSize; }WAVEFORMATEX; MMRESULT IsFormatSupported(LPWAVEFORMATEX pwfx, UINT uDeviceID) { return (waveOutOpen( NULL, // ptr can be NULL for query uDeviceID, ...Show All

• Visual C# how to count elements inside an array?

  if I have an array of 32 byte for example. but there's only 8 slots used. How can i count the number of slots used. .length() or .getlength(0) only give me the total size of the array. Thank ya'll Donkaiser As far as I know there really is no way to tell, especially with value types such as integers/bytes since these are not "null". If they were reference objects you could use a for loop and check if ...Show All