Answer Questions

• Eric White King Can't rebuild project after moving from VFP7 to VFP9

  I have several large projects that I developed in VFP7 under Windows 2000 server. I have copied them entire to a new server and I'm trying to convert them to VFP9 to run under SQL 2005. When I open the projects in VFP9 and try to rebuild them I get an error that the project's memo file is missing or invalid. The same projects rebuild under VFP 7 just fine. Does anyone know a workaround or am I going to have to rebuild the entire projects under VFP9 Thanks, Chandler Do the copy again from 2000 after disabling write behind cache. I think this can be changed from Control panel>System>harware>hdd driver properties but I don't trust in solutions who ar ...Show All

• Joe H How to check a customized class property?

  I tried to find the value of a class property that was created by the previous programmer. But I did not succeed. How can I do that   Oooops, I found the value in the Property screen . Thank you for looking! (..) Amazing how often one finds the answer 3 seconds after hitting the 'Post' button I'll flag this thread as closed then ...Show All

• cikitani 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. I try Hide Window "Microsoft Visual FoxPro" and application.visible=.F. When I click the execute, it just flash and the window form does not come out. I set the window form properties as follows: WindowType=1 (Modal) ShowWindow=2 (As Top Level Form) Thanks. Joe. >> Why not use formset Why not try It exists. Because formsets were designed, and intended, for backward compatibility with FoxPro 2.6W "Screen Sets" and provi ...Show All

• Andrea Williams extract data

  Hi, i have some dbf file which are I dont know their content. I try to import data to access but give me error. I search lot but cannot find a solution. Finally i try to open connection foxpro dbf file using java jdbc.odbc, connection is ok. But the problem is i dont know internals of this dbf file, which columns they have etc... Also i dont know about dbf files. Are dbf files normal databases, i mean they contains tables, tables contains columns etc. My question is which queries do i have to use to learn internals of this file. By this way i can import data to a text file , maybe. Thnx. Connecting with ODBC driver doesn't mean you could query the tables. Use VFPOLEDB driver instead. What error you get f ...Show All

