Answer Questions

• suryavbnet2005 Grid and textbox Refresh issue.

  I'm having this problem with an application I’m writing. I have a Grid with a couple of text boxes next to it. When you select a record it updates the values in the textboxes with the values from that record. I also have a few command buttons that switch the tables viewed in the grid. Now here’s my problem... The text boxes stop updating after I change the tables a few times. Not sure what I am missing because I don't get any error messages and it does work for a little while. If you need more information let me know. You need to use a safe select method to change data in a grid on the fly. See www.tightlinecomputers.com they have a complete listing of what this entails. If you're changing like this, instea ...Show All

• Cika Deleting records

  Hi, I need to delete some records from a table that has the same values for some attributes. Some attributes are part of the primary key while others not. Thanks, You may try to use: DELETE [ Scope ] [FOR lExpression1 ] [WHILE lExpression2 ] [IN nWorkArea | cTableAlias ] [NOOPTIMIZE] You may include as manny atributtes after "FOR" OR after "WHILE": DELE ALL FOR h=>1 .AND. z="HHH".... I am sorry, but you are not giving us enough information here. How is this delete to be done In an application, or in development environment . Is this a one-off operation, or is it something you will have to run again and again Basically it sounds like you need t ...Show All

• auradog Error 2091- Table corrupted.

  When opening a table that exists in a project I got the following message- Repair the table using an appropriate third-party repair utility for Visual FoxPro tables before opening the table again. What does this mean & how do I find a third-party repair utility   Thanks!!!   Alex Feldstein wrote: SharathMum wrote: SET TABLEVALIDATE TO 0 (zero) this will solve the problem for detail refer VFP9 help SET TABLE VALIDATE TO 0 does not "solve" the problem. All it does is mask it. VFP 9.0 is does stricter checkings and finds things that were wrong but not caught by the parser before. Even though it gets you going for the moment, it does not fix the problem, just hides it ...Show All

• Lee boon gan Tile Windows (Vertically) on DESKTOP Programmatically?

  Dear VFP Masters, I'm searching a way to (programmatically) (1) TILE My.Exe with other Window’s windows ... and/or (2) ‘ARRANGE-ALL’ on Window's desktop (VFP-9) ... if that is possible. Thanks in advance for any thought in this matter. CetinBasoz wrote: You could do it with winAPI. BUT you shouldn't. Check on a related message titled similar to "changing backcolor of dekstop". Users can do that themselves rightclicking on taskbar if they ever wanted to do. Thank you for your thoughtful reply... I studied that message a couple threads back. I was also interested in (2) 'Arrange-All' which seems peculiar to FoxPro ... if that might be viable for the window's desktop. Saving keystrokes, clicks, ...Show All

• mafc 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. Hi, If your memo field value length not more than 255 characters, you can SELECT order_no,order_date,prdcode,order_qty, LEFT(remark, 255) as remark ; FROM mytable INTO CURSOR mycursor COP ...Show All

• Giftednewt Accessing VFP 8 through C# and ODBC

  Our company has an online product ordering program that accesses our VFP 8 accounting package through an ODBC connection on our server. Occasionally, our system error log table will trap the following error: "ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]This file is incompatible with the current version of Visual FoxPro. Run 30UPDATE.PRG to update the file to the current version. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr)." All the offending lines are doing are forming a SELECT statement: OdbcConnection ODBCConn = null ; O ...Show All

• Can-Ann Using database in network

  I've build a database program with Visual Foxpro, and use Visual Foxpro database/table. Example : Select 1 use c:\data\table1 But sometimes my database/table located at server drive (my network place). So I typed, for example : Select 1 use \\server\data\table1 It doesn't work properly, because Visual Foxpro cannot recognize the network drive. How to solve this problem ....thank's....... The syntax you used should work. What exactly does VFP say when you issue the USE command You may try to map network drive(ex. X): SELECT 1 use X: \data\table1 Nothing wrong with the syntax. Simple and maybe obvious questions: Is there a share in the server folder Does the program (or you) have enou ...Show All

