Answer Questions

• almir Modifying a MPR file

  Hi, I need help, I have to modifiy a VFP 6.0 application and everytime I edit the MPR file I lose my changes, What I do is open the file, then I change some captions, then I compile the file and that's all. When I build the exe file, all my changes disappeared. What am I doing wrong Could you help me Thanks in advance! The menu designer automatically calls GENMENU.PRG to generate an MPR file for you for ...Show All

• ActivityDeveloper Treeview stops answering

  Hi, all. I'm needing some help with a rather strange problem: I have a form with aTreeview (ActiveX Control) in it. There's a routine that calls another form. Funny thing is: if I trace this routine and form (using the SET STEP ON command) it works perfect. On the other hand, if I run it normally, when I lose the second form, the Treeview stops responding to the mouse, I.E it doesn't scroll or allow the user to click a node. I have no ...Show All

• Bruno Jouhier unresolved issue on DTPicker Control

  I am sorry for doing this but for some reason I could not post any more in that thread. Maybe it has become too long. Although I feel that the discussion should be winding down but I want to thank Craig for his post and I want to say that I will definitely try the code. This is for Marcia: " I am sure that we have provided much entertainment for the onlookers " It is very good, I like it and I can subsribe to this statement . ...Show All

• a developer With ... EndWith

  How does nesting work with With ... EndWith Does VFP work out which object I am referring to if I just enter .cDescription for example Is there a potential for ambiguity if the 2 objects have the same property I would like to use nested With ... EndWith but I am wary of introducing some difficult to find bugs.   CetinBasoz wrote: I prefer to use with ... endwith for maintainability and readability:) ...Show All

• RumWarden How to get the folder name?

  Hi, I would like to ask for a help regarding how to get the name of a certain files or folder from the specified location on the local hard drives. Any commands and sample codes would be greatly appreciated. Thank you. Alfred N. Roa +639196027475 Alfred, Your question is unclear. If you know the specific location then what do you need more I think you're not asking getdir(), getfile(), adir(),fullpath(),justpath() etc. Would you el ...Show All

• Abha Jain Converting FoxPro application to a SQL server backend

  Hi We would like to convert an existing FoxPro application to a SQL database. If possible, we would like to do it in multiple-phases. For example, Is it possible to keep the UI as is and convert the code and the table to SQLin the first phase And for the first phase, we would like to translate the code and the table to SQL. Is this a viable strategy If not, what should we be doing If you're moving to the web, you definately ...Show All

• schmaltzkj VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• RSDuren Converting FoxPro application to a SQL server backend

  Hi We would like to convert an existing FoxPro application to a SQL database. If possible, we would like to do it in multiple-phases. For example, Is it possible to keep the UI as is and convert the code and the table to SQLin the first phase And for the first phase, we would like to translate the code and the table to SQL. Is this a viable strategy If not, what should we be doing You haven't said which version of FoxPro y ...Show All

• Ensynch Foxpro problem I think

  Hi, I have made an program in foxpro wich will archieve mail. what I do is I first export the mail body, sender, etc to text files with vba and than get them back with foxpro, but sometimes the layout changes when I put it back. Has this something to do with that I exprot them to text files or is it something different please help Remember that most email objects used to get email have two Body ...Show All

• xiaomaolover directory list

  i would like to show in a listbox the files of a directory(not all files for example reports only *.frx)and to be able to refresh that.in other programms there are file list boxes components that do this,but i dont seem to find any in vfp.what can i do There's more than one way but the easiest to start would be to change two properties of your List Control: RowSource=".frx" RowSourceType=7   && f ...Show All

• Skaale Spell checking?

  Well, as sort of a follow up, I am using the ActiveX RTF for one of my forms. What I'd like to know if there is a way to do sort of a spell check for what a doctor would type into it. Any one know I want your sample code too. It is a neat idea. Will this method highlight the misspelled words in RTF There is also another option: APSC - All Purpose Spell Checker which is also downloadable: you can find it on the web. It will have to be ...Show All

• Young K Help me to create o column Order

  Hi all, In Visual Foxpro i create a column Order that:      replace all myOrderColumn with recno() |myOrderColumn|                1                2                3        ...Show All

• Icanreadabook Getting the numeric field precision

  I'm using code to extract a table's fields properties and I'm trying to figure how I can grab the precision of a numeric field. The FSIZE() function returns the full field size, how could I pulled what's reserved for after the decimal point: iLg = FSIZE("SomeNumField") if the field is a NUMERIC(10,4) for example, I get 10. How do I get the "4" Thanks in advance, Eric ...Show All

• SharonSalmon Windows Directory

  How can I find the full path of the Windows Directory in VFP No matter what version of Windows I am using and what drive it is installed. For example: Windows 2000/XP/2003 could be C:\WINNT or D:\WINNT_OS or other Windows 9x/NT could be C:\WINDOWS or F:\WINNT or other   Thanks Tomik It was very helpful.   You can use this function : ...Show All

• aka Andr3w Grammenos select with alltrim bug???

  Please try this... CREATE TABLE C:\FOX\TEST (STRNG C(5)) INSERT INTO TEST (STRNG) VALUES ('A ') INSERT INTO TEST (STRNG) VALUES ('AAA') INSERT INTO TEST (STRNG) VALUES ('AA ') INSERT INTO TEST (STRNG) VALUES (' AA') INSERT INTO TEST (STRNG) VALUES ('B ') INSERT INTO TEST (STRNG) VALUES ('AB ') INSERT INTO TEST (STRNG) VALUES ('ABB') INSERT INTO TEST (STRNG) VALUES (' AB') INSERT INTO TEST (STRNG) VALUES ('C ') INSERT ...Show All