Alex Terem's Q&A profile

• Visual Basic click event triggered by pressing enter

  Can anyone tell me how to trigger my click event by pressing enter while button is in focus. if the button has focus and enter is pushed the click event should automatically be triggered, If its not maybe you have a keydown event stopping it from occuring but from memory the enter overrides the mousedown event and click should still be triggered. Andrew ...Show All

• .NET Development How do you insert and update the database using DataSet (for VS .NET 2005)

  Hi! I'm currently new to VB .NET (through VS .NET 2005). I am in need of assistance regarding how to insert and update the database using DataSet. I am using OleDb in my program. It doesn't produce a syntax error after being compiled and executed but the data is not stored in the database. Please help if you can as soon as possible. Even a sample source code will do, it would even be better to give some explanation too. Thanks a lot! How do you update database Do you call Update method of the DataAdapter to do this. If not, then this is the reason. If you call Update and you do not see anything in a database, then check if you do not call AcceptChanges method before you call Update. AcceptChanges res ...Show All

• SQL Server how can i create 6digits unique number?

  i want to assign a unique 6digits numbers for every inserted record.. Can you make use an identity field That ought to be the most direct route. If you need to know the identity of the last inserted record you can take advantage of the SCOPE_IDENTITY function. ...Show All

• Visual Basic How can I search a database on multiple criteria selected from listboxes?

  I am new to VB and I am finding it difficult to understand. I am using Visual Studio 2005. I want to search a database for several items, I am using the My Movie Collection template to practice with and I want to be able to search for actors, directors and release dates and see the movies that match. I want to use listboxes for the items to search on and populate them with the possible options from the database. Ideally I would like the results to be updated as I click on the options in the listboxes (no 'search' button). I want to be able to click on more than one item in a listbox (e.g. several dates) and I want to be able to deselect items that I previously clicked on. I have found examples of searching for one thing in a datab ...Show All

• Visual C++ CSocket Connect question

  In my OnInitDialog function, I call the constructor of a CSocket inherited class. I then call create. I didn't want the dialog to freeze when I tried to connect so I put it in a seperate thread using AfxBeginThread. So I try to connect in this thread and it has a NULL pointer value for pState->m_hSocketWindow in sockcore.cpp. Am I not allowed to call Connect in a different thread then the thread I call create I think I came up with half an answer to this. I've read some posts about how MFC objects shouldn't be passed between threads because threads have seperate handle maps. In order to do this I have to call detatch in the main thread and attach in the worker thread. Then once the socket is connect ...Show All

• Visual Studio When Sharing a folder containing a project, the .vspscc files go crazy, or duplicate

  Following a suggestion from the VSS Help, regarding ways of maintaing to separate code version for a project, eg a released version, and a developement  version, where fixes from a released version would also be merged into the development stream. I shared our main project folder, instead of just branching it, to save space, so that for bug fixes, we would just need to branch specified files. An addition necessary step was to branch the actual project files (.vcproj) along with the associated vspscc files. This seemed to be necessary for visual sudio to be able to work with these projects and use source control. When I tried to branch the vspscc files they seemed to duplicate themselves. E.G. They would continue to to maintain a ...Show All

• SQL Server Loading tables with Foriegn Key contraints

  Hi, I am having trouble loading tables (within the same data flow) that have a foriegn key relationship defined between them. For instance: Table A is a parent (one side of the relationship) to Table B (many side of the relationship). I am trying to load Table A first within the data flow and then Table B after, but I get the following error: [OCMD EntityRole Insert [2666]] Error: An OLE DB error has occurred. Error code: 0x80040E2F. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E2F Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E2F Description: "The INSERT statement ...Show All

• SQL Server 0xC02090F5 DTS_E_DATAREADERSRCUNABLETOPROCESSDATA

  I am moving over 100 tables from mainframe to SQL Server 2005 using SSIS all but 2 tables have worked to some degree. 2 of the packages when executed write 0 rows to SQL Server becaue they are getting this error 0xC02090F5 = DTS_E_DATAREADERSRCUNABLET OPROCESSDATA I have looked at the definitions on the mainframe and SQL Server side all looks good. I have looked at the data on the Mainframe side and there is nothing unusual. The Mappings are simple one to one mappings At one time I could even preview the data while in designer building the package but when the packages for those 2 tables are executed I get the same error. Other tools can read the data. Does anyone know what could possibly be wrong ...Show All

