Answer Questions

• De_Vaddrr Cancelling Rendering of Report in VFP 9.0 when ESC is pressed

  Hi All, I want to quit the rendering of report in the middle of its work in VFP 9.0 using report listeners when Escape Key is pressed. i tired using the SET ESCAPE ON and ON ESCAPE i was not sucessfull. Please advice me in this. Thanks in Advance Thanks Venkatram I am not very sure. i think it can be simply done with set escape on on escape do exitprg proc exitprg clos all clear return the above works in foxpro on dos and foxpro for windows. ...Show All

• Bubo Dbf Autoincrement with ADO

  Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks, 1) it will not work with ODBC and newer table capabilities such as autoincrenent fields as I said. On top of that you are invoking MSASQL and nto VFO ODBC Driver 2) Should work with OleDb Provider. What is your code to update What is the failure error message Remember you cannot/should not write to the autoinc field as it fills automatically. Also remember to provide values for any columns w ...Show All

• Sebastien A how to shutdown the OS without error

  good day to all. i use my Net monitoring system developed in VFP at my net cafe for almost a year now, and so far it works fine. But there is a little problem that although it don't bothered the user and me but it much better if it does not shows-up. When i shutdown the workstation or restart it from the server, before it will totally close there is sometimes that a VFP error message will pops-up, which will prompt to send the error to MS. How could i prevent such error as if there is still missing in my shutdown code, clear events, clear dll's, etc and etc they've all there already. it seems that the PC can't wait any longer to shutdown. Thanks for any help regarding this matter Madix_t wrote: you have still records wait ...Show All

• pessi working on toolbar and time

  hi guys...im developing a system for my thesis and i have problem on these: A. toolbar - i have already created a toolbar using class and then drag it to my form and created a formset. when i try to run the form, the toolbar is at the upper left corner and needs to be double-clicked for it to be placed below the menu bar..what i want to happen is that when my form appears, the toolbar will be automatically placed below the menu or when the system opens,it will be automatically placed below the menu bar. what should i do B.Time - i have a label, timer, text1 which displays the date and text2 displays the time..by default the label's caption is Good Morning..what i want to happen is that when the time reaches 12:00pm, the label will display ...Show All

• JGP TYPE

  I like to know what character will return function TYPE() from x, where x is: x=STR ( YEAR ( DATE ())) I think I have somthing wrong with my vfp 9 installation. You are right but I receive "N" on 2 computers (one with vfp 6 and other with vfp 9) and I don't know why. It will always be "C" for character with this code. What do you expect from this Don's right: TYPE ("STR(YEAR(DATE()))") && = "C" x = TYPE ("STR(YEAR(DATE()))") TYPE ("x") && = "C" ...Show All

• Rob Grunkemeyer Newbie forms/list box/tables question

  We are currently using Visual Foxpro 6.0 (yes, I know it is outdated). We have a simple form which displays a free table as a listbox and has two custom buttons (run/quit). Basically the user highlights a record and selects run, which starts a report form on another free table. This works great when I run the form directly, no issues whatsoever. However, when I try to call the form from a program (do form imenu) the list box shows up as just a big blank box (the table is not displayed). I have tried adding and removing the table displayed in the box from the Data Environment, in combination with adding and removing "use" statments to the program to open the table before calling the form. In either of these cases the table does no ...Show All

• looplocal move question

  Hi again, I want to know if there is a function or command to move a file in visual fox pro 7. For example, if i want to move 'c:\users\pru.dbf' to c:\myapplicaction\pru.dbf. Thanks, Actually there is, as I mentioned above: RENAME FileName1 TO FileName2 but it is a little tricky and you have to check (mainly with try..catch) if you are moving between servers or if the destination file already exists. See: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/6a346173-f9d9-4d4c-8396-e82bbfc3e08b.asp frame=true As has already been posted, there is nothing native to VFP to get a move done in one fell swoop. But, there alw ...Show All

• jitendra badkas program starting problem, grid problem

  Hi I have several beginner questions for VFP 8.0 1) Where should I put the READ EVENTS method so the main form will show itself instead of showing the fox pro main window 2) When executing SQL simple select statement for filling a grid, it fills the grid inside the form, but firstly it shows the result in a grid outside the main form. How to show result only in the grid placed on the form I didint understand what you tell me for RecordSource i fill grid with next statement: ogrd=ThisForm.grdUsers ogrd.RecordSourceType=4 Grd.RecordSource= "sql statement" where i put "INTO CURSOR Fred NOFILTER" How to create config.fpw Deni ...Show All

