Answer Questions

• magicalclick 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 Iuse similar too for few processes and they don't keep CPU busy as you say. Probably your timer interval is low and what's done in timr event is a time consuming process (making it almost like a do while .. enddo loop). Try using the SLEEP Windows API instead: Declare Sleep In Win32API ...Show All

• Sushil Srivastava Proper practice - edit a table in a grid.

  Hello everyone; I have a very simple form with a grid. The grid's record source is set to a cursor which contains a subset of a single table: Select * from PriceList where acct = cSomeAcct into cursor curPl I would like to add an edit button on this form which will alllow the user to edit the grid and update the Pricelist table. My question: What is the recommended way of doing this I thought of a few ways including issuing a "delete" and then an "append from", or maybe updatable views. How would you do this Thank you all. You definitely need an updateable cursor, and an updatable view is a good approach because the data gets posted to the table when you ...Show All

• mbaclawski Replace doesn't work

  Ok , what I'm trying to do is to generate a new ID every time I append a new record, this is the code I use I find the maximum value and store it to a variable CALCULATE MAX (invoice.id) ALL TO var_id Increment the variable var_id=var_id+1 I replace the "id" field with the variable, but it doesn't work REPLACE invoice.id WITH var_id What could be wrong the field's value doesn't get replaced with the variable's value When you use command: CALCULATE MAX (invoice.id) ALL TO var_id -> cursor go to EOF() -> the field's value doesn't get replaced with the variable's value Before use command REPLACE you find record # for invoic ...Show All

• RajaGanapathy can't find object after compiling

  After I create an error free form and build an Application for testing, I find that I get an error - Object "appt" is not found- (error 1923). This occurs when calling ths form from a complied menu pull down, with the code "Do form c:\apptbook\forms\appt.scx in it. This occurs when I exercise some code in a combo box like " appt.combo4.value". I don't get it, because I can run the same form with a command - Do form C:/apptbook/forms/appt.scx in the command window and all works fine. Regards...Al I thank you for your help. this was one of those "can't see the forest because of all the trees". I normally use thisform.xxx command all of the time, however th ...Show All

