Answer Questions

• Steve Allen report export to excel differs from print preview and print

  When using Visual Foxpro 8, I notice that my subtotals based on 2 report variables that calculate sums per group in the 4th data grouping are continuing to accumulate instead of resetting after each group when I export to excel but appear fine when I do a print or print preview.  I tried deleting and re-adding the grouping only to get the same result.  Strangely, I also notice some of my text labels have also shifted over to the r ...Show All

• Trenomarcus shall I purchase Visual Fox Pro 9 ?

  Hi there. I have considerable background in Visual dBase Plus which is an OO language with considerable means to create forms, tables and some windows applications but it is hard to do any networking. Thus I am trying to migrate to C#. I do have a Visual Studio .NET 2003 Pro and downloaded Visual C# 2005 Express Edition Beta 2. I have created some forms and added some functionality. Now I need to create tables and I need a table designer which I ...Show All

• gmcnickle small test on transaction atomicity

  Need help with small test on table in database with transaction. Could somebody show state of table after execution this code: CLOSE ALL CLOSE DATABASES OPEN DATABASE "c:\ path to database\data1.dbc" SHARED BEGIN TRANSACTION UPDATE data1! table 1 SET name = 'BBBB BBBB BBBB BBBB BBBB' = Messagebox ('END TRANSACTION') END TRANSACTION if in table1 before execution was 500K records with value "AAAA&q ...Show All

• manville Select Statement

  Basically i want to create a view that calculate the stock end balance using moving average. On entry invoice the prg would create txn on a table item_txns that store all txns that affects the balance. The problem is the sale txns only store the qty but does not store the cost of good sold. This would be calculated on the fly when users query and want to see the cost of good sold . I want to do this using SELECT statement, The fields ar ...Show All

• bigbluesky View, Query or Cursor?

  I have a form that pulls info from an ODBC source via a Remote View. When I try to RUN my form, my entire project locks up. Is this because the info pulling from ODBC is too large How can I fix this Any ideas Should I use a cursor instead of a remote view Or unselect fields in the Update fields selection Hi SweetCoder, You haven't said anything about the SQL for your view, or the number of records you ...Show All

• The Fat Dad Select Statement

  Basically i want to create a view that calculate the stock end balance using moving average. On entry invoice the prg would create txn on a table item_txns that store all txns that affects the balance. The problem is the sale txns only store the qty but does not store the cost of good sold. This would be calculated on the fly when users query and want to see the cost of good sold . I want to do this using SELECT statement, The fields ar ...Show All

• JohnHappy Downloading and uploading file from URL

  Hi. First task : How to download a file from internert via FoxPro Second task : How to upload a file in Foxpro via ftp Thanks That is completely different than what you originally asked for. Why didn't you explain that in the question You are asking for a non standard procedure that is not a normal windows behavior. You will need to write something custom. I have no idea how you would go about it ...Show All

• Peter Larsson cumulative column calculation

  Hello, have question about calculations in visual FoxPro. Have a table ID Sk 1 4 2 8 3 9 4 3 and so on… need to calculate cumulative sum in next column like ID Sk Cum 1 4 4 2 8 12 3 9 21 4 3 24 Do you know how to calculate this column It's work, thank you. The easie ...Show All

• ArtRI Input mask for a spinner

  I've defined an input mask for a spinner as $$99999.99 It displays the value $ 855.09 as $ 955.9 What am I doing wrong Thanks. >> ... but I could not find any way to ADD a method at runtime. That was my issue. Perhaps you know how it can be done The short answer is that it can't be done directly. There are two possible solutions to this requirement depending on the nature of the code required: The first ...Show All

• wolfor use file index file, sets no order

  Hi all; I am running the following command from the command box: use files1 index file1 seek "ABC" I get an error: Table has no index order set. When I do the same for other files, like use file2 index file2 seek "ABC" I get no error. Both files have a number of tags in a CDX, but also a single IDX file. What could be the reason for this kind of behavior Thanks. ...Show All

• deyanp Need VFP 9.0 Report Help

  Hi I have a report that in the detail band I have the following info: QTY     Part Number      Description              Price           Extended Price   5       2222-009          5500 Watt 220V &nbs ...Show All

• Rivorus VFP9.0 Data Access from .NET

  Hi all I am trying to acces VFP 9.0 Data from a asp.net web site and here is the problem In the visual web developer express when I hit "View in browser" The web page comes up correctly then I copy it to \\localhost\vfptest and open it in the browser and get an error indicating that vfpoledb cannot find/open the specified file. So then I go back to VWD and set the project to the IIS directory directly and hit "view in browse ...Show All

• Rogerio Lima foxpro2.5 application migration from windows98 to XP (Urgent)

  Hi All, I have to migrate the existing data which is on windows98 to windows XP. My application is working fine on 98, but when I copied the files (almost all) into xp The application throws error “not a table/DBF”. When I open the same DBF file in notepad (one in 98 and other in xp) the xp file has some random characters and numbers in it where as the 98 dbf file I can read my column name. What could be reason Why the DBF file go ...Show All

• Emilian Need solution for complex query

  Hello, I am having trouble in getting the expected results. I have two tables as below. I need Idno,transdt,cd,cycdt,amt from joining two tables. The criteria is that if the transdt greater than same month of cycdt then we need get the next month cycdt and corresponding amount for that, if it is less than or equal to same months cycdt then get the same months cycdt and amt. Cd is dummy field which can be anything. I am using foxpro 6.0 id ...Show All

• slippyC which is safer to use table or view?

  Opening a native table is very vulnirable to sudden power failure. So which is safer of the two; Using directly the table or make a view of that certain table before using it I feel for you, I have a similar problem but on a larger scale.  I design racing software that is used on about 5000 customer computers at racetracks all around the world.  They run on generators which are always shutting down. Since I cannot control t ...Show All