Answer Questions

• HirenBarbhaya Merge 2 text file

  Hi... I have to text file. Can anyone advise how to combine 2 text file into one file using Visual Foxpro 6.0. Thank you. if u know the layout of destination.txt, you can create a blank structrue and say use destination appe from desitnation.txt sdf or u can open destination.txt in excel and save it as dbf. then u can match product and destination to get a 3rd file i.e. sele a.productid,a.description,a.productgroup,b.destination from product a,destination b where a.productid = b.productid into dbf prddest.dbf your prddest.dbf will have all product codes with destination,description and group Hi Markish, Sorry maybe I didn't make it clear just now. Actually wha ...Show All

• Ian Jorgensen Will VFP6 work with Windows Vista

  My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. One word of advice, when you get VFP 9.0, spend a few minutes reading the "What's New" section in the help file- there are some significant changes from VFP 6.0 - especially to the SQL Engine. You might also consider investing a few pennies in this book too: http://www.hentzenwerke.com/catalog/wnvfp9.htm Perhaps the answer is (FREE) ...Show All

• Phantisy no docking

  i have a tool bar but i dont want someone to be able to dock it.. how can i prevent my users from docking the toolbar i tried setting enabled to .f. but than they cant click the butons in the toolbar.... Place the ff code in the AfterDock event of the toolbar: THIS.Dock(-1) ...Show All

• forrestcupp Error loading file

  Hello, I can't open same forms and report, I getting error "Error loading file - record number n. "object" <or one of its members>. : Memo file c:\mypath...\my database.dct is missing or is infalid Is there a way to open these file I will deeply appreciate advices or ideas.. Thanks. I alredy done it, but I dosen't see anything suspicious in the table. when the form isn't conect with database it is open ok The way to solve this error is to open the database and issue the VALIDATE DATABASE RECOVER command. To see the options review the VALIDATE DATABASE command in the help file. Thanks, you save me pleace write to me if same one have other solut ...Show All

• NumberKruncher Will VFP6 work with Windows Vista

  My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation. > And in my opinion the point is:  if I have an application VFP6 (and perhaps I don't possess the sources, or I don't have resources to convert the application to new versions), in some way I have to be able to make it work. I see your opinion but I don't agree. If an old app written in a very old version, to which you may not even hav ...Show All

• kshill VFP7 COM+ object and ASP.Net 2.0 on IIS6 - Interop issue

  Hi,I wonder has anyone managed to get his/her VFP7 COM+ object run on ASP.Net 2.0 on IIS6 1. I compiled the object using MTDLL and deployed into my SBS2003. 2. I think this shouldn't be a security problem as I didn't manage to get it run even I have set the IIS6 worker to Local System. 3. The COM+ object has actually initialised. Codes in INIT method has actually run (I put CREATE TABLE ..... in the INIT method, and check if the table is created later), but when come to calling a method from ASP.Net, I hit an error. 4. Tried many possibilities, but no luck. I have also followed the example from Craig, got the same issue. 5. The same VFP7 class (but complied as EXE and configured as DCOM) was running fine on IIS5 ASP2.0 on Windows 2000 Ser ...Show All

• leo1 Sub Total and Grand Total in Table

  Dear Experts Following are tow columns in Table1, Field1 has products and Fileld2 has quantity A-----------60 A-----------45 A-----------20 B-----------40 B-----------35 B-----------85 B-----------15 C-----------12 C-----------18 In table I want to get sub totals of every category and then Grand Total at the end of the Table as below A-----------60 A-----------45 A-----------20 sub total--125 B-----------40 B-----------35 B-----------85 B-----------15 sub total--175 C-----------12 C-----------18 sub total---30 Grand total-330 Tariq, Those types of data are almost always needed for reporting. What are you trying to do Report supports it. If you need it as a cursor/table then create a cursor/table with appropriate structure and fil ...Show All

• jomunoz Forcing code into a Click Event

  I have added a grid to a form. I'm using the code below to control the contents of the grid. I want to react when the user clicks on Column4.Text1. How can I add an IF...ENDIF set of code to the ThisForm.Grid1.Column4.Text1.Click event WITH ThisForm.Grid1 .RecordSource = 'viols' .Column1.ControlSource = 'viols.oxv' .Column1.Width = 83 .Column1.Header1.Caption = 'Current status' .Column2.ControlSource = 'viols.violation' .Column2.Width = 320 .Column2.Header1.Caption = 'Violation' .Column3.ControlSource = 'viols.allowed' .Column3.Width = 81 .Column3.Header1.Caption = 'Violation Amt' .Column4.ControlSource = 'viols.new_oxv' .Column4.Width = 104 .Column4.Header1.Caption = 'Change status to:' ENDWITH ThisForm.Grid1.Column4.Tex ...Show All