• Matt84 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. >> 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. And the answer, as I have told you at least twice, is that My SQL is used by thousands of people all over the world and speed does NOT seem to be an issue for any of them. I am sorry but I do not NOT use MySQL (I have enough problems dealing with SQL Server 2000, SQL Server 2005 and Oracle ...Show All

• Kouroshd SCATTER/GATHER

  Hou can I "scatter" in a method (valid) and "gather" in other method(click).My vf.7 is forgetting all "m." variables between methods. Thanks, Daniel thisform.addproperty("oRecord") scatter name thisform.oRecord memo However check buffering. In VFP you might do such things w/o scatter/gather. The ideea is: I like to do gather in other method (for example a click method(when I press a save button)).I don't know to create a table using "SELECT"!! .I am working with tables. I have very much operations between fields to use buffering and too manny databases opened. suppose if u have a table name,add1,add2,city ...Show All

• 22Pom convert memo field and contents to text file

  Hi, I have a table order.dbf in visual foxpro which contains of memo field. My table is as below:- order_no order_date prdcode order_qty remark B00000001 26/07/2006 2020173 10.0 memo When I double click the memo I'll be able to see the details. Eg. order has been cancelled. I would like to convert all the table information including order has been cancelled to text format with a specific alignment. I'm beginner user of visual foxpro. Kindly advice how to do that. Thank you. >>Sorry I don't really understand coz I'm just a beginner user of Visual Foxpro Then I am sorry, but I can't help you much. I cannot possibly write the code for you.  I am ...Show All

• J. Wind report tool bar

  After a report is generated and appears in a preview you get a small toolbar that floats undecked in full view of the info that you try to read. It was an annoyance until I had only 1 page in the report and once I moved the bar down the report page and believe it or not it DISAPPEARED behind the frame's lower edge. It was not a big alarm for me then since I had only one page but now I have many and the only way to flip pages as I can see is to get the toolbar back. I cannot possibly retreive it no matter what I try. When I moved the toolbar down I hoped that it would deck somewhere and become available as part of the frame but it is not what actually happened. The toolbar disappeared at design stage but the same form's report appe ...Show All

• mistry_bhavin Using a dial-up modem to communicate

  Hi All, We are developing a systems functions test program which is periodically checking our file servers, ftp servers, databases, etc. and sending e-mails / messages to our Systems Administrator's cell phone if any of them fails. We see that if our e-mail server is down we can't send out warning e-mails. That's why we have a PC with an internal modem which will operate parallel with our test program and communicate with our Administrator if our email server is also down. 1. I appreciate, if I can get any information, sample code or a link to download an API. 2. Is it possible to play a recorded message after the connection is established, If so how We are using VFP 8.0 on W2K Client/Server. Hopefully everything is clear enough. Thank yo ...Show All

• vandewst Trouble with Create View.

  I am having a real hard time with a sql query becuase of a VERY poorly designed foxpro system. I have tried to run multiple renditions of select from where this and that OR this2 and that but can't seem to get it to work. Inststead i have decided to try and create a VIEW. I am not sure want ver. of VFP i am even using. but here goes nothing. below is the code that i would hope could create this VIEW. Any help is EXTREMEly appreciated. dim RS, SQL set RS = Server.CreateObject("ADODB.Recordset") SQL = " CREATE VIEW all_bidders AS " SQL = SQL & " SELECT * FROM a_bidder, a_absbid" SQL = SQL & " WHERE a_absbid.paddle_num = a_bidder.paddle_num AND a_absbid.salenum = a_bid ...Show All

• Mable Help with expression (one more time...)?

  Hello All...many thanks to all who helped with my previous post. I have hit one more 'snag' in preparing my data. Here's a sample of three fields in my table... MRC REQUIRED DETAILS 4720-00-001-0057 ADLF HOSE OR TUBING SPEC/STD DATA MIL MIL-H-5593,SIZE 4 SPECIFICATION ADJM INNER CONVEYING TUBE MATERIAL RUBBER, SYNTHETIC MEDA MEDIA FOR WHICH DESIGNED AIR CRWL INSIDE SURFACE CONDITION SMOOTH CQCS LAYER COMPOSITION AND LOCATION 1ST LAYER ANY ACCEPTABLE CQCS OUTER LAYER MOLDED RUBBER CRJM OUTER COVERING ENVIRONMENTAL ABRASION RESISTANT AND PROTECTION CRJM ...Show All

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

• John Portnov Memo field conversion

  I am using a Microsoft ODBC Driver to connect to 4 DBF files . One of them has Memo Fields in it and I am not able to see this particular table when I try to import it in Access. All the others I am able to see and they do not have memo fields. Any idea guys How I can fix this use the foxpro report writer to output the dbf to a text file. once u have a text file u can open in excel or import it to access. create report <filename> pull all the fields including memo field in ur detail line sele stretch vertically for memo field repo form <reprot file name> to abc.txt now u can import abc.txt Deepak Patil wrote: I am using a Microsoft ODBC Driver to conn ...Show All

• DannoCoy Picture position in command button

  In VFP9, I have just put my first picture on a command button. For "Picture position", I have "13 - Above caption, centered with caption along bottom (Default)". For caption "Alignment", I have "9 - Bottom Center." However, the caption does not align center, it aligns left,, the same as "7 - Bottom left". Is this a know glitch in VFP9 Hans L OK, bye.     Don, I am leaving this forum because of its terrible UI and behavior in general. Regards, Hans L I will check later today and get back with the info. I have used both an ico and a bmp, and in the bmp case, the text went under the icon correctly when I used Alignment 2 (default). More details la ...Show All

• JonH66 Selecting specific column from active row in a grid

  I have a grid that is "read only" and does not "allow cell selection". When the user clicks on an entry displayed in the grid, then that row is highlighted. The information I would like to retrieve based on the row the user selects is in column1 of this grid. I have found that unless the user clicks on the cell in the column of the active row, then I cannot determine its value. As a result I keep getting the value for Column1, Row1 instead of the row the user selected. Currently the code I am using to retrieve this value is: THISFORM.Grid1.Column1.Text1.value and this returns the text located in column1 of whichever row the user clicked on (assuming they click on column1). So basically if they click on Column5, ...Show All