Answer Questions

• David Sadler The publisher could not be verified. Are you sure you want to run this software?

  Everytime I start one of our customized apps. (written in Visual foxpro 5.0 and compiled as an .exe). I get the Open file - Security Warning. Thanks that did it I added my network path ( \\server\share ) to my trusted sites and set my security for intranet sites to low. Sounds like you started IE-7 with its curiosities; if so, google "IE-7 EXE Errors" for internet options" about your necessary MANUAL security settings (etc.) (under IE-7) (I reverted back to IE-6 on most of my computers and await the SP-1 due to this and other problems I've encountered with IE-7) IE7 and running from a UNC path http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=972945&SiteID=1&mode=1 ...Show All

• Edijs Search Company function: Type any letters to find a few similar company names

  Hi all   I create the form to search the company name. I have the long list of company codes & names inside the table (company.dbf).   Form Designer Company Name : <Text1>   <Grid>   Code    |    Company Name     Search Command    Exit Command        For example, let say the company name is Visual Foxpro Ltd. Just type any letters such as ‘Fox’ on <Text1 > and then click on Search Command to get a few company names and u will see the result as below..   Company Name : “Fox”   <Grid>   Code    |    Company Name   FASP &n ...Show All

• USJOHN Microsoft Visual Foxpro 6.0 - Help menu

  Hi From the Help menu, the following help features such as MS V F Help Topics F1, Contents, Index, Search, Technical Supportare disabled. It is quite troublesome for me to use another software - MSDN Library Visual Studio 6.0a when I need help. Is there any solution to enable these features Do I have to install full version in order to get the Help features Thanks in Tools\Options, "File Locations" page, what do you see as "Help File" Double-clicking "Help File" item, is "Use Help File" checkbox checked Bye, Giulio Pretty solved.. Thank u all. VFP 6.0 came in the Visual Studio 6.0 set of disks. After installing VFP 6, you must install MSDN help (which ...Show All

• Sarath. Looking for some good software to document a project.

  Hi, I want to document a project written in VFP 6.0 I would be interested in a software which lists all programs/functions called for every menu option avaiable on the main menu. Also I want to list all dbfs used and all memory variables created for each program file. Thanks in advance. Regards, Dinesh jain_dinesh@hotmail.com Hi Andy, Sorry please ignore my previous reply. The correct details of what I am after is as follows:- I have executed the FoxPro built in VFP dcumentation wizard. But it is not offering the details that I am after. What I want is a simple heirarchical listing of programs used for every menu option defined under the Main Menu. for eg:- for <Menu Option 1 selected> - Calls ...Show All

• airwalker2000 Create menu or command

  Hi there, How to create a command button or menu to acess 3 different form. Pls advice. Thanks. I did that but I got this error message when I run the form. Program Error File ‘C:\program files\microsoft visual studio\vfp98\exord001.scx’ does not exist Pls advice. Thanks In the Click() method of the button: DO Form xyz or place the same code in the command section of the meny entry. For all the options of DO Form see: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/a727f12a-4d9f-45ca-aa01-c1bea7de9749.asp Create a project (you'd do anyways to create an exe) and add your ...Show All

• ukalyan VFP9 ReportListner and Excel

  Hi All, Has anyone managed to turn the xml output generated by vfp9's reportlistner into a cursor I would like to then turn the cursor into an excel worksheet adding all the formating and formulae for subtotals etc etc But xmtocursor() generates "XML parse error:field name is invalid or duplicate...." Help please Mathias I have not used xmltocursor, but if I wanted to turn a cursor into an excel spreadsheet I would use: EXPORT TO filename TYPE xls Then you can open it with Excel. Your suggestion SuperFox is what would be the final piece to the jigsaw. The idea is use the reporting capabilities in the reportlistner first. The output is user driven and so t ...Show All

• Duncan Woods Data not up to date in newly created private data sessions.

  We are witnessing data not refreshing across users and data sessions until program shutdown/restart. One user adds records, then runs reports; another user then runs the same report and does not get the latest data the first user added - even minutes or hours after the addition. This is a large system (163,000 lines of .prg code, plus 68,000 more in class and screen methods), originally written in FoxPro 2.5 and 2.6, ported to VFP 8.0 with minimal code changes, except the reporting. The vast majority of the system is still @ ... SAY ... GET / READ MODAL..., etc. Also, about 100 of the most commonly used tables are opened at startup and remain open until shutdown. The reports, however are called from VFP forms, each instantiated from a (si ...Show All

• Rraj Replace character in a field

  I need to perform an update on a table, replacing a charcter (+) with another one (x) In SQL Server I Write Update <Table> Set Field = Replace(Field, '+'. 'x') With a dbf table it doesn't wotk and I couldn't find out how to do this. To be more specific, my table has a field (named flags), and it can be filled like this: i + xx i++ x+ +++ i+ I have to replace all '+' with 'x' to heve this result: i x xx ixx xx xxx ix Can anyone help me, please Easy to do in XBASE on a DBF:  REPLACE [ALL] field WITH STRTRAN(field, "+", "x") [FOR {condition}] * note that ALL and FOR clauses are optional   If you prefer SQL syntax UPDATE field ; SET field=STRTRAN(field, "+", "x") ; WHERE {conditio ...Show All

• Nitwit Combining mutltiple PDFs into one

  HI, First time posting a question. I have been asked to do the following. Take mutliple already existing PDFs and combine them (not worried about the order right now) into one PDF using vfp6. Is there a way of doing this or if you could tell me where to look for information on how to go about doing this would appreciated Thanks Pbriggs1 If your pdfs are generated with REPORT FORM command you may use the option NOPAGEEJECT to print all reports in one pdf file, but I used only with vfp 8 and preview is not possible.(Preview is possible in version 9) http://msdn2.microsoft.com/en-us/library/ms965464.aspx You may use to combine pdfs: http://www.download3k.com/Business-Finance/Office-Suites/Downlo ...Show All

• BBPowers Executing FoxPro Command

  hi guys! well by the way my database connection is a ADODB connection. now i would like to execute a FoxPro command like: use myTable append from myTable i dont know how to execute this in VB6. can someone tell me how it works that will be great! thanks --novelle dBaseIII format is fully compatible with fox2x format and VFPOLEDB works with them wonderfully well. I think you made some error in your syntax. You're inserting into myTable from otherTable. It looks like: use myTable append from otherTable VFPOLEDB driver supports use and append from only from within a stored procedure. You can instead use: insert into myTable (< fieldlist he ...Show All

• Airan About using imestatus()

  Hi, I am using imestatus() to change input method between English and Chinese. It worked good in windows 2000. But it doesn't work in window xp. imestatus(0) always change to Chinese input and imestatuss(1) doesn't work. code is as follow: =imestatus(1) && using Chinese input =imestatus(0) && using English input Anybuddy know why >> code is as follow: >> =imestatus(1) && using Chinese input >> =imestatus(0) && using English input >> Anybuddy know why What do you get when you just call IMESTATUS() - with no value Maybe the IME isnot installed on the machine.... Also check the setting of IMEMODE property Another question, how to switch input method betwee ...Show All

• NonExisto General question about query

  Hi, I'm VFPOLEDB 1.0 to connect to my tables. I'm using a table with 3,000,000 records want to display all the records from my table (about 20 per page), i'm trying to decide what is the right way to query the database lets say my table mane is students, and one of the field is a an Id with the values 1 to 3,000,000. 1. When i open the view i'll Do a query : "Select * from student", and each time I want to display a diffrent page (scroll in the view) i'll set the cursor position to the current row. 2. When i open the view i'll do a query : "Select * from student Where Id > x AND id < x+20" when x is my current row in the table. when i'm using the first method the query "Select * from student ...Show All

• RolandKlein VFP and Word Merge

  I am adding word automation to our VFP application. I like the ease of use of Bookmarks and have no problems navigating thru a document that has existing bookmarks. My problem is that users will need to create new documents and add bookmarks into the appropriate places of the new documentation. How do I provide the user with a pick list that will allow them to insert the available bookmarks. Is this a good approach for a mail merge or have people been using word fields Stuart Bookmarks are okay, but have one major drawback--a given bookmark can only appear once in a document, so if you need the same data item more than once, you have to give it several different names. You can automate Word's mail me ...Show All

• RCS300 Excluisve access

  I have a VFP 6.0 application that is used simoultaniously on many computers over a network. Sometimes, when a certain form is opened, it returns a error that says that some component can't be loaded for it is used in exclusive mode by another user. Problem is, I can't figure out what it is that's beeing opened as exclusive. Anyone knows what I should be looking for   CFutino wrote: The problem is my system (and therefore the error) is in protuguese. It translates to something like 'Impossible to perform because other user is using some component exclusivelly'. It does not say which component.   Isso e um problema, ne What seems to be happening is that not everything in your p ...Show All

• karfast One works only when other not touched?

  Hi, In single Table form there are "Report & Invoice" command buttons. The problem is if "Report" execute once "Invoice" won't do anything and vise versa. Also Is there any command that will preview the report in maximized size instead of clicking it every-time   "Report" command button code is: REPORT FORM monthly.FRX PREVIEW   "Invoice" command button  code is: REPORT FORM invoice NEXT 1 TO PRINTER preview   Any help well greatly apprecite, Thanks Just add NEXT 1 to your REPORT FORM ... PREVIEW command. The problem is that right now, you have it reporting on all records, which moves the record po ...Show All