Answer Questions

• Arix passing parameters to vfp com servers using createobject

  Is it possible to pass a parameter to a vfp com server using CreateObject("COMServer.Class", eParameter) It seems to me that whatever I pass in eParameter it is always .F. within the INIT method and PCOUNT() always gives 0. Regards Darren Woodford Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk Hi Darren >> Is it possible to pass a parameter to a vfp com ser ...Show All

• Gregory A. Beamer - MVP table buffering mode

  On a statement like this: IF NOT initTableEmpty TABLEUPDATE () ENDIF I get an error: This operation requires table to be opened in buffering mode . SQLBUFFERING is set to ON before the table is opened. It does not help. Actually the error happens once in a while for no reason. I cannot understand what triggers it. Most of the time the statement works. The USE command does seem to have no option for buffering either. Is any h ...Show All

• David Zillner Selecting an object in the "Form Designer - " or "Class Designer - " window

  We are trying to make a new tool for manipulating forms using a tree structure (see http://fox.wikis.com/wc.dll Wiki~ContainerTree  ).  We use aselobj to create an array of objects in the form but only a few control types have a setfocus method.  Foxpro can select all the controls (just try it in the properties window) but how do we do this in our routine   The only way we found is a modified version of Tamar's code using mou ...Show All

• ManasBhardwaj SELECT - SQL executed partically

  I have 11,000 directories in my machine on one partition only (C:). In order to expedite search for file I need (I found MS search engine too slow) I scan all directories once in 10 days and create a table with directory shorthands and a field where extensions of the files located there are stored. Some directories have too many various types of files and I use a memo field to store extensions for them. Thus the primary field has 80 char length ...Show All

• Matti Niskasaari VFP 7.0 and ASP.NET

  Friends, I developed an application with VFP7.0 and ASP.NET . Every thing is going good except one problem. Once in a while application is crashing when I am executing sql statements and it is giving error like "Object Reference not set to an instance of an object". I tested the connection status and it is good. I am thinking that, it is happening due to some Record Locking mechanisms. My application is intranet application. ...Show All

• msheridan newKey() method not found

  I have visited this ng before with great success always getting comprehensive explanations. I started about 3 months ago and was active for about 2-3 weeks. I then switched to C#, C++ and SQL Server and I found the atmosphere in those groups much less hospitable than here. You guys are great. I got my infusion of knowledge at that time that allowed me a jump start. Now I am doing some FoxPro stuff again by necessity. I am trying to implement a M ...Show All

• wscottj New book on VFP's SQL

  I'm pleased to announce the release of my latest book, Taming Visual FoxPro's SQL: Real World Data Solutions for VFP, from Hentzenwerke Publishing. This is an e-book with lots of downloadable code, available at http://www.hentzenwerke.com/catalog/tamingvfpsql.htm. Here's what Whil Hentzen had to say: You know how once in a while you run into a book that grows on you - each time you read it, there seems to be more in there than the last time yo ...Show All

• Anand R 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

• Ahmed Mostafa HOW I CAN DO "WIZARD UPSIZING" FROM THE SOURCE CODE??

  Hi! I have to do an upsizing from a foxpro-database to an sql server, but, I don't want to use the wizard--->upsizing from the menu-bar...I want to do the same things, but from the code! Can you help me Thank you. thank you! But...You hanven't understand good wat I must do... I must using foxpro upsizing for upsize a foxpro database to an sql server (MSDE)...and I must do this thing using foxpro code.. Thank you Let's s ...Show All

• Michael M Singh How to set automatically start project folder?

  Hi! I add a picture, in my project, but, when I change my project directory, or when I rename my folder, fox, asked me if I want to change the home directory of my project! I choose yes, and my project run correctly, but, it can't find my picture! I must write getdir( ) at the beginning, to set my start folder, if I want that the project run correctly with my picture! I try the curdir( ) or the home( ) but, this don't recognize correctly my p ...Show All

• Darkdog Which one is faster, cursors, queries, local views, other?

  Hello, I'm using VFP 7 on a very old machine. I'm working with very large tables and I need to create a lot of queries, but my tables are so large it takes forever to load the results. I've been creating cursors on the run from SELECT statements but it's still very slow.... What can I do to optimize my queries/views so they are much faster... I'm new to this, so I don't know much... I just need to be able to run all this queries ...Show All

• email2venki Day Time Picker little trouble.

  Back in Visual dBase days we used regular spinners for dates but here in Fox the spinners do not seem to like dealing with anything but numeric values. I placed three day/time picker controls on two different containers that are supposed to become visible or invisible depending on some buttons being pressed. I am certain the pickers' parents are the containers however when I make the containers invisible (setting .visible to .F.) the pickers sta ...Show All

• AparnaG MySQL or MS SQL - free database

  Hi. Does anybody know a webhosting provider that gives a SQL or MySQL(rather SQL than MySQL) database for free charge I want it for my own purpose. I found one but it was limited for only one table. I want only one database with few tables. No matter what space limit, may be under 5MB. Thanks. If it's just for testing, can you not just use MSDE (or SQL2005 Express) Both are free and both are freely av ...Show All

• pappascd Report that won't maximize

  I put in my class form the code which will maximize the output of every report I generate. Just only this few days that I notice that some of my reports behave as expected but some report output just pops-up in minize at the above left of my screen. It seems that sometimes it ignore the ctrl+F10. Any other ways to permanently maximize all report output thank you for any help. Madix Thank you very much Mr. Higgin ...Show All

• Fred.Thorel how can i select mutiple the records and highlight them in the grid control?

  can i do that thank you everyone. When you activate the cell the current control for that column is activated, the backcolor now comes from that control and the grids backcolor is not drawn. So... if you want that controls selected color to be the same as the row, you need to set it in an event like gotfocus or when. http://www.universalthread.com/wconnect/wc.dll LevelExtreme~2,2,9703 thank you ver ...Show All