Answer Questions

• Tamim Sadikali HIDE MENU exposes itself?

  "HIDE MENU _msysmenu" and "DEACTIVATE MENU _msysmenu ... have been failing to keep _msysmenu hidden after certain simple myModal forms are called (via object 'click' methods) The deactivated (or hidden) _msysmenu seems to abruptly issue a "SHOW MENU" (or something) between 'queryunload' and 'destroy' events of those modal forms ... during their release. I've tried "push menu/pop menu", "deactivate/activate menu", and hours of combinations to (smoothly) keep _msysmenu in HIDE mode. Any thoughts Thanks in advance Philip >>Any thoughts If this is the main VFP menu you mean, just use: SET SYSMENU OFF (Hide and Deactivate are for user-defined menu bars - accord ...Show All

• Scott Wickham suggestions for a VFP networked payroll program

  hi! i need suggestions on what should be considered for a VFP payroll system in Windows XP environment. i haven't been programming lately and i would really appreciate what inputs you can give. also, i need solutions on server based databases. You have to be more specific. You mention a server-based DB. That presupposses SQL-Server, SQL-Server Express, MySQL, Oracle or other similar DB. VFP is very capable of handling it in any version (you don't specify). You can take a two-tier approach or better yet, a modular N-Tier design. Are you using any OOP framework (commercial or otherwise) See: http://www.jamesbooth.com/n-tier.htm http://fox.wikis.com/wc.dll Wiki~IntroToNTierDevel ...Show All

• RavenWorks About the median of a grouped frequency distribution

  hi, I have a urgert problem about the median to be solved. I have the table like this age_group frequency cumulative frequency 1 18 18 2 24 42 3 39 81 4 23 104 5 12 116 6 8 124 What program code should I write to get the median Thanks. First of all, thanks Alex But this calculation is for the data is ungrouped. Actually, the age_gp is ordered Let me write the table in the detail age_gp age Low Upper frequency cumulative frequency 1 15-24 15 24 18 18 2 25-34 ...Show All

• Dirk Reske 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 How about putting Go Top after the delete, but before the refresh. This will move the record pointe ...Show All

• mfindlay Problem trying to create an Encryption Library

  I have followed the example for creating a C# Encryption Libary, but receive numerous errors with regard to no overload method ' ' requires 2 arguments, I have verified that my code is exactly as the example provided by microsoft and found no difference. Has anyone ever tried this code and had problems. Is there any other code to create an encryptoin library in C#. I would appreciate any and all assistance. I am responsible for figuring out how to encrypt the connection string for our web config files in Asp.net page. (we dont' have the .net 2.o framework, we are using Visual Studio 2003 with 1.x framework Thanks Heather Are you sure you have not made other changes I haven't method ToBase64CharArray... Where i ...Show All

• IronYuppie Tolbars and forms with PrivateDataSession

  Hi; I have a main toolbar for the application. one of the buttons on the toolbar does this: do frmStatements with customer.CustomerId When I have a form that is open and it has a private data session, clicking the toolbar button causes an error because the toolbar is not aware of the form's data. Can someone point me to the right direction - how the toolbar can see what is the value of certain data in the active form Thx. Tamar; That's what I was planning to do, or to use a public var, but I thought maybe there is a better way. Remember that I may have quite a few forms, and implementing it in every form is not as efficient as having a way to access the data. Any other ideas Is ...Show All

• George2 Help creating a folder!!

  I am trying to create a folder with Visual Fox Pro, using the MD commnad, and i the name of the folder to be the currnet date, anyone has an ideea md date() doens't work lcFolderName = dtoc(date(),1) && or ttoc(datetime(),1) to include time md (m.lcFolderName) You can even do this in one shot: lcFolderName = 'backups\' + dtoc(date(),1) md (m.lcFolderName) Hi, md Command needs a <Cexpr> as Folder name. So try with a char expression so try md dtoc(date()) You can even try mcomm="md "+dtoc(date()) run &mcomm P.S Make sure the date separator is not "/". set it to "-" by set mark to "-" ...Show All

• Mike737Aviator Problem with functions in conversion to vfp6

  I converted an application from FoxPro 2.5 to VFP6 almost everything works fine but I’m having problems with the functions and the variables on some of the prg files with the procedures I had no problem, all I did was Do procedure in “file where procedure is” but I don’t know what to do for the variables and the functions. I tried set procedure for the functions but it didn’t work. I would really appreciate if someone could tell me how to get them to work. There is no magic, the same code *should* run in VFP. Some minor mods will be needed. Without posting the code that does not work we are all in the dark. You'll need to tell us more about the problems you're having. One thing to be ...Show All

