Answer Questions

• CarlosA Produce error when running the form

  Hi, When running the form, I got the error. The error is "Error loading file - record number 61. grid_detail < or one of its members>. ControlSource : Alias 'NEWDETAIL' is not found." I'm not sure where i go wrong on my form. Thank you. for me i wont use alias hm i more on thisform.gridbox.recordsourcetype = 4 && SQL thisform.gridbox.recordsource = "select sql statements " >> for me i wont use alias hm i more on thisform.gridbox.recordsourcetype = 4 && SQL >> thisform.gridbox.recordsource = "select sql statements " There are no SQL statements in my database. Purely written in VPF 6. I ran through the errors in the progr ...Show All

• mm_ezzo VFP6: Retrieving of data from VPF table (.dbf) through website

  Do I have to write asp scripts to achieve this Is there any tutorials for the beginner Thank you. www.foxweb.com See "Internet Enabling Visual FoxPro Applications" by Rick Strahl http://www.west-wind.com/presentations/internetenabling/InternetEnabling.htm No, you can definitely stick with fox coding for this. Activevfp ( www.codeplex.com/activevfp ) is a free and open source vfp tool that lets you easily create multi-threaded vfp web apps to do just about anything. Multi-threaded is key for any web app since multiple web browsers could be hitting the application at any one time. If it is not multi-threaded (or simulated multi-threaded as man ...Show All

• GSibley Alt-F4 to close the current form and NOT the application.

  Is there a way to set VFP so alt-F4 closes the current open window within VFP instead of the vfp application itself Thx. No, not THAT important... Thanks everyone. Don; It woarks like a charm... As long as its not ALT-F4. Any key is being trapped in the Keypress, but when I use alt+F4 the VFP application itself closes before the Keypress will intercept it. Any other ideas Thx. Sure, set KeyPreview to true and in the keypress event have this code: LPARAMETERS nKeyCode, nShiftAltCtrl CASE nKeyCode = 107 ** Letter ALT + F4 for EXIT click event ** assumes command button on form is called cmdExi ...Show All

• James Chaldecott CursorAdapters and ConnectBusy

  Hey all. I was doing some work with CursorAdapters and SQL Server and ran into the dreaded ConnectBusy issue. This was caused by having an adapter open where I guess all the data hadn't yet been pulled down so while it did a SCAN ENDSCAN with some updates, it kept coming back saying ConnectBusy and it felt like an endless loop. I got around the problem by putting in some code to ensure I could go to the top of the file and the bottom of the file and then reran my scan loop. But I know there's an easier way. What are some of you doing to get around this I know about a few of the approaches but I know there must be some other better ones around there. Thanks I just tried this out and think this may be a good way to go. My datamanager ...Show All

• infomax How to access methods of an Activex in a .prg

  I have created a Winsock Activex control in a FoxPro 6.0 program, and it works OK, but I don't know how to access the DataArrival function in code. If I was in a form, I'd just double click on the control and it would be there, but since I created it using CreateObject, I don't know how to tie a function to that event. Geoff Callaghan I appreciate the advice, and I'd love to try it, but I'm afraid I'm still floundering here. I'm using foxpro 6.0, which doesn't seem to have a Class Designer...just a Class Browser. Is there maybe an explicit example of this somewhere None of the ones on this site are helpful. I'm still at a loss as to why I should have to add anything. The control itself has ...Show All

• Harris140c 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. Then don't accept and don't download. You don't need to express it explicitly. Good luck. 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-star ...Show All

• Gregory English 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 Codes are in xsource folder. Can I see some code (JScript ) The following is what solved my problem. This came from Matthew Braun. I am not too familiar with VFP however it looks like you might not have the MSXML4.0 Parser installed. Could you try downloading the parser from http://www.microsoft.com/downloads/details.aspx FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en#filelist and then trying the same operation. Thanks for everyones help. ...Show All

