Answer Questions

• salama2 Clearing a cursor

  I am working with a cursor that I use to import XML information to. When I am done with the XML information, I want to clear the cursor for other input from the same area; however, I am unsure as how to go about this. Any ideas Andy, Thanks for the extension. Are cursors R/W by default Cursors are not readwrite by default if: -It's a result of "select-sql" -'readwrite' clause is not included Howe ...Show All

• akverma MSGraph.Chart.8 control

  I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in ve ...Show All

• Fixxer BUILD PROBLEM

  Hi all,Im a new programmer in VFOX PRO 9 and im currently having a rather noobish problem. I want to make my application as a .exe file so i can distribute it to someone that doesnt has the vfp installed.i have included the dll files that are specified in help and have put the application as a top level in the application builder.i have disabled quick start and have selected a form as main so that program starts with that one.the problem is that ...Show All

• Duncan F Coming from Excel to VFP9 and need help understanding math functions on cells

  I have set up a simple data tracking form that breaks out the associated costs of a vehicle going to Auction ( dealer costs, transportation fees and so on) for my employer. It works great, and I can enter data into the database successfully, and my Report will print it out nicely sorted by Store. I would now like to create cells on my data entry form that calculate and display various math procedures on the data being entered. For instance, ...Show All

• RossL VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• ac2600 VFP8 Report Incrementing variable

  I need to create a variable that shows the current page number within a data group. it will need to reset to 1 with the rest of the data group. I tried doing this with the _PAGENO system variable, but this number is used somewhere else on the report for a 'Cumulative Page Count' and will also get reset. How can I accomplish this Thanks -Frank This is ugly but works: -For groups set "reset page number to 1 for e ...Show All

• DFMartinJr migrating VFP app to .net (architecture question)

  Hello everyone! I'm a fairly experieced database developer (SQL Server primarily, and Oracle quite a bit less). My experience with .net is primarily vb.net to built asp.net applications, using web services as my middle man. I just started at a new company which has a few legacy systems, one of which is a rather large FoxPro application. There are a host of problems associated with it, primarily data conflicts. Because the company has grown so mu ...Show All

• primevest Bug in VFP 9? Adding an object to an array with AddObject.

  We have this base class that basically implements a collection (I know there are collections in VFP, but we can't change this overnight). Part of the process is to add an object to an array. This code word flawlessly on VFP6 for years. this.ItemCount = this.ItemCount + 1 Dimension this.Item[this.ItemCount] Local cItemPlace cItemPlace = "Item[" + LTrim(Str(this.ItemCount)) + "]" this.AddObject(cItemPlace, this.ItemClassName, &tInitParame ...Show All

• iamhtran Checking for Additions to a .dbf File

  All, I am wanting to build an interface of sorts for a phone messaging application.  The app writes call entries to a .dbf file that I would like to monitor for additions. Once an addition is made to the table, I would like to insert a new record in to a SQL table and change a status field in .dbf table record to establish that that the new record in SQL was written. My original thought was to use a Linked Server via SQL to the .dbf file. ...Show All

• murfscot DISKSPACE() trouble

  I have an ActivX OleControl Microsoft treeView V6.0 and as a part of Init() procedure I use DISKSPACE() function just to determine which disk drives (physical as well as mapped network drives) are currently available. If the drive A: does not have a disk in it I get repeated error messages: " Drive is empty, please insert...." It does not do anything like this with DVD/CD R/W drives. They are empty and it is OK. Likewise, if I simply click o ...Show All

• Logicboy directory list

  i would like to show in a listbox the files of a directory(not all files for example reports only *.frx)and to be able to refresh that.in other programms there are file list boxes components that do this,but i dont seem to find any in vfp.what can i do There's more than one way but the easiest to start would be to change two properties of your List Control: RowSource=".frx" RowSourceType=7   && f ...Show All

• mister_ray Primary key + delete....

  General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if h ...Show All

• Cytosoul Copying a file to EXCEL from FoxPro.

  PLEASE HELP! I'm using Visual FoxPro 6.0 and EXCEL 2003.  I created a query with FoxPro 6.0 and copied the data to EXCEL 2003.  The Table size is 33827 records and it only copied 16384 records.  It only copied half the code.  Why is this Here is the code. close data all set talk on set dele on SELECT 0 USE "c:\documents and settings\bartech\my documents\fmpdata\software code\fmp reports\fmptables\line02.dbf" shared se ...Show All

• r-coool newbie here...

  hi to all... i have a form named customers and i have txtboxes to input all information i needed. i have a grid that shows all the records in the table customer. works fine on loading. now, i have 2 buttons previous and next respectively. my codes are as follows: Previous Button: USE customer if not BOF() skip -1 thisform.refresh() if BOF() go top endif endif Next Button: USE customer if not EOF() skip thisform.refr ...Show All

• duke_ 2 more questions (VFP8)

  (1) I've made and deployed a simple app. with its own helpfile, but when deployed, nothing happens when I press F1. (It is not, that the app cannot locate the helpfile. If I rename it, I get an error when starting the program.). Any suggestions (2) The other problem is, that about one in every 4 times I close the program, the process keeps hanging and thus locking my datafiles. (When I kill the process, the datafiles are corrupted, when I start ...Show All