• Sean Hayes How to create a "WAIT-WINDOW [NOWAIT] LIKE" FORM CONTAINER

  Dear thoughtful VFP masters and/or fellow brethren... To implement such an object might ease the (lazy) user's mouse clickings ... being ... 1) triggered by another object's <MouseEnter event> 2) released by <MouseLeave> <Timer> and/or <MouseMove> events Strategic uses might be to: ...Flash monthly appointments and/or quarterly calender image(s) ...Flash a *pictorial text-tip* (peradventure worth a thousand tooltip-texts) (Again, It must NOT be modal but work exactly like a wait-window-nowait or tooltip) My embarrasing thoughts are something like make a formclass (.titlebar = .F., etc.). loWaitWindow = NEWOBJECT ("WaitWindowLikeForm","myClassLib") loWaitWindow.show( ...Show All

• Mykhaylo Blishch fox table question

  hi, I need some code that asks if there is a field in a fox table and if it isn't, it must add a field to the table. Thanks, The easiest way is to check the size of the field (0 if it does not exist). Open the table EXCLUSIVE If Fsize("mycolumn") = 0  Alter Table mytable add column mycolumn C(10) EndIf Conversely, if you want to delete it. If Fsize("mycolumn") > 0  Alter Table mytable drop column mycolumn EndIf   If you go with FSIZE(), make sure you have SET COMPATIBLE OFF. Tamar You may use afiels() function (or fldlist() for older vfp) to put in an arra ...Show All

• Alex Farber Excel header/footer fonts and automation

  Hi, I did a search but didn't see this topic brought up. I want to change the font of my header in Excel (ver 11) using Visual Foxpro (ver 9). I used the macro recorder in excel to get a general idea, but I can't seem to get the code to work in VFP. Here's the excel code: ActiveSheet.PageSetup.LeftHeader = "&""Arial,Regular""2nd QTR 2006 vs 2nd QTR 2005" How do I get that code to work in Fox Any help would be much appreciated! Jeff That worked perfect, thanks! Right, I got that part. I'm just not sure how to change the font. Alex Feldstein wrote: >Here's the excel code: >ActiveSheet.Pa ...Show All

• SachaVDK Comparing VFP table Records with an Oracle database table

  I have table AB which is a VFP table and table CD which is in an Oracle database. Is it possible to compare the records in table AB with that of table CD and then create a new table in VFP for the records in AB not in CD using VFP and if so how is it done >>I have table AB which is a VFP table and table CD which is in an Oracle database. Is it possible to compare the records in table AB with that of table CD and then create a new table in VFP for the records in AB not in CD using VFP and if so how is it done First you need to create an ODBC connection to the Oracle Database. You will need to install the Oracle PC Client, and probably need instructions from your DBA about which instance to access, UserName and Password ...Show All

• Summa How to 'multithread' ServerXMLHTTP in FoxPro 7?

  So, Ive got a dilema and maybe some of you can help me. Im using ServerXMLHTTP as an object to download about 500,000 web pages and I need to figure out how to run multiple instances of XMLHTTP. For simplicity sake, this is what I have right now: objXMLGET = CREATEOBJECT('MSXML2.serverXMLHTTP') FOR x = 1 TO 500000 ThePage = " http://webpage id =" + STR(x) objXMLGET.Open ("GET", ThePage , "False") objXMLGET.Send sResults = objXMLGET.ResponseBody ** parse routine here ** NEXT x The problem is that I have so many web pages to go thru, it will take days to accomplish this. Is there anyway I can change the async to True and run more than one instance of the XMLHTTP Thanks in advance, ...Show All

• ashk1860 Does a table automatically open exclusive during an SQL

  I have tried to create an application that uses SELECT statements to populate controls on the form. After the SELECT statement runs, the table remains open, exclusively, is there a way to preform the SELECT and have the table open SHARED >>After the SELECT statement runs, the table remains open, exclusively This suggests that you are using the SELECT to create a cursor - that is always local to the user's workstation and is always opened exclusively. So the answer to your question is "NO" you cannot open it shared. However, if you are using a Query and you want the data to be visible to other users, you should probably make this into a Local View (which can be used to update the und ...Show All

• Xie Zheng 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

• akilah VFP & ASP.NET 2.0 COM/Interop Problem

  hi i need help i developed simple website (just for test) that use Simple VFP Com (one class have one method get the string and returns it's length) i tested the COM in VFP IDE , it;'s work fine i tested the COM in VB.NET (VS 2005) windows project , it's work fine without problem i tested the COM in simple ASP.NET 2.0 , and tested it in the web developer server which comes with VS 2005 , IT;S WORK FINE WITHOUT PROBLEMS but when i turned to ISS , i have problem when i click the command button which called my COM, this problem doesn't appear in web developer server (vs 2005-IDE) the error message is : error retriving the COM Class Factory , 80005004 i use Windows XP SP2 , ISS Version 5.1 what is wrong Greetings ...Show All

• Rohit Parasharami sql problem

  Hi, I used an sql clause in foxpro 7. I deleted some records with delete but I don't know how to commit these changes. If I write pack, it deletes all records. What can I do It depends. Are you using DBF or and external DB as your datasource Are you using buffering Assuming DBF and buffering, TableUpdate() will post your commands. Check the returned value for success or failure. See the help file for details. In any case, PACK will not delete all records (as ZAP does), but only the records already marked for deletion. If pack are deleting all records this means that all records are marked for delete.You may check with with browse or deleted() the status ...Show All

• vasudupe Deleted -SQL HELP

  I am having trouble with a form i created. It is a form with a grid of an email address book - table. I want to the user an option of deleting names from the grid/table and it works fine when i "Set Delete On" and test it. But when I implement it into the program and call the form from a main program it gives me an error that says "Deleted variable not found". any suggestions this is the code for the command button that deleted the record: select emailaddressbook DELETE FROM emailaddressbook where idemail = temp thisform.grd_Email.Refresh like i said, it works stand-alone Try commenting out the delete command and see if you still get the error. It might be coming from somewhere else ...Show All

• Blkbird Using server's date/time.

  Hi; Is there a way to make VFP use the server's date/time in the different date functions I have XP stations on Win2003 server and some machines sometimes have a messed up date. Transactions are updated with the incorrect date because the stations are not set to the right date / time. Thanks, Aleniko The only reliable way I have found is: -Create a file on server, get its creationtime, erase -Compare that time with local time. If difference is over some threshhold (ie: 5 secs) then set local computer's time. PS: In my applications I use an option ([ ] Synch local station's time with server time). If checked I do that. Cetin: Would the stat ...Show All