Answer Questions

• Nadav Levintov foxpro 6.01 ODBC

  I'm programing in C++ using "Visual FoxPro Tables" ODBC driver, and querying a table with around 3,000,000 records. when i'm working with my code some query takes me about 50 seconds. Today I installed visual foxpro 9.0 to compare the time with my code and when i use the query wizard i get better resualt faster then in my code. I have two question 1. when I installed foxpro 9.0 the ODBC version stayed the same. doesn't foxpro 9 have an ODBC driver 9.0 too 2. how can i get the same resualt as the foxpro apllication gives (20 second for the same query) Prefer VFPOLEDB driver. ODBC driver is not compatible with latest version (not updated since MDAC 2.5 AFAIK). 20/50 secs is so ...Show All

• ChinaTiger Error loading

  Hi al; I have an application installed on site which is using vfp runtime. Often we get the following error: Error#2005, Error loading file - record number 29. frmCustService01 <or one of its members>. Loading form or the data environment : File is in use by another user. I have no clue how to try and figure out which file in use is causing the problem, or exactly where in the code the error is being generated. Record#29 - is this the record # in the scx file How can I figure out what exactly is causing this Any good ideas Thanks so much. >Error loading file - record number 29.  frmCustService01 Means you have to open frmCustService01 as a table: ...Show All

