Answer Questions

• the-rpd "Flush" vs. "Tableupdate(1,2,.T.)" ?

  The question is: When is it wiser to "flush force" (data to disk) vs. =Tableupdate(.T.), =Tableupdate(1), etc. What is the usual paradigm Can I forget flush Is flush slow in the LAN setting(s) Does flush hog resources Does frequent-flush help prevent corrupting tables during intense LAN data-manipulation, crashes, and/or power outs Is is dangerous to rely too much on Tableupdate() alone when tables stay open all day As always, thanks in advance for any thoughts Budoi and Andy, While issuing FDATE() to display "Last Modified", I *discovered* open tables don't write to disk after commanding "tableupdate(.T.)" An updated open data-file remains unsaved and not "Modified" (acc ...Show All

• Mjoyner24 Fonts, ? and set alternate

  Hi; I have lots of older code that uses commands and set alternate to create a text file and then it uses modify command to view the file. I have noticed that on my development PC, this created a file with Fixedsys font. On the installation pcs the font is "Courier". Is there a way to determine what font will be used when issuing commands to a set alte file I know that I can use the font clause in the command itself but I was wondering what determines the default font used. Thank you all for puting up with my "oldie" questions. I don't even know how to change my midy command font... I would love to know how to change my default font. No idea. You ...Show All

• ian88 visual foxpro 6.0 software

  where can i find visual foxpro 6.0 software download for free Lakshmi N wrote: I tried both the links to buy VFP 9.0 Academic Version. but the form does not allow any body to buy outside US i think. i am from india and city bangalore. how can i buy the software. the form asks for state and country. and india is not at all their in combo box. can u just help me by telling me how to buy this academic version in india i.e. bangalore city. The academic version isn't a different version like VB Express, but rather a special price for faculty, staff, and students of a qualifying educational institution. Academic version licenses are usually bought through a university bookstore ...Show All

• Chidu using INPUTBOX()

  hi guys...is there a way wherein i can make the text in the input box to be hidden like in password i need it asap..thanks I think he meant show what the user types in the textbox as asterisks just like a password entry. I don't think that's possible with the INPUTBOX() function, you could create your own form to simulate this though. Either put nothing as default value or just put a series of asterixes. for me i will call another form pop-up then user input password. in tis case inputbox not suitable. HTH ...Show All

