Answer Questions

• OSayCanYouC Writing our own code for the Print Button in the Report Preview toolbar VFP 9 using report listener.

  Hi, I want to call my own print dialog box in the print click of the report preview toolbar in VFP 9.0 using reportlisteners. i want to disable the base class functinality and write my own functionality in the button. -Venkat Hi, can we trap the code of the Go to Page in the Report Preview Toolbar and change the caption of the language of the small window comming up for the click event of Goto Page Other wise ...Show All

• gunsen Runnning VFP6.0 in Win 2003 server

  Our system runs VFP 6.0 on Win2000 server. We are going to migrate to Win2003 server. Do anyone know if there is any known problem for VFP 6.0 running on Win2003 server Any comment is appreciated. I think the main feature of security setup on Win2003 Server is that every time you try to connect to the Internet the OS is asking you for clearance for a particular URL even if this URL is not your initial inte ...Show All

• Silver DELETE FOR-PACK ON BUFFERED TABLES

  I have a buffered(5-optimistic )tables in vfp 9.0.when i use delete the records arent deleted i use tableupdate but they dont get deleted.i use pack but i get a msg saying table should be in no buffered mode i then change buff to 0 (not programmatically with cursorset.. but from dataenviroment) but is still get the msg! how can i delete a record table must be in buffered mode and my second answer plz is how ca ...Show All

• Chris7432 Accessing FoxPro 2.x tables from VFP 9

  Hi, i have found, that VFP 9 cannot optimize selects / updates / deletes on FoxPro 2.0 tables - it does not use any indexes defined for these tables. When i was manipulating these tables from VFP 6, there has not been problems and all selects / updates were optimized. Can someone help me to find solution for this  Thanks in advance Yes, our system under VFP 9 uses CP 1252 (current CP is 1252) -  ...Show All

• NewWorldMan foxpro dos to visual foxpro 9 conversion

  I am trying to convert an existing application I created many years ago in foxpro 2.5 for dos, but when I try to run my programs I get this error: File 'get_last_key.prg' does not exist. Can anyone help me. I'm completely new to visual foxpro any help will be greatly appreciated. Thanks, bertle I assume you have a function called get_last_key() with some parameter that is treated as a file name by Visual Fo ...Show All

• M Kamal ActiveX registration question

  I just downloaded Andy Kramek's book 1001 Things .. and ran through many pages. It is an awesome work! Clearly written and just very good for learning. I tried to find an answer to a question I have (among others) but it does not seem to shed any light on it--the question is rather specific. I tried to play with some ActiveX controls that can be found in Tools-->Options-Controls menu but some of the most interesting ones I could not even d ...Show All

• intGod GRID REFRESH

  Im having problems refreshing a grid.i have placed a table in data enviroment.then i drag and dropped all of his items creating a grid.then in a button i have a select...where..into this table.this way i put new values in the table,basically i overwrite the entire table.at that time grid becomes white,no values i tried grid.refresh nothing i tried to grid.recordsource="" select where into... grin.recordsource=mytable  still nothing is there ...Show All

• Vladimir Nesterovsky How to perform group by and order by AFTER union?

  Hi, I have a SQL statement like this: SELECT * FROM (    SELECT * FROM A     UNION     SELECT * FROM B) GROUP BY 1, 2 ORDER BY 1, 2 Is there any way to translate it to FoxPro 2.5 compatible Thanks. I think you can use this : SELECT * from A ; UNION ; SELECT * from B ; group by 1, 2 ; order by 1, 2   ...Show All

• SpliCEd how to configure properties of treeview in run time?

  I have a problem to disable the treeview object when the program is running, please help. the command which I used is : thisform.mytreeview.enabled = .f. I can disable it manually when I right click on the object and in the treeview property window. Any advise is very appreciate. It works. Thanks a lot. Try - Thisform.mytreeview.enabled = .f. Thisform.mytreeview.object.enabled = .f. Hope this help ...Show All

• NapalmTopGun Html Listener

  Hello Experts My application works fine when it runs from Command Prompt, but when i build an exe file the problem starts. I output all my reports to Print Preview, Print and Html files. The problem is with the html output. Below is the code for html output loListener = .Null. loListener = Newobject('HtmlListener', Curdir() + '..\Libs\_ReportListener') loListener.ListenerType = 5    &&Html loListener.TargetFileName ...Show All

• Ming D table buffering mode

  On a statement like this: IF NOT initTableEmpty TABLEUPDATE () ENDIF I get an error: This operation requires table to be opened in buffering mode . SQLBUFFERING is set to ON before the table is opened. It does not help. Actually the error happens once in a while for no reason. I cannot understand what triggers it. Most of the time the statement works. The USE command does seem to have no option for buffering either. Is any h ...Show All

• lgbjr 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 This is what I use to download a file from the web.  My customers use this each day.   To download from http site use    ftp. in front of the file name.   ******************************************************************** *** ...Show All

• Chris Hilemon How to go to the next page of report in custom preview window

  I am using the this code to define a window. DEFINE WINDOW reportpreview FROM 1,1 TO 50,100 IN SCREEN NOMINIMIZE TITLE "Test Window" SYSTEM Float REPORT FORM foo PREVIEW WINDOW reportpreview nowait RELEASE WINDOWS reportpreview Actually I added this code to a form which calls the report. Before adding the code I was just using : REPORT FORM report_name PREVIEW   in form code. But instead now I am using define window to preview report, ...Show All

• Ken Morley import from excel

  how can i import an excel sheet with huge text on some cells... i try it, but the character field is only 254 chars size, i did try to create a table and then append the big text cells to memo fields, but they remain empty... thanks for the help !! i'm checking that... Thanks a lot ! I'll try, Thanks !! I wrote this a while ago to convert an excel file to a foxpro dbf... its need some cleaning up but it should g ...Show All

• Matt Hollingsworth Moving from VFP 5.0 to client/server

  I currently have an application that was written in VFP 5.0 and running on Windows XP machines with the database stored on a Windows 2000 server. It was first installed in 2000 and has had modules added, the most recent being 6 months ago.  However, I have been having some problems with the program seeing that the database sizes has grown considerably with at least 2 tables having over 20000 records.  The hardware technician has ...Show All