Answer Questions

• Dtag REPORT error-invalid path

  i have a button in a form and when its pressed it creates some select sqls which have into table and overwrite an existing table.then from the table i create report..from.. ,then i update the report and finnally i report form.the problem is that if i press the button->see the report->close the report->press again button->i get a message "invalid path or file name" if i close the program and reopen its the same press the button->se ...Show All

• microzt SELECT - SQL COMMAND again

  In a situation like this where the first field is of type " C " and the second -- " M " SELECT RTRIM (field1), LEFT (field2,20)... INTO ARRAY arr1 The first function < RTRIM > appears to be ignored (the result has trailing blanks regardless) but the second < LEFT > seems to be doing fine. I am wondering if anybody has similar experience and how such needs should be handled. There is no purpose usi ...Show All

• Mikhail Podolski error with SET <classLib>

  It is a simple situation. I am playing with some code I downloaded (wwHTTPdemo). Credit goes to Randy Pearson , CYCLA Corporation, I think and West-Wind Technologies' Rick Strahl. I often get an error stating that an " ALIAS name is already in use ." This is a snippet: TYPE ("wwIPStuff") == "U" SET CLASSLIB TO wwIPStuff ADDIT ENDIF IF TYPE ("wwHTTP") == "U" SET PROCEDURE TO wwHTTP ADD ...Show All

• Kanga LeRoo Importing Text File to a Table

  hi everyone, i hope somebody can help me figure out how to import a text file such as this one below and save it in a table. the 999.999.999.99 should be placed in the first column and the date should be on the second, the third which is the time should be placed in the third column, the GET should be placed in the fourth. 999.999.999.99 - - [01/Jan/2006:11:43:36 -0600] "GET /Images/Product/Sign_in.gif HTTP/1.1 ...Show All

• TimothyJ Enhancement Request: Ability to pass cursors as parameters

  The ability to pass a cursor to a method of an object belonging to another data session would be a great addition for a future versions of VFP. Today, we have to resort to arrays, which is kind of a kludge, or CursorToXML/XMLToCursor, which is way too slow for large data sets. If cursor could be passed between data sessions, n-tier apps would benefit greatly. Any thoughts Eyvind. You could use ADO and pass yo ...Show All

• Sam_S how do i get a result in 4 tables in SELECT- SQL command?

  good day to the experts... My transaction has 4 tables, 1 for recording the amount of loan, 1 for check payment, & 1 for cash payment, and the vendor table. Below is the tables and its corresponding fields *// vendor table 1 (FIELDS=acct_no, acct_name,address, totalamount) * // loan table table 2 (FIELDS=or_number,acct_no, loanamount, or_date) *//cash payment table ltable 3 (FIELDS=child_numb, or_number,acct_no, amountpaid, ...Show All

• VH-BIL 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

• sharpblade SELECT statement is showing unwanted display of data and is not passing data to a table.

  I'm using a SELECT statement to pull out data from a table... that is working great. What I'm trying to do is feed the selected data to a different table using REPLACE so that it can be used by a report. All of this is triggered from a command button on a form. Here's the code for the CLICK property of the button: SELECT store, stock, year_1, make_1, model_1, auction1, transport, recon, sold_for, fees, net_check, result ; FROM wholes ...Show All

• danmga need foxpro help

  I'm getting a System Error "Divide by Zero or Overflow Error" when I try to run FoxProw.exe on Windows 2000 .  The program installs okay, but I can't get it running.  Thanks in advance for your help ... Try the IPatchFP.exe ( http://download.microsoft.com/download/fox26win/patch6/1/w9x/en-us/ipatchfp.exe ) instead. This works for international versions as well as reportedly FPW 2.5, 2.5b, and 2.6. Rick ...Show All

• Sushovan De qbf

  i am a beginner in fox pro i have three huge tables 2gb each containing 5million records each i need two join them in a database and to create a qbf  that will contain values from all three tables and that will search fast could someone please help me Hi It smells like an SQL query, but not clear your question... SELECT t1.name, sum(t1.pieces), t2.ext FROM t1 INNER JOIN t2 ON t1.code=t2.code Is this what you think of You ...Show All

• Markus85 How to get the UserID and password login to windows in Visual Foxpro?

  Could you show me the way (in Visual Foxpro) to get the UserID and password that i've logged into windows please Thanks. ChinhNguyen Dave M. wrote: GETENV("USERNAME") Will give you the username. I don’t think you can get the password, if Microsoft allowed that, it would pose a security risk. Dave M. I using VFP 7. There is no arguments for Username .... Thanks in advance. ...Show All

• eng2chi VFP free tables in compressed folders

  Will Visual FoxPro free tables work fine on compressed drives or in compressed folders I am talking about the NTFS compression found under advanced attributes. I have several folders with hundreds of .dbf files used in out VFP app. I would like to compress these folders to save disk space. Sorry you guys are correct, I just tried it. It works nicely. Have you ever tested the performance Dave Dave M. wrote: ...Show All

• Ranjith P How to get the folder name?

  Hi, I would like to ask for a help regarding how to get the name of a certain files or folder from the specified location on the local hard drives. Any commands and sample codes would be greatly appreciated. Thank you. Alfred N. Roa +639196027475 Alfred, Your question is unclear. If you know the specific location then what do you need more I think you're not asking getdir(), getfile(), adir(),fullpath(),justpath() etc. Would you el ...Show All

• Scraush refresh

  i am placing a value one field depending on what is entered in one field for example if a zip code is entered in the zip field then the corresponding city is entered in the city field.  i get the city to appear but only if i tab to the city field.  how can i get it to automatically be entered upon tabbing or clicking out of the zip field.  im just not sure where to put the code.  am learning visual foxpro after programming un ...Show All

• Ryan Cromwell Help! Save me from this error cursor not saved error message!!!

  Hi all; I have this grid who's control source is a cursor who is exclusive. Somewhere in the grid I use a replace command to change one of the fields in the cursor. When I move to the next row, and change a field I get an error stating that the current row is not saved and needs to be saved. I have tried everything including putting a FLUCH FORCE command after the replace command. I don't see why an exclusively opened table shoul ...Show All