Answer Questions

• Buggs Bunny Memo File Corruption on VFP9 ONLY

  I am just beginning work for a new client.  This client wanted a VFP5 app upgraded to VFP9..they're using Novell (lastest version).  After the conversion (very little changes needed to be made), they started getting file and memo corruption errors as well as indexing errors.  I took a copy of the data and tried a recopy using SCATTER MEMO MEMVAR to a new fresh data file (using GATHER MEMO MEMVAR) in VFP90.  I got the same er ...Show All

• cht Problem with SUM() function?

  I have a table with colums for debit and credit, each column has 2 decimals. I enter in the command window: sum(debit) to x and sum(credit) to y, then x=y. Result: they are not equal. I ask output: x and y, they are equal. Then I type: SET DECIMALS TO 10 and do the same things. Now the output shows me that x is not the same as y. There are differences in the 5th decimal position of x and y. How is this possible My table has only 2 decimals! I ...Show All

• Stefaan Smekens How to play a Windows Media Audio format (WMA) in VFP?

  Hi all, I am now trying to create a small program to play media audio files. I'm now using the MultiMedia ActiveX control (mci.ocx) to play these files but this ocx seems can not play WMA files while this type of file is getting more and more popular to music-lovers. Could anyone tell me how to play WMA files in VFP. Note:I want to play them directly in VFP with MCI control or with some API function that VFP can handle,  ...Show All

• Dave Abrahams can't reindex 82,000 kb file

  Let me begin by thanking you for the help.  I am not a avid foxpro programmer.  I have a table in my database that has been acting up the past few weeks, but usually a reindex would fix the problem.  Today It won't let me reindex.  I type reindex and press enter and instead of getting the counter on the bottom right hand corner.  It does absolutely nothing.  If I delete the .cdx file and try -- still nothing.  ...Show All

• Moritz Kroll frmpanemanager.setpane

  I get this error message from an OLE when I try to open a form with run command in interactive mode. The debugger says that the source code is unavailable. The call stack is as follows: frmpanemanager.setpane frmpanemanager.init ClassLib: forxpaneengine.fxp The file path leads to a directory in C:\\documents and settings\\..... That's it. I have never seen this object before. What can I do about it Thanks. It is actually very ...Show All

• mullykid Date problem in VFP 6.0

  Hello! Huh, I currently have field named 'fine' in my DB. It's used to store fines. There two other fields, 'rent-date' and 'no_of_days'. The first one stores the date on which the rent of a book starts and the second one stores the number of days the book is going to stay with the borrower. Well, I would like to know how can I calculate the fine. To calculate it, I must find by how many days the due date has been "excessed" and ...Show All

• SQLIsFun How to solve memory problems on foxpro

  I use a Foxpro based system on my job, but the problem is that frecuently appears a message "the instruccion at "0x100017bf" referenced memorya at "....." The memory could not be read. And the system crashes down and this is really annoying because I can't work, does anybody knows hoy to avoid or explain me why is this problem ocurring as I enter more information on my system When you post your specs make sur ...Show All

• alfredkoo VFP9 printing issue with multiple detail bands and group subtotals and/or summary totals

  I have a report with one group and a summary total. Adding a new detail band, a big new feature added by VFP9, lead to incorrect totals/subtotals. I am using VFP9 SP1, behavior80, but is the same with behavior90. Steps to duplicate: 1) Run this code create table PRINCIPALE ;   (AGENTE     C(2), ;    N_DOCUMENT C(5), ;    D_DOCUMENT D, ;    TOTALE     N(5), ; & ...Show All

• VictorSt 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

• Dirk Bosgraf Open table exclusively?

  Forgive my ignorance - I've recently reinstalled XP and subsequently Foxpro 7.0. Now when i double click on a foxpro dbf file it opens the table and another datasession labeled 'B' (i'm supposing it's a datasession). Previously, when i opened a table i was in exclusive mode and didn't have this duplicate table open also. I normally work in exclusive mode because my data is not in a shared environment (i'm a vb developer). Any suggestions thanks ...Show All

• paulwise3 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 do that before.  The applic. will automatically backups all critical datas. But the PC will gone crazy if at the the time of back-ups there was an incoming entry of the user. (most common occurence is that it HANGS-UP)    ...Show All

• Tom Perkin how to send control codes via "???" to receipt printer

  Hi All, I am writing a POS system and using a receipt printer (Epson TM-U220D). Unfortunately the printer drivers from Epson didn't work & hence I resorted to using the Windows Generic/Text printer. I am using a series of to output to the printer, which works fine. My problem is that I need to do some form of simple formatting on the receipt, e.g. make company name bold, etc. My question is, how do I send the control codes to achieve t ...Show All

• Jennifer N RANDOM SEQUENCE

  I need to generate a list of all integer numbers from 1 to 100,000 inclusive but in a random order. I understand the random command can be used to generate "random" values but if I generate 100,000 random integer values, this is unlikely to be one instance of every integer value from the range I want. I could generate a value, check that it has not already been generated and store it or discard it before generating the next value ...Show All

• Rido Image in a Grid

  Hello, I would like to show 3 different images in a gird. My data source is a table, the data type is character "E" for an error image, "O" for an OK image,"N" for a new image The picture property in the image control is "path\" + table.status +".bmp" It works, but all images are the same, like the first record number. (eg. N) Can somebody help me` Thank, ...Show All

• mjones20 data from one table1 that isn't in table2

  Yallo, I know there is an easy fix, but I have spent to much time on it and can't figure it out. I have two tables that share some id numbers. I want to pull all the data from one table where the id isn't in the other table. Table1 id name 1 steve 2 clarith 3 dorthy 4 pudbo Table 2 id name 8 clem 2 clarith 6 fursmorth 4 pudbo two tables: they share records with ID 2 and 4. I need to pu ...Show All