• xAvailx VFP7 COM+ error while calling from ASP.Net 2.0 on IIS6

  Hi, I have an ASP.Net 2.0 application which interop with VFP7 COM+ (using DCOM). It was running fine on IIS5, WIndows 2000. Recently I migrated the server to Win2003 and IIS6 is running on native mode, and I couldn't get the COM+ running, below is the information and hope someone here could help: 1. If the application pool identify set to 'Network Service', I can't even create the COM+ object in the ASP page even though I have granted the 'Network Service' account with neccessary NTFS folder permission. 2. If I change the identify to let say Local System or Administrator, I have no problem to create the COM+ object in ASP page, and VFP codes in the OLEPUBLIC class Init event has actually being processed as well (for example I put a Create ...Show All

• Sondre - MSFT Regional Director Help with rounding

  Help!  I have to round a number to the closest 500 but if last three digits are between 0 - 250 round down, 251 - 499 round up, 500 - 750 round down, 751 up, round up. Example: 2140 should round to 2000 2257 should round to 2500 2660 should round to 2500 2760 should round to 3000 Thanks in advance! Expanding on Giulio's idea, here's a function for you. I've only tested this with your data values, so be sure to test more extensively. FUNCTION RoundToNearest(nNum, nNearest) nRemainder = MOD(nNum, nNearest) IF nRemainder > nNearest/2 nResult = INT(nNum/nNearest) * nNearest + nNearest ELSE nResult = INT(nNum/nNearest) * nNearest ENDIF RET ...Show All

• HariAdu Foxpro and C#

  hi! i'm trying to create a program in foxpro (9.0) that can call a program in C#.. is that possible if it is can somebody give me an idea on it <i already posted this in the Visual C# forum.> thanks! What do you mean "call a program in C#" You can easily run the EXE as you would any other external program (.Net runtime obviously has to be installed). DECLARE INTEGER ShellExecute ;     IN SHELL32.DLL ;     INTEGER nWinHandle,;     STRING cOperation,;     STRING cFileName,;     STRING cParameters,;     STRING cDirectory,;     INTEGER nShowWindow ShellExecute( 0, "Open", "MyProgra ...Show All

• billqu Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help If you use std fan fold, you have to stick to the paper used on dot matrix printers, (with holes on both ends.) You also have to pay attantion to the page shape, portrait or landsc ...Show All

• DTUK Fixed Format File

  Does any one know how to output a Fixed Format File Currently i'm outputing a file as comma delimitated, and it needs to be changed to a fixed format file "Fixed Format" is not a type I have heard of before but I would guess it may be type "SDF". Look under help and the COPY TO command. Dennis Just to add on to what Dennis said - I think you're talking about fixed width, right It's called "standard data format"  copy to "FileName.txt" sdf ...Show All

• werwin Shed any new light on VFPOLEDB directions?

  Any info available on VFPOLEDB new versions or updates coming down the pipe I'm not holding my breath, but let me know if there is any info available...... Thanks Dan Ribar If there was anything that could be shared publicly it would be posted here: http://msdn2.microsoft.com/en-us/vfoxpro/bb264582.aspx Milind Lele, the VFP Program Manager, publishes a monthly letter with news.. ...Show All

• jazo ichikawa Visual FOXPRO ODBC Drivers for windows Vista

  Hi. Does any one knows where i can get the Visual FoxPro ODBC Drivers for Windows Vista Thanks. Helder Santos Is there any reason to choose ODBC over OLEDB or vice versa App is in VB.Net and uses both MDB and DBF. I don't think that the current download/install of VFPODBC (VFPODBC.MSI) hasn't ever worked on Vista, and I notice it's still broke in RC2. Is VFPODBC going to be supported in Vista Still broke It was working and still working under RC2. However I suggest VFPOLEDB instead. We have a bunch of code that doesn't work under VFPOLEDB, but works just fine under VFPODBC so we can ...Show All

• MitchPetel Using database in network

  I've build a database program with Visual Foxpro, and use Visual Foxpro database/table. Example : Select 1 use c:\data\table1 But sometimes my database/table located at server drive (my network place). So I typed, for example : Select 1 use \\server\data\table1 It doesn't work properly, because Visual Foxpro cannot recognize the network drive. How to solve this problem ....thank's....... The syntax you used should work. What exactly does VFP say when you issue the USE command You may try to map network drive(ex. X): SELECT 1 use X: \data\table1 Nothing wrong with the syntax. Simple and maybe obvious questions: Is there a share in the server folder Does the program (or you) have enou ...Show All

• jsedlak vfpencryption.fll

  hi all, i came across a library file to encrypt and decrypt from tis website.http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,23a74c5d-5173-420e-af23-22494d95a54c.aspx after i download the fll files i try encrypt but vfp prompt me invalid library file. set library to c:\windows\desktop\vfpencryption.fll. where is my error Thanks in advance. Alex is right. You are missing the proper runtime libraries for this. Go to the following page... http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,91241006-595a-487d-ac06-d0fc1fc71632.aspx ...and look for the section entitled " Important note about the required C++ runtime libraries " where you will find some of the information you nee ...Show All

• fatmanis Excel to cursor SPT problems

  I am using a SPT solution to take information from a .xls file and importing it to a cursor with this solution: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 However, I am now receiving problems where before I had not. Now I am getting Error 1466: Connection handle is invalid. Any ideas guys I can't see what the problem is but it occurs at the sqlstringconnect( ) line. Thanks! I'll just reply to this one for both of them: I see, well the .xls file is user generated with the sheet names unchanged; they will not be created in VFP. What happens is that a user uses getFile() to select a .xls file, and then they click 'import.' I understad the fact that with generating a .xls file with VFP you aren't guaran ...Show All

• Danilo80 Convert ADO recordset to a Foxpro DBF free table

  Hi,     I currently have a need to convert an ADO recordset to a DBF. I've seen some posts here on how to create and write to a DBF using C# in conjunction with the VFPOLEDB provider. I mocked some code up in VB6 similar to the example and I am able to open the dbf in VFP6 no problem. However, I'd like to find out what ADO to Foxpro field type conversions would work. The ADO recordset comes as a result of a query from SQL Server 2000, so there are bound to be some datatypes that will not convert natively. I've come up with this matrix so far based on some MSDN Library materials.     SQL DataType              ADO DataType   &nb ...Show All

• Zulbaric converting xml to foxpro table

  Hi, I own an insurance and investment company and just play around with some foxpro applications for my business. I have developed several helpful database programs for such things as tracking insurance quote requests that come in, etc. in VFP ver 5.0. I just purchased VFP 9.0. I am pretty much clueless as to what xml does or how it works (i don't even know what it stands for); however, I am now in need of being able to suck data that is currently in xml format into a vfp database and vice versa. I tried playing around with the smltocursor and related commands, but they are way over my head. Is there a simple program code someone has that will just convert this for me Or is there one of you folks out there that I could hire for a small ...Show All

• Andrew Beery COntroling objects

  I have 2 forms, Form1 and Form2. In Form1 I have a grid and a button, when I click the button I call Form2. What I want to do is to control the properties and methods of the grid inside Form1 from Form2. How can I do this Thanks to all of you. Yes, but: What I have learned here recently is that changing recordsource for a grid either at design time or at run time causes problems. I have had cases where my entire formatting/design/controlsource for the grid got lost because I changed the record source. A form receives parameters in its INIT() method. Create a property of the form to keep the parameter received, therefo ...Show All