Answer Questions

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

• vwgolfman Error Loading File - Record Number...

  I have been struggling with this for the better part of this week. When I try and load a form it gives me this error Error loading file - Record number 41. Formset <or one of its members> Parent: Function arguement value, or count is invalid. Looking in the .SCX and the Parent coloumn, the record is an empty memo field. I have very little experience in trying to fix a problem like this and could really use some help. J.Newman ...Show All

• Tom Hall Sql Server and VFP

  Is there an accpect or general way to convert  - using odbc sql sever date fields (which are like timedate ) to vfp fields type date   bob Lee I was more looking for a way to get back a local vfp cursor as a DATE type field in the first place without converting it..  but thanks . Bob Lee You could use a CursorAdapter or Remote View where you can set the data t ...Show All

• moreno1978 define window

  How could we show a define window into a top level form, where-in screen visible is set to FALSE Because I try it, and it doesn't show-up, maybe i got wrong in coding. Thanks for any help Amado Thank you very much, for the help. I will try that You don't want to close myCursor just yet as it will dissappear forever. Remember a cursor is not a real table (DBF) so it will not have persistence on disk to be reopened later. What you do ...Show All

• markdrury MSGraph.Chart.8 control

  I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in ve ...Show All

• bvasanth Another question for the day, Listbox limits

  Hi, sorry for posting two questions in one day. I was wondering if there is an easy way to limit the amount of items in a listbox. For example, i am getting information off of a SQL server and putting the information in the listbox. However, there is a lot of information, and I don't want more than the newest 200. Is there a simple way for me to do this Thanks, again I appreciate it. I have NO idea why I didn't think about it that w ...Show All

• Ivo Becker creating tables programmatically-some questions

  I have decided to create some tables programmatically since they most likely will be used temporarily. I do have a number of questions pertainint to CREATE TABLE paramaters. I could not find any explanations so far to figure out what they meant. First I assumed that CODEPAGE should be 1252 (Windows ANSI). Is it the right choice I want to create tables FROM ARRAY arrName I understand that arrName is a 2-dimensional array with the same numb ...Show All

• motcom feature not found

  This is the fourth inning. I am still struggling with an exec build. No luck so far. Now there is some help in the form of the error reporting authority of the error control. Unfortunately, for some strange reason only a small fraction of runtime errors are in the log file. I cannot understand why. But what I have seen so far is very revealing. The error message is "feature is not available" and the line in the source code is idenfi ...Show All

• kennykaz Foxpro, or Access, or Filemaker?

  I was a professional foxpro programmer 9 years ago, and haven't used it since. I have written some fairly large programs, including my first, which was the tax collection system for Samoa. My last version was the first windows version. Unfortunately, that version, will no longer run on the current XP operating system. I now own a wedding photography business, and need to track leads, and send emails, write invoices, and keep track of servic ...Show All

• bighead 12 hour time format

  Hello, I am doing a program that will compute the time in and time out.  As much as possible I want to do the time() function and not the datetime() function but the problem is if I use time() it displays the 24 hour format.  What I am tasked to do is to subtruct the time out to time in and be able to display the 12 hour format. Any advice will be greatly appreciated. Tamar, Since I also have an in-out tracking system in us ...Show All

• gilabite Encryption Questions

  I have written two Functions one for encryption and one for Decryption (using _crypt.vcx), I would like to encrypt all data in my app . I have a few Questions… 1) When creating my tables what do I use for datatypes 2) What about indexing Do I index on Decypt(field1). 3) What about SQL Do I do Select Decypt(field1), Decypt(field2)… 4) What about select * . Is it supposed to be this big of a pain or am I just going ...Show All

• googleit cumulative column calculation

  Hello, have question about calculations in visual FoxPro. Have a table ID Sk 1 4 2 8 3 9 4 3 and so on… need to calculate cumulative sum in next column like ID Sk Cum 1 4 4 2 8 12 3 9 21 4 3 24 Do you know how to calculate this column It's work, thank you. The easie ...Show All

• Stephen M. Berube createobject("mappoint.application)

  VFP (9.0) I am experimenting with mappoint for a stevedoring company. I am having problems with the Createobject("mappoint.application") When I execute the code I get the error message ‘Class definition MAPPOINT.APPLICATION is not found.” When I search the registry for MAPPOINT.APPLICATION I find nothing In the registry I see all kind of references to MapPoint but nothing to Mappoint.Application the ...Show All

• BE_Jack Main Window Default Size/Location

  I would like to know what determines where the compiled EXE application window opens and what size it is. I would like to have the window: - remember if it was maximized or - remember last size and position Right now it is always starting in the top/left corner and I'm not sure what I did to get it that way. Thanks You mean _screen.autocenter = .T. I'm already doing that in my startup code except I am using _s ...Show All

• etcheverrjc how can i get the current active control's name in a form?

  thank you Jet rgerbig -> Here is a Visual Foxpro forum, not C# ! Hi, try this code in your form: MessageBox .Show( this .ActiveControl.ToString()); i can't find the function of tostring() i can get the name now i used this way _screen.activeform.activecontrol.name Jet Hi Jet, if you don't don't need the name of the control inside a grid you can use code like this to get the name of t ...Show All