Answer Questions

• Matthew Bailey vfp online?

  ok well i found a potential client but he needs an online application...... what should i do about this i know vfp pretty well and the only thing i can do online is save/update records in a file using php and my sql..... is there anyway to incorporate vfp to an online application Try: www.foxweb.com That would be options (b) or (c) above. Look at the articles indicated above, for building distributed applications that access the web through HTTP. i need to retrieve and update information in a table that is on my server. i have 2 people at 2 different locations and i want them to have access to the same data. ...Show All

• tomc1 convert text files to certain format

  Hi there, I would like to convert the text file to a text file but with "" and ; to separate the data. How could I do that Pls advice whether foxpro itself can do that or need to convert it to dbf in order to get the format. Need urgent help. Thanks. Dave Delgado pls note COPY TO command Creates a new file from the contents of the Table not from a Text file what espirit wants to do is convert from a Text file to another Text file with delimited with " and ,   espirit wrote: I have a file as below format. EQ0003929307:18:22M01208162520NLR105.5 904 NL0004 000000.0010/07/06 I would like to change it to e.g.: "1234","abc","xyz" format. How could I do that for ...Show All

• zinc Visual foxpro 9 watch hang

  I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and I deleted all the directory from program file . I reinstald Visual FoxPro 9 and the same think happends. I posted a screen copy of the event to www.bluejeans.lx.ro if you want to see it. What can I do    In the watch window I tested this UPPER ( ALLTRIM ( INPUTBOX (DVDLOGIN_LOC,DVDLOGINCAP_LOC))) it permanently genereit an ...Show All

• MagedSalah Error 1440 in visual foxpro 7.0

  I have an application developed with visual fox pro 7.0. When the users click in any control, the error 1440 appears: "Ole exception error". But the error is not related with the application itself, because it runs well in some computers. I think some configuration or library generates this error, someone has an idea of how to solve this problem Thanks, You may check: http://msdn.microsoft.com/library/default.asp url=/library/en-us/fox7help/html/err1440.asp Probably on those computers you're using an older version of your COM server (whatever it's). ...Show All

• jk_uk2 Philadelphia VFP User Group--January 10, 2007

  The Philadelphia Visual FoxPro user group will meet Wednesday, January 10 at 7 PM. Location: Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025. As usual, you can bring a dinner and arrive as early as 6:30. Speaker: Tamar E. Granor Tamar E. Granor, Ph.D. (Tamar Granor), is the owner of Tomorrow's Solutions, LLC. She has developed and enhanced numerous Visual FoxPro applications for businesses and other organizations. She currently focuses on working with other developers through consulting and subcontracting. Tamar served as Editor of FoxPro Advisor magazine from 1994 to 2000. She is the magazine's Technical Editor and co-author of the popular Advisor Answers column. Tamar is author or co-author of nine books ...Show All

• Ram Babu command window always on top

  Hi, I am trying to figure this out for over an hour without much luck. When I open a table and browse it, the command window always stays in front. How can I get it to go to the back so it won't be in the way Thanks, Mark Thanks, it worked like a charm Right-click on the title bar of the Command window and uncheck Dockable. ...Show All

• Nathanael4499 Email from Visual Foxpro 9.0 with Lotus Notes

  We were using EReports which allowed us to email from Foxpro. Due to server changes for spam filtering, the product does not work anymore. We can email within the our facility but not to outside vendors. Is there a way to create and send the email using CREATEOBJECT() [like we do for opening Excel files] without Notes actually opening up. Thanks for any help! Paul At the FoxWiki, see the section that starts off with the line of code reading: DEFINE CLASS cusNotesAutomation AS CUSTOM Methods To Send Report By Email http://fox.wikis.com/wc.dll Wiki~MethodsToSendReportByEmail~VFP You may send e-mail with outlook: emailapp=CreateObject("Outlook. ...Show All

• FrenchiInLA Problem retrieving the dates

  hi. I’m trying to retrieve the dates from the Option 5. When clicking on the Proceed command button to send to the report, nothing on the report designer to be displayed. Wondering whether I get the coding “report form…… preview” right. On this form Sort By: Option 5: Date Posted from <date1> to <date2> Proceed Command Button * date1 and date2 are textbox field. In Init procedure of the Form With thisform .date1.value = date() .date2.value = date() endwith In Click procedure of cmdproceed (command button) Select atnrepair do case case .opps1.value = 5 set order to tnrepaire endc ...Show All