• Yngwie How to access methods of an ActiveX in a .prg

  I have created a Winsock Activex control in a FoxPro 6.0 program, and it works OK, but I don't know how to access the DataArrival function in code. If I was in a form, I'd just double click on the control and it would be there, but since I created it using CreateObject, I don't know how to tie a function to that event. Geoff Callaghan I appreciate the advice, and I'd love to try it, but I'm afraid I'm still floundering here. I'm using foxpro 6.0, which doesn't seem to have a Class Designer...just a Class Browser. Is there maybe an explicit example of this somewhere None of the ones on this site are helpful. I'm still at a loss as to why I should have to add anything. The control itself has ...Show All

• syl74 OLe error code 0x80040154 : class not registered

  i have download a protect applications using dll files. but when i run it into my project above error pop-out. wat i missing if run from prg it works. Thanks in advance. This error indicates that a something (either a DLL or an OCX) has not been entered into the Windows Registry and so it cannot be located there. Presumably this is one (or more) of your downl;oaded DLL files. You need to find which one is causing the error and register it using the Windows REGSVR32 program. YOu can find details of that on the MSDN at http://support.microsoft.com/default.aspx/kb/249873/ ...Show All

• Santiago Ace&amp;#241;olaza Vfp Converting DateTime Problem in MSSql

  Hi *. i have table on MsSqlServer "art" with 2 fields id int, date datetime and when try to put some value into datetime(), MsSql say go away :( mSql = "insert into art (id, date) values (2, '20061103141100')" =sqlExec(nHandle, mSql) Please give me solution for this problem in Vfp. p.s. Don't give me example with store procedure, 'coz i use mssql for storage only. Thx. As always there is at least 3 ways to solve that problem in VFP. My favorite is parameters and VFP does the conversion for you as necessary. ie: mSQL = "insert into art (id, date) values (2, m.myDate)" myDate = {^2006/11/10 03:14:11} && plain VFP datetime SQLExec(m.nHandle, m.mSQL) ...Show All

• ekkapop reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle When you say: >DELETE FROM tabelle_1 WHERE nr IN(SELECT nr FROM this file in the directory) do you mean that nr is part of the filename or text inside the contents of the file You can use ADIR to put the filenames into an array: local cDirectory, arrFiles[1] cDirectory = "c:\temp\" nFiles = adir(arrFiles, cDirectory + "*.*") for nCount = 1 to nFiles     arrFiles[nCount, 1] ...Show All

• vgrigor Cannot find a menu-generation program

  I am currently switching from OS to OS back and forth for a reason that I want to find out the best platform for my apps. It happens ONLY in XP but not in Win2K. While trying "build" to exe/com I get an error that fox cannot find a menu-generation program. The build is aborted. What is it all about What's the program name Thanks. The default program is GenMenu but you'd be better off with the improved replacement (free) GenMenuX (by Andrew McNeill [MVP]): http://fox.wikis.com/wc.dll Fox~GenMenuX http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/0dc945c3-e161-4c3a-8e2c-d82d68f27f94.asp     OK, I found an answer to this one. Ne ...Show All

• Mehmet Metin Altuntas 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. UIEnable might be what you're looking for Could you do what you need to in the Page's Deactivate event Tamar 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 keypres ...Show All

• Darkside Strip HTML out of a memo field

  What is the best way to Strip all HTML out of a memo field I can’t think of a better method than of looping thought every charter copying one at a time but ignoring those between “<” and ”>” . Is there a better way A faster way Thanks, Sammy Do you know anything about what's in there If so, you might be able to use STREXTRACT() to speed things up. Tamar Check ReadyState. ie: tStart = datetime() nMaxWait = 10 do while .ReadyState # 4 and DateTime() - m.tStart < m.nMaxWait enddo if .ReadyState # 4 && failed to load. You can also add a script to handle window.onerror. On occas ...Show All

• zensunni How to change font preview report in FoxPro for Window 2.6?

  Hi all! How to change font preview report in FoxPro for Window 2.6 Thank! You may tray to use: SET PRINTER FONT cFontName [, nFontSize [, nFontCharSet ]] [STYLE cFontStyle ] or if you like to convert report to vfp: http://msdn.microsoft.com/archive/default.asp url=/archive/en-us/dnarfoxgen/html/msdn_movfox.asp ...Show All