• yosonu Mixing XLS and DBF tables

  In l ieu of some latest trends in my FoxPro development I want to know how do you sensible mix Excel .xls tables, workbooks and projects with FoxPro .dbf tables and databases. I have followed Marcia's earlier suggestion to use convert .dbf into .xls for graphs and now I want to integrate my .xls into existing databases. I tried to attach an .xls table to my databases but only could do in the browser as free table. This was to now avail, however, since I could not open it in FoxPro anyway. Another question, somewhat related: I used a wizard to define the connection string to a FoxPro Database. How can I do it if I need to define a connection string to an .xls table What is the equivalent for a database in Excel: a workbook Is th ...Show All

• flash.tato How to remove redundant phrase in field?

  Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown above or there could be 6. I suspect that the 'common denominator' is the semi-colon, but everything I've tried has failed. Any help is greatly appreciated! Yes, but let me know first, if you know all redundant phrases. Hello CDFAUX Thought this worked for me, but here's what I got: T ...Show All

• MasterModeler Exporting to Excel in multiple spreadsheets

  I have my program exporting to excel just fine, however here lies my problem: Some of the databases are reaching the excel spreadsheet's 65,536 record limit. I actually had something working to where it would copy the records up to 60,000 (or whatever number you specified) - when it reached this limit it created a new spreadsheet in the workbook and started copying from there. There was one HUGE problem with it though - it was slower than molasses in winter. It took roughly 10 mins just to copy over 20,000 records becuase it was doing everything one record at a time. I felt this was a bigger problem than the 60,000 limit so I just started using this instead: copy to &cFilename fields &cFields type xl5 The problem now is that ...Show All

• docturny vfp 6 forms

  Here is my situation. I am filtering in a combo box in reference to some info entered in a previous textbox. My problem that I am having is when you navigate records using the wizstyle textbuttons the info displayed disappears. I have tried set filter to in this.comboname.valid and lost focus events, but it still does not display info. I noticed that it seems to still go by the last combo box got focus event. I even tried rebuilding the combo in each textbutton and calling a requery event of the box from each textbutton! Any suggestions It seems to be a small problem with that and I think that was solved with version 9. http://support.microsoft.com/default.aspx scid=kb%3Ben-us%3B249633 I had same p ...Show All

• SankaraNarayanan Nagalingam Error 2091- Table corrupted.

  When opening a table that exists in a project I got the following message- Repair the table using an appropriate third-party repair utility for Visual FoxPro tables before opening the table again. What does this mean & how do I find a third-party repair utility   Thanks!!! SharathMum wrote: SET TABLEVALIDATE TO 0 (zero) this will solve the problem for detail refer VFP9 help SET TABLE VALIDATE TO 0 does not "solve" the problem. All it does is mask it. VFP 9.0 is does stricter checkings and finds things that were wrong but not caught by the parser before. Even though it gets you going for the moment, it does not fix the problem, just hides it. You should still see what ...Show All

• the_developer MySQL and VFP

  Hi experts. I have a MySQL database. I operate with them using syntax like SQL(sqlhandle, "select * from...") I copy them into cursor and than operate with a cursor. Is there a simplier way how to work with them Thanks in an advice. I understand but I have asked whether the problem may be that I am using free MySQL database, whether this speed isue can be one of the database limits. the code below takes somethimes 0,61seconds and sometimes up to few seconds(1-3) start=SECONDS() OPEN DATABASE data mySQLhandle=SQLCONNECT("connection") end=SECONDS() WAIT WINDOW end-start the code below takes 1325.436seconds to complete (10 000 records) start=SECONDS() FOR i=1 TO 10000 SQLEXEC(mySQLhandle,"I ...Show All

• DiamonDogX Dbf Autoincrement with ADO

  Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks, May be you experience transmission errors and file becames corrupt in transit. Do you have a connection pooling enabled Connection pooling is activated automated when you connect.You may disable it with OLE DB Services= -2 inserted in connection string (at the end). 1) it will not work with ODBC and newer table capabilities such as autoincrenent fields as I said. On top of ...Show All