Answer Questions

• Gonzalo123 Need help on a small open table code

  Hi, I m trying to make a general opentable function that I will use with all my apps in the future. Now I need someone to explain to me a few things to see things more clear. Here is my code: function OPENTABLE(TABLENAME)  LOCAL TABLETOOPEN *Ok this is just a full path I make for the dbf file. I do not know if it the right way.what it gives is  eg. c:\program files\my app\data\mytable.dbf  TABLETOOPEN=TOSTRING(checkpathf ...Show All

• MikeCB1975 Connecting VFP applications on Wide Area Network (Client-Server).

  How do I connect VFP Application running on windows Small Buisness Server through WAN For Hardware: HP server with Xeon processor, 2GB Ram & 80 GB SCSI HDD is ok, but if you want a better system, get a server with at least dual processor, 2GB RAM min., HOTPLUGABLE SCSCI HDD 73GB X 3 or higher capacity, configure it to use RAID level 1/5, install the system OS and data separately on the  ...Show All

• jianglinchun OWC11.PivotTable

  I've tried to play with MSGraph for some time and after not getting very far yet (although I got some graphs) I downloaded MS Office Pro 2003 enterprise Edition and found out that there seem to be richer controls out there. In particular I am trying to work with OWC11.ChartSpace , OWC11.PivotTable and OWC11.SprreadSheet . I have resigned to the fact that I would have to use MS Excel Spreadsheet as an interim container between my tables and the g ...Show All

• Dan-el Timer Control not kicking in

  Hi All, We have a small VFP 8.0 synchonization utility that picks data from a VFP 8.0 database , converts it into XML  and sends it over the net to an Oracle database . It has a timer control on it which makes sure that this utility sends the data from VFP 8.0 to Oracle every 45 mins. It has always worked on all the setups till now, except one. We have not been able to figure why it does not work on that one. Any hints or directions to thi ...Show All

• EricCS07 sys(2015) Conversion back to System Date Time

  I'm working on a project to do some analysis, and difference between versions of ClassLibraries (VCX/VCT), Screens (SCX/SCT), Projects (PJX/PJT), Etc... I'm looking at the Uniqueid field which is a sys(2015) type of value, which is based on a given system date time.  I've seen an article that explains how to reverse the value back to the date time, but I just can't find it anymore. Can anyone help me with a sample of what I need for this co ...Show All

• JCroney seek char+date

  dear all, i seek stockist code+invoice date but failed to seek. why what i had done... use invoice shared index on code+dtoc(inv_date) to invoice.idx set index to invoice.idx seek code+dtoc(thisform.txtInvdate.value) but failed to seek. thanks. >i know there is a code to do so.if i found i will post it to here so as other forummers can take benefits from it. Simply DELETE TAG ALL Then INDEX ON fi ...Show All

• kickf1ip can i just use sql to get this?

  date           transfer 20050101    200.00 20050103   -100.00 20050530     95.30 ... SQL to get： date         transfer          balance 20050101   200.00         200.00 20050103   -100.00 &nbs ...Show All

• stevo2005 Fatal Error when writing to excel

  Hi, The version of Foxpro is 6.0.  The application I am buliding is to write data into Excel 2003.  There are times when I am getting a Fatal Error at a stage when I am writing the data into the cells.  Prior to this step I have other processes where I add more sheets and rename them, setup the borders and page setup and all works fine. I try to debug the application and it runs fine.  The problem is that the message is ...Show All

• Gad_appraisal a bit of array related confusion

  I am having trouble figuring out how you increment arrays. To illustrate what I mean, I want to show how easily it is done in Visual dBase. You declare a = new array (); then you can say a.add ("Andy Kramer"); the next statement might be a.add("Cindy"). You've got a one dimensional array with two elements in it. Naturally, array is an object. Here you've got AINS() which inserts an element in an array kicking out the last element which i ...Show All

• eDevMachine How to read in sequence a lot of combo box?

  can I read in sequence (with a FOR cicle, or something similar) the list index, of a lot of combo box and, can I associate a combo box with a txt box For example...I have 3 combo and 3 txt....if i selected something on combo 1 read the txt, otherwise no...and the same for the other txt Can I do that in automatic with a for cicle If you don't understand, what I asked you, please tell me! I don't know exactly what you want, but let's ...Show All

• Rads 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

• Ian McChristian upgrading old foxpro apps

  we currently have foxpro version 5, and a handfull of apps which were developed on it.  the person who developed them has since left us and it has become my job to find a way to upgrade these apps.  the problem is that i don't know the first thing about foxpro - i am a coldfusion guy.  so the biggest thing we want to do is to get the data from the foxpro databases into a sql server database.  if we do this can we still run t ...Show All

• DarkRoses APP_GLOBAL

  I found this object ( ) in a project file and also there were a couple of posts in the NG mentioning it briefly. I remember one of the experts said that he had never heard of it. It reminds me of a very useful object in VdBase: _app. It is a global object and you can attach anything to it to be used in any part of the program. I usually define all my queries as children of this object. Anyway the command window in VFP does not recognize it. Help ...Show All

• Nihar =SYS(1037) on VFP90 no longer allows printer changes

  Can anyone tell me how to work around the changes in SYS(1037)   I used to call this with =SYS(1037) before printing in a batch (checks and invoices) and it no longer allows my customers to change the printer in VFP90 (no 'apply' button).  The 'prompt' option in REPORT FORM works just perfect too, but I don't want to call it in a loop (too repetative.)  Any ideas Thanks Using the 80 style report output, you can chain repor ...Show All

• francois974 detect shutting down of client from the server

       I install my Internet time monitoring system application and it works fine, But the only disadvantage with my application is that when the user shut'sdown or restart the client pc even at  a normal procedure way, without informing the net attendant at the server, (not pushing the restart button or ON/OFF button) my application at the server can't detect that the workstation shuttingdown or restarting. ...Show All