• PAzevedo config.fpw

  how i can find my config.fpw how i can call my program that use only my codepage=950 for hongkong characters i wan create my own config.fpw and at my main.prg call this config.fpw... how i can do that thanks in advance. thanks for sharing If not overriden in command line it's in startup folder (ie: for IDE it's at home()). Put codepage=950 in config.fpw You can create a config.fpw with notepad or "modify command" from IDE. Config.fpw cannot be called from main.prg. It's processed at startup. Basically there are to ways: 1) Put it in your executable's folder. (my preference) 2) Include in your project. And don't forget that if you're running an EXE (which y ...Show All

• flarebol Speeding up SQL Statements

  As per Tamar Granor's interest, I'm curious if I can speed this up a bit; it takes almost 3 seconds of user-time on an IBM X41 tablet (SANS networking). Behold: Select Allt(patient.first_name)+' '+ patient.last_name As PatientName,Record From patient; UNION (Select Allt(patient.last_name)+', '+ patient.first_name As PatientName,Record From patient); UNION (Select Distinct Alltrim(Proper(patient.Record))+' '+Alltrim(patient.last_name)+', '+Left(patient.first_name,1) As PatientName,Record From patient Where patient.Record <> (' ')); UNION (Select Distinct Alltrim(Proper(visit.insur_no))+' '+Alltrim(visit.last_name)+', '+Left(visit.first_name,1) As PatientName,Record From visit Where visit.insur_no <> (' ') ...Show All

• TELII Wait Window "" timeout 0.01 and Sleep(10) in VFP-9

  At times my VFP processing requires *rest(s)* it seems. (report processing/printing, various functions, .BeforeRowColChange events, etc.) I've *discovered*: Wait Window "" timeout 0.01 && ... helps at times while the preferred: Windows API Sleep() routines && ...I've had NO success with API Sleep() declarations Any general or specific feedback concerning *rest(s)* in VFP-9 is appreciated. Hmm, I don't see the need for the WAIT here. I think this is one of those cases where VFP is queuing the events andspeed is the issue. Try using this code instead - you should see the code stop (I do) IF RECCOUNT('cPatient')=0 this.BackColor= RGB(255,0,0) *** Force a refresh here This.Refresh() *** Is the b ...Show All

• Allan-Nielsen SELECT .... INTO TABLE <existing table>

  G_TempDBF = "C:\scratch\" + SUBSTR(SYS(2015), 3) + ".DBF" SELECT field1, field2 FROM myTable INTO TABLE (G_TempDBF) USE (G_TempDBF) ALIAS CUSTOMER INDEX ON field1 TAG field1 I have created a temporary table, stores the retrieved records into it and alias it CUSTOMER How can i reuse this temporary table for other SELECT statements SELECT field3, field4 FROM myTable INTO CURSOR CUSTOMER ---> results in an error saying Alias CUSTOMER has been used. You can't. If you want to add to an existing set, and the previous cursor is R/W (use the READWRITE keyword in SQL statement), then simply APPEND FROM the new temporary. ...Show All

• cobain81 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.   dni wrote: To use: Hide Window "Microsoft Visual FoxPro" You need to create a form set from menu and set the properties for form set:  WindowType: Modal For the form: WintowsType:  Modeless ShowWIindow: As top level form I have to disagree. Cetin's answer is correct. Besides Modal forms not being allowed as top form, Best Practices by most people indicate the use of simple forms, not formsets, which are more of a pain to work with. A config.fpw file with the li ...Show All

• TheresaKad how to check for your prg running?

  heres my prob. when you launch my application and minimize it and then try and launch it in a second screen you get alot of errors. how can i check if the program is already running so i know to cancel the prg right away if it is alrdy running Another possibility... use Windows Management Instrumentation Service... I use this function to kill existing processes I don't want running... PARAMETERS pc_ProcessToKill * Get connection to Windows Management Instrumentation service lo_WMI = GETOBJECT ("winmgmts://") * Set query into service to look for process to kill lc_Query = "select * from win32_process where name='" + pc_ProcessToKill + "'" ...Show All

• term_paint VFP8 & VFP9 error

  This error appears in the Task Pane Manager Class definition MSXML2.DOMDOCUMENT.4.0 is not found Task manager will no longer work. Any suggestions Bryant Minard Looks like you need XML Parser reinstallation. http://support.microsoft.com/kb/269238 http://support.microsoft.com/kb/324460 Codes are in xsource folder. Are you using something like this: var xxx = new ActiveXObject(" MSXML2.DOMDOCUMENT.4.0 "); if yes I think Alex Feldstein has right . Can I see some code (JScript ) What code do you need Someone on a foxpro thread said I need VFP9 SP2 but I can't find that anywhere. ...Show All

• mliesmons Aha, found. To be able to reply first cause an error:)

  Hi everyone. I have noticed a rather serious incompatibility between VFP9 and older Foxpro versions. In the following code, when the field valid is fired, the related table record is not seeked and not found. In older Foxpro, the related table record is already seeked in the valid clause. This happens only for the first entry in the 'TmpProd' table but subsequent entries are seeked and fine. Is there a solution for this aside from seeking within the field validation code SELECT 2 USE prod order ProdId &&Index is on ProdId SELECT 1 USE TmpProd EXCLUSIVE SET RELATION TO ProdId INTO prod zap APPEND BLANK BROWSE FIELDS ProdId:v=showinf(),design=Prod.design RETURN FUNCTION showinf ...Show All

• Becky N System resolution

  Hi. How can I find out what the system resolution is, and how can I change it via FoxPro Thanks I have found this site before, but the Sysmetric is better for fining out what the system resolution is. Anyway I want to know how to change the system resolution. I will be glad if someone tells me how to do so. Thanks for advices Simple one, My formulars are quite big and when the system run on 640x480 and the grafic card and monitor permit higher I it will be better to ask thrue the program the user whether the program can change the resolution to the requested one. Why not to display whole form insted of parts of it. I want the solution, if anybody kno ...Show All

• Sam Kaplan switching pages in pageframe

  I want to be able to detect when I am clicking on a page tab to switch pages, so I can control which portions of a lostfocus event on an object in the current active page will execute. I appears that I can't use mouseenter on the target page, like I do on command objects. OK, along the lines in previous messages you said mouseenter/leave would somehow work for you. Then you can use pageframe.mouseenter, mouseleave to set a flag to signal lostfocus that it's on tab area, no (and maybe handle kb accelarator with keypress as well). I agree using command objects isn't the ideal solution - the more kludgy a solution becomes, the less clean the code is, the more obtuse ...Show All

• dlcollison Excel to cursor?

  Hi guys, I am working with some data that is about 400 lines long, and I need to update it into MS SQL 2000 via Visual FoxPro. I need to know, is there a way I can take excel data and import it into a FoxPro cursor Thanks I don’t understand... What’s giving you trouble Dave M. Dave M. wrote: I don’t understand... What’s giving you trouble Dave M. I'm sorry Dave, I completely misunderstood what you had written there in the other thread. What you wrote was helpful, and the answer, as was what Alex posted. Again, sorry for the confusion. Alright guys, it's looking like there are new problems afoot! What you guys suggested with the sqlstringconnect() works, with on exc ...Show All