• Visual Studio Express Editions binding source

  to  get a binding source . form the toolbox i get a binding source box; then in the properties box i chooce datacontrol, this then conects to a wizzard to ask if i want a database, i say yes. then im asked  about my connection so i select my mdf file. then i get another wizzard which gives me the tables i have, which i tick then im finished. why then does it not puit the data control in the properties box where it should.     ...Show All

• Visual FoxPro How to use user-defined DLL in VFP 9.0??

  I am trying to call a DLL writen by VC++ in VFP 9.0, but I have and error message: "Cannot find entry point "name" in the DLL" . I wonder that if that DLL file will accompany with VFP 9.0 and how could I check about that If I am trying it with VB6 by adding reference, it still work well. I also try with Define class... implement with Object Browser. But it don't work and the method return .T. when I call it in the pgrogram. Thanks in advance to anyone who can help me find out if I could use DLL that is not Win32API with VFP9.0, or I must use VB6 instead Best Regards As an addition to Alex's reply, keep in mind function names are case sensitive. That message generally in ...Show All

• SQL Server Creating offline (local) cubes using XMLA, or any other way..

  Hi, I realise this subject has been discussed a lot but there seems to be no definitive answer. The company I work for creates many cubes (currently using many SQL statements) for the sales regions at the end of each month and we need to move to a better platform, hence analysis services projects. Is there any "easy" way to take a cube created by an analysis services project and save it to an offline (local) cube Currently I am trying to use VB.NET 2005 to process the XMLA definition from AS2005, which is easy to get at. The VB code is: Dim myClient As New Microsoft.AnalysisServices.Xmla.XmlaClient Dim l_result, l_XmlaCommand As String l_result = "" Try ...Show All

• Visual Studio Retrieving "active" data connections

  Greetings everyone (or anyone), I am writing a little add-in and I am trying to figure out how to do something that I think should be simple: I want to retrieve the connections that are listed in the "Data Connections" in the Server Explorer. I can obviously access the UIHierarchy but what I really want is actually the connection(s) itself or the representation for the connection(s). Say the user has already defined a couple of data connections, I would like to get them and have access to the properties of the connection such as the connection string, and then access the field properties (isIdentity, etc). Essentially imagine that I am writing a custom properties form that shows the same information that the "Dat ...Show All

• Visual Studio Trapping Ascii keypress events.

  Hi, I want to handle Ascii key press events in my .Net 2003 plug in. I am able to trap arrow key press events but could not trap the same for ascii keys. There is only one linechange event in text editor, but what if one insert data in the same line.This will not raise any event. Is there any other way to do this. Kindly help me out please. Thanks and regards, Ruhina Parveen. How about write-protecting it Another better solution I can think of is that you provide a button that will magically generate the new file. If your users, as I guess, want to use it as a template, then it will be even easier for them just to click on a button. You can then do all kinds of nifty things not to have to recompile/reins ...Show All

• Software Development for Windows Vista Windows SDK for Vista RTM won't install on RC1

  I downloaded the new SDK for Vista RTM as DVD image and burned to a DVD. Tried to install on Vista RC1 5600, but Setup.exe fails with "unspecified error". I had the SDK for Vista RC1 previously installed, but completely removed it before attempting to install the new one. I also cannot reinstall the RC1 SDK now. Same error. What do I do now Can you please send me your log That will help me track down what's going on. ...Show All

• Visual C++ reading Japanase charactersets

  Hi I am reading XML form djvu images in VC 6.0. The characters of japanese language are saved correctly in file but when I display it or assign it to CString from GUTF8String (string datatype of DjVu Library) then the japanese characters change to some other japanese character styles. I think they are not displayed or assigned in the correct eoncding scheme in which there are originally in. Please let me know what can be the problem Your help will be greatly appreciated. I hope this is the right forum to post this question to.Please don't delete this post, as im really in need to solve this problem as early as possible. Thanks. It was realy a simple task. The problem ws just to convet the Xml f ...Show All