Ronni M's Q&A profile

• Visual FoxPro MySQL and VFP

  Hi experts. I have a MySQL database. I operate with them using syntax like SQL(sqlhandle, "select * from...") I copy them into cursor and than operate with a cursor. Is there a simplier way how to work with them Thanks in an advice. I understand but I have asked whether the problem may be that I am using free MySQL database, whether this speed isue can be one of the database limits. the code below takes somethimes 0,61seconds and sometimes up to few seconds(1-3) start=SECONDS() OPEN DATABASE data mySQLhandle=SQLCONNECT("connection") end=SECONDS() WAIT WINDOW end-start the code below takes 1325.436seconds to complete (10 000 records) start=SECONDS() FOR i=1 TO 10000 SQLEXEC(mySQLhandle,"INS ...Show All

• Visual Studio How to access symbols in static lib?

  Hi, I have a C++ app that links in a C++ static lib. I've compiled the static lib using compatibility mode (/Z7) which is supposed to put the symbol table in the .obj files. However, when I'm debugging the main app, I can not display any of the variables within the library code, although I can set breakpoints and single-step through the library code. The main app is compiled using /ZI, which produces a pdb for the main app. I've tried recompiling the main app with /Z7 as well, but it didn't seem to change the behaviour. When I try to get the value of a variable in the library code (e.g. using Quick Watch) Visual Studio complains that there's no symbol information available. How does one debug a static lib regards, Rob ...Show All

• Visual C++ trying to get a .lib from dll proj

  I am currently building a .dll just happy and fine, but I need to link another application against the symbols in that .dll -- I assume I need a .lib output as well with the dll. Is that correct or is there something I am missing Christian Basically, you need two things: 1. A header file used by both the dll build and the client of the dll. (See a DLL project generated from VS, and you will see how this header differentiates between the two context). 2. As you said, the .lib file. This is added to the Linker Input settings. Or (as I sometimes prefer) #pragma comment(linker,"mylib.lib") in your source file. You need to make sure your build can find the lib file (set /libpath using a macro ...Show All

• Software Development for Windows Vista Auto Logoin in Vista ?

  Does anyone know how to config auto logo in for Vista Because we need to run stress test and sometimes it will restart or suspend computer. But after restart or resume, Vista still needs user to select account and input passwords. We want to skip these steps.  We already tried many ways but always failed. 1. control userpasswords2 ==> not work 2. add regsitry ...DefaultPassword                              DefaultUserName                    &nb ...Show All

• Visual Studio Express Editions How to connect A Database of SQL Server Management Studio Express as Data Source in VB Express

  Hi all, I just created a database called "ChemDatabase" with 2 Tables in SQL Server Management Studio Express and launched an application called "RPDofTCE" in my Visual Basic Express program. I do not know how to connect to the ChemDatabase in the RPDofTCE application. But I saw the following things: Data Source Configuration Wizard => Add Connection => "Advanced..." button => Advanced Properties: Application Name .NET SqlClient Data Provider Data Source .\SQLEXPRESS User Instance True I think I need to have the above-mentioned Advanced Properties set correctly in my RPDofTCE-ChemDatabase connection. Please help and give me some detailed instructions/procedures regarding how to mak ...Show All

• .NET Development Using multiple SqlConnection objects, bad for performance?

  Hello, I am planning to use three databases on the local SQL Server. DB1 will be for App1, DB2 for App2, and DB3 will hold tables, that both, App1 and App2 need to access. With applications I mean ASP.NET applications. Obviously, I need in App1 and App2 at least two SqlConnection and SqlCommand objects, one that access their respective databases, and one that will access DB3. Will this result in a worse performance (The using of two SqlConnection objects in one aspx page as example, and switching them) Should I for better performance get rid of DB3 and add the tables there to DB1 and DB2 (Thus multiplying data, but, if the performance will be much better, it will be fine with me) I would be thankful for any advices. ...Show All

• SQL Server Please give me your suggestions on Report Query - Very Urgent

  I need to disaplay number of Active Agencies on monthwise in one of my report. I have tbl_Agency table with ActiveDate and ActiveFlag. ActiveDate column contains always first Activation Date. If any chances in the agencies(update/delete) the same record will move to tbl_AgencyHistory table. "If an agency is inactivated in September 10th, inactivated all of October, and then reactivated November 10th - the agency would be counted in September, not in October and counted in November" ActiveDate column has always first activation date, I could not meet this requirement. This is very urgent issue, Could you please help me on this. Thanks, Malar Malar: Please fo ...Show All

• SharePoint Products and Technologies Outlook/MOSS integration - missing the obvious?

  Hi - we are looking to synchronize a MOSS calendar list with the default Calendar in Outlook 2007. SharePoint insists on creating a new Calendar for every list I synchronise but does anyone know a way to change the destination Calendar so that the event items in the SharePoint Calendar list are actually synched with my default Calendar. This must be a common business request for organisations looking to use the Outlook/Sharepoint integration features in 2007. For example I've given someone access to my Calendar to see what I'm up to but if the SharePoint Calendar items are syched to the separate Calendar that MOSS created, this other user can't see all the additional appointments set for me in the SharePoint Calendar list. I could provi ...Show All

• Visual Studio Express Editions how to protect code, maybe in a dll as i thinks its not so easy to gen public to open

  hell i am writing and app, and one part i would like to protect the content , is there a way, i understand you lot could access it, but to the general computer user maybe not so transparent. I though maybe make a dll and put code in that , but i am not sure of a procedure. if i am on the correct track to do it in a dll and pass some parameters to the black box, then a yes or no is fine and i will try to figure it out. many thanks ian Obfuscate your code . ...Show All

• Windows Forms Saving from RichTextBox in .rtf or .txt??

  Hello, I am trying to save file to either .rtf or .txt from my RTB. When I save to .rtf it works fine, but when I try to save to .txt it saves the file but it doesn't put the '.txt' extension to the end of the fileName. So when I try to open the file again it doesn't appear as a .txt file, but it works if I manually add the '.txt' file ext. into the filename at savetime. Here's my code: Dim textType As RichTextBoxStreamType If (SaveFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK) Then If (SaveFileDialog1.FilterIndex = 1) Then textType = RichTextBoxStreamType.RichText Else textType = RichTextBoxStreamType.PlainText End If End If Dim fs As New FileStream(SaveFileDialog1.Fil ...Show All

• Visual Studio Express Editions Error when uninstalling MS VC++ 2005 Express

  Hi, there! I'm trying to uninstall MS VC++2005 Express, in order to install other version of the product in a very near future, but after the initial dialogs, it shows a Messagebox like this: Title: Visual C++ 2005 Express Edition Setup Icon: Exclamation Message: Setup is unable to determine a valid ordering for the instalation. See the error log for further details . Does anybody know what happens and how to solve it Point me where's the log referred on message could help too... BTW, the VC is not registered. I don't think it should make difference on this, but who knows... Other question: It's possible to install two different versions of VC++ 2005 on the same machine Such as Express and Professional TIA, Will ...Show All

• Visual C++ Any documentation on OleDbConnection in VC++.NET 2005

  Hi everyone, I am just starting to use VC++ for the first time. I am a well seasoned VB.net developer, and I have grown fond of the OleDb classes used for reading and witing to MS Access Databases. In discovering VC++, I am having difficulties finding some documentation for OleDb classes under the .NET 2.0 Framework for Visual C++ (I have found plenty for .NET 1.1 which I can't manage to get working in VS 2005, and .NET 2.0 documentation doesn't have VC++ source. Since I am a virgin to VC++ syntax, I am having a heck of a time making something work) Ex: http://msdn2.microsoft.com/en-us/library/system.data.oledb.oledbconnection.aspx If anyone could provide some reference material or even source, I'd really appreciate it! ...Show All

• Visual Basic modal dialog active...

  Any news on the "Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again." I have had this happen several times and its a pain in the butt! This is been opened twice ... many people here have provided examples in this post and on the ticket - I dont know why it cant be recreated at microsoft if so many others can. This was from a previous post I followed the link to http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=105195 and I saw that Microsoft has marked this bug "Closed". Unless there is a service pack or a hotfix that I don't know about, the problem is not yet solved, and the bug shoul ...Show All

• Smart Device Development Connecting multiple PDA to a desktop pc

  Hi Can i connect multiple PDA's to my desktop PC , so that the PDA app can cosume the webservice, Currently i am connecting single PDA to the PC using the bluetooth USB adapter Regards Gauls Can we connect the PDA's to the PC without ActiveSync using the bluetooth USB adapter, I read the spec for the device and it says we can connect upto 8 devices. I have a belkin Bluetooth adapter. I can pair my pda's with the PC. Do I need a different kind of adapter please help me with more specific details Thanks ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Components w/ different timings?

  I like the model of specifying Game.TargetElapsedTime and responding to update events, but can I conrtol this on multiple components For example, let's say that I want to randomize the weather conditions in my game. I'd like this to update every minute or so. On the other hand, some things need to update every frame (ike controller input or sprites positions). One way to handle this would be to simply have methods like UpdateWeather() , and UpdateSprites() and so on, and have multiple if/then blocks in my main Update() code that determine whether it's time to call one of the other update methods. However, it'd be nice to offload this monitoring somehow so I could just declare in my init code how often certain components get updated. A ...Show All