• gfe Launching Adobe Reader Programatically

  Is there a way to launch Adobe Reader with a file name from within VFP90   I want my users to be able to print PDF files without having to search for the files - the search would be done through the GUI. Thank you, Unless you have PDF files with special features such as DRM, encryption, and the like, you could also try a different PDF viewer. Aside from being smaller and loading much faster, the FoxIt PDF reader has a cute name, too. <g> (http://www.foxitsoftware.com/pdf/rd_intro.php) To install the reader you can copy it into your applications directory and call it using the _ShellExecute class in the FoxPro Foundation Classes. CLEAR ALL CLOSE ALL RELEASE ALL CLEAR qpdffile = GETFILE ("PDF& ...Show All

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

• Theoblob Creating an exe from the Control Panel

  Hello, I have finished my firs application and I have troubles with generating an exe to be installed in the customer’s PC. I’ve accomplished all the requirements seemingly for example to copy the dll that indicates the help of VFP, in same the directory where the application is executed, and to start up from an initial program that after calling to the form from this program, I`ve addedd the sentence of READ EVENTS at the end, I execute It and can’t see anything. The exe run like a process in memory (I do check it with the task Administrator of Windows XP). If I have an open sesion of VFP, it works, but if I close it, It does not (AND the client doesn't have installed VFP) Thank you for your support Regards, Alberto ...Show All

• game_boy Error loading

  Hi al; I have an application installed on site which is using vfp runtime. Often we get the following error: Error#2005, Error loading file - record number 29. frmCustService01 <or one of its members>. Loading form or the data environment : File is in use by another user. I have no clue how to try and figure out which file in use is causing the problem, or exactly where in the code the error is being generated. Record#29 - is this the record # in the scx file How can I figure out what exactly is causing this Any good ideas Thanks so much. " ... or one of its members". Check those with lower(baseclass) = "cursor" and code in methods (proce ...Show All

• Sameer Bhatnagar Transactions, buffering questions...

  Hi all! I do have a code were I open a table, store it on a cursor like: select name,surname,address from myTable into cursor myCursor readWrite and I display it on a grid. Then what I do is to let the user select a record, click on an " EDIT " button and edit the specific record (on another form), and after he clicks on a " SAVE " button to commit the changes to the table. So far everything is fine! My main problem/question is that I need this software to be a multiuser application and run over a LAN. So all the tables are shared (so the database is) and I try to use BEGIN TRANSACTION , END TRANSACTION and ROLLBACK commands. But suppose I have 2 users, user A and user B. If user A and user B are both viewin ...Show All

• Vaish 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. For VFP-6/7 www.hentzenwerke.com 'KiloFox','MegaFox' (Akins,Kramek,Schummer), and 'HackFox7' (Tamar E Granor et al) seem "best practices" despite a few obsolete chapters ... (A.K.A., 'twould be too-nice if they were re-edited for VFP-9) Also, forums with compassionate fox-gurus have helped my "best practices" not a little. ...and if I will need to use read events later for other reason, what should I do Write a new code for read events Why lose resources when I ca ...Show All

• BrianYDP How to selectonentry an edit box in a grid.

  Hi; I have a grid with 2 columns: a txtbox and an edtbox. For some reason the edtbox won't SelectOnEntry no matter what I do. I've tried to set selectonentry for the column and the control itself. I've set the format to "K" I've set DynamicInputMask to "K" highlight is .T. Nothing works. Any ideas Nope, sorry. However, I am not sure that I understand what you are trying to achieve here. I don't see how you CAN select all text except in the one row that actually has focus.... >> No. All I'm trying to do is to selectonentry the memo field which the user tabs into. But in the process, I don't want all the other rows to show 'memo' as the ...Show All

• Max Carpenter 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 Try putting thisform.resfresh() after the delete command and see what happens. Greg Gum ...Show All