• eldiener How to enumerate rows in a grid?

  I have a grid that has an SQL statement as a recordSource. Within that query, one of the columns returned is a key index for that record. I'd like to use the DELETE mark at the leftmost of the grid as sort of a multi-select. A user will "mark" records, then I will perform a process on each of the marked records once a separate button is chosen. My question is, since the grid source is not a table, how do I scan the grid and see the DELETED status of each row In VFP grid source is ALWAYS a table (well it might be a cursor but a cursor is just another table). In other words if you don't dig into differences between them you might simply think a cursor and table as equal (at least would work for y ...Show All

• arse Help with code for updating table on website

  This is the code I am attempting to usw to add/edit date in a free table on my website. It opens the table fine and will display what is already in the table, but any changes I try to make do not arent being saved. I dont get any errors. Any help USE \\www.infotizer.com\lotterydata\NewData.dbf SET SAFETY OFF SELECT NewData INDEX ON state TO IdxState SET SAFETY ON SELECT StateLinks SET ORDER TO STATE && STATE GOTO TOP DO WHILE !EOF('StateLinks') SELECT StateLinks ThisState = ALLTRIM(State) SELECT NewData SET ORDER TO IdxState SEEK ALLTRIM(ThisState) IF FOUND() SELECT NewData SCATTER MEMVAR m.g1date = g1date m.g1name = ALLTRIM(g1name) m.g1num = ALLTRIM(g1num) m.g1b1name = ALLTRIM(g1b1name) m.g1b1num = ALLTRIM ...Show All

• Balsoft FoxPro Downgrade Help

  I recently formatted my pc at work and and to reinstall all of my applications. I tried installing Visual FoxPro 9.0, however it was not working correctly. It kept giving me the error "Cannot locate the Microsoft Visual FoxPro support library." So I uninstalled this, and tried installing Visual FoxPro 8.0. The program now runs fine on it's own, however, whenever I try to run a FoxPro-based application (i.e. Mail Order Manager), I still get the same error. I don't know if the application is still trying to use remnants of FoxPro 9.0, or what. Does anybody know what I can do to fix this Thanks in advance, Steve Running a VFP exe from within IDE is not the same thing as running it from outside. ...Show All

• Mike_in_NC FOXPRO running slow on POS Machine

  Hi guys, Me running Ximeta netdisk RAID 1 on FOXPRO Programming, 2 POS Machine are running slow on the programmed menu buttons. I am linking them to a full mode Switch 10/100 Ethernet. Can anyone help me So what's your take on this Dear Chanmy8, I use embedded pictures for some buttons, thus query was optimized. Norton Antivirus... basically no server as i am saving costing . Just 2 Mirrored NETDISK to do the job. Ravefred . Hi, Try to exclude *.dbf, *.cdx abd *.fpt from scanning or temporary disable anti-virus for testing. HTH Hi, What is the speed to copy few MB files from server to POS machine Is your query optimized Any antivirus installed ...Show All

• Ed Glas - MSFT Foxpro values for Excel constants?

  How can I set the value of the property ActiveSheet.EnableSelection in VFP to the Excel constant "xlUnlockedCells" I cannot find in internet any answer. I tried to set -4142,0,1,2... without luck. More generally, where can I find a constants-list in the web that includes also xlUnlockedCells Here I can't find it: http://fox.wikis.com/wc.dll Wiki~ExcelConstants~VFP Any help is really appreciated, thanks. Your code looks right. I think it is by design. If you have locked/unlocked cells then Excel lets you select cells but you can't edit locked ones. If you don't use locking then it doesn't let you to select any cell. PS: In VFP7 and later: -Open a new code window ( modify command xlco ...Show All

• bDensmore How to have a report not to print certain records at BAND level

  I have a report on a table with materials used for production of an good. I only want to see the materials of a certain 'group' (high cost materials). Is there any way I can add an expression at the band level so only the relevant records are printed. (for instance if cost is > 200) If I can do this at band level, I don't have to add a 'print when' condition in each of the fields in the band. Other problem when I add a 'print when' condition an all fields of a band is that the report still shows a 'blanc space' on the printout; even if the 'remove line if blanc' is set on (on all the fields in the band). Any ideas Thanks, mmm thanks, I'm really new and I'm not sure if I can create a cur ...Show All

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