Answer Questions

• mukul narad cursorschema property limitation problem

  Hi All, Am migrating a VFP app from DBF to SQL Server database and am using cursoradapters for that. I have a table that has many fields and when I create a cursoradapter for it, when I try to save, I get the error message "The CursorSchema property must be no longer than 255 characters". Most of my tables will generate schemas of characters > 255. What is the best workaround for this I don't want to imagine splitting all the tables into smal ...Show All

• Jack Burton DO FORM does not work in exec (for me)

  I have close to 50 clauses, it turns out, DO FORM in my application. They all work perfectly well in interactive mode with the browser but do not work at all in exec after I built it. By "do not work" I mean that I do not even get an error message. Those statements are completely ignored. What I've done so far is trying to find a formula under which I could call outside forms. As I mentioned, when a statement DO FORM <formName> ...Show All

• Tom ODonnell MSCharts.ocx

  I downloaded from http://www.ml-consult.demon.co.uk/simplechart.zip  the class charts.vcx. This class is based on Microsoft's MSChart ActiveX control  (MSChrt20.Ocx) if you MODIFY CLASS simplechart of <charts.vcx> and Right click on it you will see MSCharts properties option. I want to open that Dialog (MSCharts Properties) in Run-time from an application. I wonder if that is possible and how can I do it ...Show All

• buguyaga how to change field values?

  I am looking for a way to address fields to change their values. I cannot understand how it can be done in VFP. For instance, if I use two statements which open a database table with a few fields in it, what do I do next USE DatabaseVfp1 tcp_ip IN 0 as cTableAlias SELECT ALL FROM cTableAlias cTableAlias.fieldName1 - what does this expression give me Is it the field value or just a field name Can I write: cTableAlias.fieldName1 = ...Show All

• Wojteq Quit

  hi, i have a main.prg that runs the form where the users are goin to login, this is the code of the main.prg: CLOSE ALL CLEAR ALL SET DEFAULT TO c:\payroll SET SAFETY OFF SET CENTURY ON SET DELETED ON SET TALK OFF SET CONFIRM OFF SET SYSMENU off _screen.windowstate = 2 _screen.caption = "Payroll System" _screen.Icon = 'C:\PAYROLL\BMP\GRAPH12.ICO' _screen.Closable = .f. do form frmlogin do menu.mnx READ events after ru ...Show All

• Carlo Cantoni remote data

  I want to create a system with 1 database and many users that can access it a solution is the server client model ok lets say we have a database in a remote server(vfp database) i go to each client and make a datasource and a connection to that database 1)the tables of that database will ONLY be viewed by clients through remote views 2)if yes ,i will put the views in the data enviroment 3)if yes,i can insert,delete,update,buffer...etc the views ...Show All

• MdAZ How to read in sequence a lot of combo box?

  can I read in sequence (with a FOR cicle, or something similar) the list index, of a lot of combo box and, can I associate a combo box with a txt box For example...I have 3 combo and 3 txt....if i selected something on combo 1 read the txt, otherwise no...and the same for the other txt Can I do that in automatic with a for cicle If you don't understand, what I asked you, please tell me! Yes you can read in sequence. ie: local ix a ...Show All

• Chris I 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

• MightnMagic Median

  Hi all, I have a simple table with ages listed (called c_age). Does one know how to find the median of these ages Does VFP have a built in Median() function Mike Tomik, Reading your response, and need further clarification. Why do you have logic to calculate the median value of the array has not data (IF MOD(nCount,2) = 0) Also, can you explain what is happening when you are creating the variables nLo and nUp Thanks. GR1206 ...Show All

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

• Sajid Saeed return from a form.

  Still struggling to communicate with some of my secondary forms. This problem, again, happens only in StartMode = 4. Everything is fine interactively. LOCAL cUserReturn AS String DO FORM <formName> WITH par1, par2 TO cUserReturn. I get an error message that there is operand/operator type mismatch. I tried to define cUserReturn as Variant - the same thing. The expected type of return is String . According to the Help FoxPro is s ...Show All

• ChrisCow Primary key + delete....

  General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if h ...Show All

• kimo InteractiveChange

  I have a combo box with a list and a text box with a discription on a form.  In the combo box's InteractiveChange I have added THISFORM.REFRESH When I run the form and select something from the combo it does change it in the textbox but nothing is displayed in the combo box anymore and it won't let me reselect anything else "set step on" stops the program execution so you can trace it. Once the progra ...Show All

• rickyTH How to upgrade a menu from FoxPro for DOS

  I'm a very old, retired, CCOBOL and ASSEMBLY programmer with some experience with dBase and FoxPro from the command window. A charity has asked me to get an old FoxPro for DOS program working on a donated used computer which contains VFP6.0. I have gone over the data files and they seem to be OK. The indexes have been converted to CDX type and that works. The old DOS program worked by relying on append and browse commands which all work. The nee ...Show All

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