• PatrickCairns How to disable Foxpro screen?

  I have a project with one screen form only. When I run the execute, the screen form is within the foxpro's screen. How do I make the screen form as the only window form shown on screen Thanks. Joe. screen = off in config.fpw is the best solution. Toplevel forms can NOT be modal (even if you set to modal it is ignored). You need "read events" to start the event processing and to prevent the application's immediately ending (flashing and closing). Here is a simple one form layout: * Form.init (showwindow property is 2-toplevel) this.Show read events * A button in form click - "Close Application" button * Button's click code clear events thisform.release * Config.fpw sc ...Show All

• AshishMalhotra CPU Usage when using Timer

  Hello, I am using an VFP 6.0 executable which contains a timer control which will constantly monitor for some files in another machines in the same network. This executable is not a visible one. But when used at the client I found in the task manager process the CPC memory resource is occupying some 50 to 70 % of resource and hence slowing down the other processes. Can any one give a solution for this problem Try using the SLEEP Windows API instead: Declare Sleep In Win32API Integer nMilliseconds nSleepSeconds = 1 nMilliseconds = nSleepSeconds * 1000 =Sleep(nMilliSeconds) I agree with Cetin, it sounds as though your Interval is too low - I can reproduce this behavior ONLY if I set the int ...Show All

• skuehner Arrange the "character string" numbers in order

  I use the character string for number input. What Syntax should I use to sort out the “character-string” numbers as below For example: To sort out according to the number 1 1 12A 3 3 4 4 5 443546 12A 5 443546 555AB 555AB Thank you. Sir, the above command also works fine.  but if u have 'ABC155' in dbf then the in the output u will get  ABC155 1 3 4 5 12A 555AB 443546 which may be wrong if he wants numbers first then a ...Show All

• SteveMo Crystal Reports SelectPrinter command error

  Hi All, We have a VFP 8.0 program uses Crystal Reports XI object to print one of our reports. Last week the program started giving a Fatal OLE error on SelectPrinter command. "Exception code c0000005. Ole object may be corrupt.". We haven't change the exe file, we haven't change the report and we didn't install any new thing on the computers. Here is the code: CRApplication = CreateObject ("CrystalRuntime.Application") CRReport = CRApplication.OpenReport("DailyReport.rpt") CRReport.SelectPrinter('AdobePS Acrobat Distiller','Acrobat Distiller','c:\temp\*.pdf') CRReport.PrintOut(.F.,1,.T.,1,1) Release CRReport, CRApplication Any information is greatly appreciated. Thank you in advance, ...Show All

• nvandyk How to change assigned class libraries.

  Hi; I have often backed up my working folder to seperate sub folders like 'backup' etc. I have just noticed that in my project the class lib for some of the classes is the class lib in the backup folders. I am not sure how this happened. Is there a way to reassign all existing classes and objects so they use the one in my development folder Thx. Hi, Project files are FoxPro tables. You can simply open and modify them by USE command. (Use myProject.pjx) The file path is kept in the Name field and the Type field indicates the object type. For class libraries the value is "V". The rest is just writing a simple program to find and replace. ...Show All

• AlexBB extract data

  Hi, i have some dbf file which are I dont know their content. I try to import data to access but give me error. I search lot but cannot find a solution. Finally i try to open connection foxpro dbf file using java jdbc.odbc, connection is ok. But the problem is i dont know internals of this dbf file, which columns they have etc... Also i dont know about dbf files. Are dbf files normal databases, i mean they contains tables, tables contains columns etc. My question is which queries do i have to use to learn internals of this file. By this way i can import data to a text file , maybe. Thnx. You can get VFPOLEDB provider here if you don't have it: http://www.microsoft.com/downloads/details.aspx FamilyId=E ...Show All

• Simon Dahlbacka Suggestion for VFP-MySQL Multiuser env.

  Hi all, I've just shifted from Foxpro tables to MySQL server based application. For a multiuser environment in VFP I used to have the temporary tables for the individual users in their own local machines. But in case of Mysql / oracle how to handle this situation The temporary table that I 'm speaking of are generated when I want to create some reports or perform some maintenance on tables. For example consider a scenario of producing a Sales analysis report. In VFP based application I created a local table say temp and put the data from invoice, invoice return and all related tables. then I manipulated the temp table to suit my reports. There was no problem in multiuser env. since each user created their own 'temp' table in thei ...Show All