• Praveen_wm move question

  Hi again, I want to know if there is a function or command to move a file in visual fox pro 7. For example, if i want to move 'c:\users\pru.dbf' to c:\myapplicaction\pru.dbf. Thanks, As has already been posted, there is nothing native to VFP to get a move done in one fell swoop. But, there always is the use of the Windows API to do a move, if you must go in that direction. MoveFile http://www.news2news.com/vfp/ group=27&function=20 The MoveFile function moves an existing file or a directory, including its children. Actually there is, as I mentioned above: RENAME FileName1 TO FileName2 but it is a little tricky and you have to check (mainly with tr ...Show All

• Petchey Guidance Required for VFP - MSSQL upgradation...

  Hi all,         I've developed a VFP application in vers. 6.0. Now that the client wants the same with MS SQL / Oracle. Please someone tell me the list of atricles and other notes i've to go through..... I'm ok with SQL querries.... Please suggest me regarding the -Remote views, SPT's...... The application as a whole has about 2 GB of data in VFP..... It's a multi-user application....running on VFP 6.0 ./ WIn2000 Platform.  Thanks in advance... -Markish Andy Kramek has developed some excellent data access classes. You can get them at http://www.tightlinecomputers.com/Downloads.htm If it's possible upgrade to VFP9. VFP9 has cursoradapter class which makes it much easier ...Show All

• Pikachelsea database question

  Hi again, I want to know if there is a command or a function that let me know if a fox table exists or not. Thanks, To add to dni's answer, FILE() checks for the existence of any file. You must supply the full name.ext and if it is not in the current path, you must supply the pathname too. Another complementary function for tables is to see if the table is in use in another area in your program: IF USED("myTableAlias") * it's open ENDIF Note that in this case it does not look for a file on disk (path\file.ext) but a table alias open in memory. FILE() IF FILE( 'foxuser.dbf' ) WAIT WINDOW 'Visual FoxPro resource file present' ...Show All

• Synced HUGE problem with the Container Control (?)

  In VFP9: I have a Form, that has a Container, that holds a Listbox The Listbox has some items in it. Now, if you try to click on an Item, hold the mouse clicked and drag it up and down, the selected item does not change, it just blocks there. When you release the mouse and click on another item, you now have TWO selected items in the Listbox. That is not normal. A Listbox outside a container works just fine. Has anyone been able to solve this Thanks. Is property MultiSelect .T. What are selected for RowSource and RowSourceType > just trying to get someone to answer thouroughly I can assure you that this forum is crammed with experts, for whom, if you could afford to engage them professionall ...Show All

• Corby111 Foxpro Power!

  Hai Everybody, I jus wanted to have some sort of opinion poll from u people. IS FOXPRO ONE OF THE POWERFUL TOOL AVAILABLE NOW In my opinion its really powerful and very much useful even now i am very much found of it.... I'm a solo podiatrist-programmer who has used VFP since its implementation in 1992 or so. Laws change fast and require RAD changes that only VFP9 programming overcomes (for the solo-me, as such). I have no doubt that my VFP9 podiatry-apps are the best out there. Corporates don't specialize in small sector niches. For small business, physicians, niche-programmers , etc. I'd probably still recommend VFP as the only RAD progamming tool for the next 10 years (the life-expectancy of Vista ). Honestly, I feel sorry ...Show All

• umuayo VFP and Word Merge

  I am adding word automation to our VFP application. I like the ease of use of Bookmarks and have no problems navigating thru a document that has existing bookmarks. My problem is that users will need to create new documents and add bookmarks into the appropriate places of the new documentation. How do I provide the user with a pick list that will allow them to insert the available bookmarks. Is this a good approach for a mail merge or have people been using word fields Stuart Bookmarks,form fields,merge fields,document variables etc all have places in automation. I'm not sure what you mean but if you mean mail merge then easiest way is to create a tab delimited txt file and make that source of mail m ...Show All

• Ido Ran Using Visual FoxPro functions

  I'm working with Visual FoxPro 6.01 odbc driver in c++, trying to use function such as "USE" or "SYS" etc... I dont understand how to use those functions should it be used as a paramter to the function s QLExecDirect or some other function Or is it a normal function and if so what .h file i should include thanks ishay You may check: http://msdn.microsoft.com/library/default.asp url=/library/en-us/odbc/htm/odbcsqlexecdirect.asp Thanks for all the great help USE is not a function but a command in VFP, which you may not call from an ODBC link. You may call a series of functions (but not all) via ODBC. I don't think sys() would be a supp ...Show All