Answer Questions

• Steve Nesbitt Getting the current row number in a grid

  Hi, I am using a grid in a form with grid1.AllowCellSelection = .T. The .RowSource of the grid is a table. I need to locate the row of a table when I move back and forth in the grid. I mean when I hold a shift + rt. mouse button down on a particular row of a column I should be able locate that data in the corresponding table linked to the grid. I thought if I have the following code in the grid.AfterRowColChange I can get the row number ...Show All

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

• Mark_A_Polson Grid headers default mouse pointers etc...

  Hi all; I am creating grids in my forms by dropping a table into the form. The default header's mouse icon is a down arrow which misleads the user into thinking that the column can be sorted. Is there a way to change this default so it doesn't have the down arrow Thx. Dave; That goes without saying... But my question is how to make it so I don't need to go over my 45 fields in the grid and d ...Show All

• Koen Vd B can't reindex 82,000 kb file

  Let me begin by thanking you for the help.  I am not a avid foxpro programmer.  I have a table in my database that has been acting up the past few weeks, but usually a reindex would fix the problem.  Today It won't let me reindex.  I type reindex and press enter and instead of getting the counter on the bottom right hand corner.  It does absolutely nothing.  If I delete the .cdx file and try -- still nothing.  ...Show All

• oceanX0 Good references for a beginner?

  I've already done most of the sample walkthroughs and read the documentation that comes with VFP9, however I still feel as if I'm lacking understanding on the bigger picture. Could someone please cite some good reference material for a beginner in both programming and VFP9 Also, when looking for reference materials, how different is VFP9 from VFP8, 7, etc The reason for my asking is that I found some suitable books online but they're written for ...Show All

• Tanya R. - MSFT Oledb driver, length of queries

  well I hope there is a solution to this as for now I can not find one. When I enter a long query in visual foxpro or via driver I get the unexpected phrase/keyword error. Essentially the query is pulling up people by state or county id, so imagine a long query string of cstate='NY' or (cstate='NV' and (icountyid=1039 or icountyid=1718) etc etc, the query is really long when all the most of the states are being used ( if all I optimize it by maki ...Show All

• Brian Merz VFP linked server issue

  We're using SQL Server for the majority of our applications, but our accounting package is still in VFP 8.0.  I need to make some costing adjustements from our inventory program.  I have linked the VFP database to SQL Server just fine and, using OPENQUERY, I can SELECT data without a hitch.  Performing an UPDATE or INSERT, however, is a different story.  I get the following error: "Server: Msg 7301, Level 16, State 2, Line 1 ...Show All

• Elham Dahwa cryptography failure

  I use _cryptapi class of the _CRYPT class library to encrypt limited amount of information: ids and passwords. They are in a table and the table feeds treeview items on demand. Before appearing in treeview the field values are automatically decrypted. Everything has been working fine until I noticed a problem yesterday. I have done most of development on C: drive but recently began moving the whole project to a G: drive since I set a new OS u ...Show All

• Kabouter Use or not BLOB fields with SQL Server

  Hi: We are deciding which would be the better approach for managing a lot of files ( PDF, JPG, DOC, DWG, ETC. ). We are speaking about thousand of files and thousand of megabites. As far as we are developing with VFP 9.0, we would be able to use BLOB fields. But we are not sure if it will be the best choice for us, taking in account, the amount and sizes of the files. Could anyone help us Regards, Ana Madrid, Spain www.amby.net www.PortalFox.c ...Show All

• Dieter De Preester Records Disappear

  I'm using a program called Auto Shop Controller from http://autoshopcontroller.com/ . This program uses Visual FoxPro. For some reason, some records mysteriously disappear. This has been going on for as long as I've been using the program, which is three years. I can't get any help from the program's vendor without paying an exorberant price for an minor update and then even more money for a support agreement. Even with that, they don't guarante ...Show All

• Francesco_84 Help With Dynamic Forms

  Hello there; My Problem is : I want to create a form without determine to control source for each field. why, because i want to create it with the SQL statment such as : select no,name,age,id,address from perone; after run the sql statment i want to determine to result to the fields. can i do that plz help me The easiest way is to just use a grid. You could bind a grid at runtime sett ...Show All

• Anonymous4200 similiar fields

  Hi I'm trying to cross reference records from two different databases by first and last name. I can pull most the records (about 1500 out of 1700) on straight forward comparison of (a.firstname = b.firstname) and (a.lastname=b.lastname) as for the rest, is there a way to check if one name is similiar to another (in case of a typo, or mis-spelling of the name) Thanks, Mike Hi ...Show All

• Roberto Barrantes RSA Public/Private Key Encryption in VFP 9.0

  Hi, I need to be able to decrypt data pulled from a MySQL table encrypted with RSA public/private key encryption within a FoxPro application.  I am currently using the FoxPro Foundation Class known as _cryptapi as a wrapper to the CryptoAPI interface.  The problem I'm having is that I can't seem to figure out how to decrypt a RSA encrypted string of data.  I know that the _cryptapi class provided by Microsoft uses the Microsoft B ...Show All

• Mark Naughton Total amount column of my grid

  I would like to interactively show the user that while the AMOUNT column is entered with data I would like to show it to the top the total amount when edited it will also change the total amount. Yes, that solves the prob. Thanks again Public oForm oForm = Createobject("myForm") oForm.Show Define Class myForm As Form   DataSession = 2   Top = 0   Left = 0   Height = 398   Width = 426   DoCreate = .T. &n ...Show All

• Christian Wade exe is not a Visual Foxpro .Exe file

  Dear Experts   Now, this time I am facing the greatest problem of my life about vfp and my future.   For the last about three years all of my softwares were runing properly but unfortunately from the last month I am facing these error messages   1- D:\ginning\accounts.exe is not a Visual Foxpro .Exe file 2- File D:\ginning\accounts.exe is not object file   I raise following steps to solve this problem. ...Show All