Answer Questions

• Andy Ball Bug in VFP 9? Adding an object to an array with AddObject.

  We have this base class that basically implements a collection (I know there are collections in VFP, but we can't change this overnight). Part of the process is to add an object to an array. This code word flawlessly on VFP6 for years. this.ItemCount = this.ItemCount + 1 Dimension this.Item[this.ItemCount] Local cItemPlace cItemPlace = "Item[" + LTrim(Str(this.ItemCount)) + "]" this.AddObject(cItemPlace, this.ItemClassName, &tInitParame ...Show All

• tri4pro i just wanna do it like this

  can i do that thank you everyone. Multi-select is not directly supported by the grid control. You can add a Logical column to the query that generates the cursor used for the grid, then check the rows that you want to select. 1st you need a way to track what the user has selected.  The easiest way is probably a logical field in the table, or a related table that you can toggle on and off. 2nd you need to put code in the mousedow ...Show All

• Rama Raman 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

• DrP VFP & Pocket PC

  Dear experts, I am working on a restaurant ordering system with VFP+MSDE and looking for the possibility to input order via a mobile device. Is there any tool like VFP for Pocket PC Or any suggestion to which language should I used at the mobile side for a shortest learning curve Someone show me with a terminal client installed on Pocket PC, connect to Small Business Server 2003 and run a VFP exe (re-write with large icon and less color ...Show All

• johnly Sam VFP 9.0 ReportListener creates a PDF page as an image

  Hello, I'm using VFP 9.0 ReportListener object. When I print a report using Acrobat Distiller printer driver, it creates the PDF pages as images. I want the output as it was with the previous versions, text as a text and image as an image. Is there any way to do it Thank you in advance Vedat, Since no one replied to your question yet I can suggest another alternative. I use mindseye's activex for generating re ...Show All

• jsather Excel validation

  Dear experts, For example I export customer.dbf to excel and let user do maintaince in excel then import back to db. However I wanted to add validation in "CustomerType" column to avoid any incorrect type being imported. My program like this : autoExcel = createobject("excel.application") autoExcel.visible = .t. autoWorkbook = autoExcel.Workbooks.Open("c:\customer.xls") autoSheet= autoWorkbook.Worksheets[1 ...Show All

• adi151478 error in sql command

  SET ENGINEBEHAVIOR 70 SELECT lcode, sec ,descr,examcode, sum (tobt) as tobtt,; SUM (tmax) as tmaxt; FROM Examtran; WHERE examcode= thisform . code . value .and. scode>= thisform .shiftfm. value .and. scode<= thisform .shiftto. value ; GROUP BY lcode, sec ; INTO CURSOR tyu brows SELECT lcode, sec ,descr,examcode,tobtt,tmaxt,; TRANSFORM ((tobtt/tmaxt)*100,"##.##") AS PERCENTAGE; FROM tyu; WHERE examcod ...Show All

• theczar sdtFont object

  I need to create a stdFont object. Once at one computer I was able to do it in the command window" X = CREATEOBJECT ("stdFont"). Once I put a period behind "X." the IntelliSense menu appeared and gave me a list of properties. When I tried to use it in a method I got an error message that the " class definition STDFONT was not found ." At another machine I cannot get it to work even in the command window. Which ...Show All

• JoCa Missing records

  I had a strange occurance that left me completely mystified a few weeks ago.  Our server suddenly rebooted in late afternoon one day.  In one key dbf, all of the records added on that day disappeared.  None of the other dbfs in the database were affected nor were any other files or records corrupted in anything else on our system.  I am using VFP 6 and the files are resident on a server running W ...Show All

• Henk v J. Index on Deleted() VS .NOT. Deleted()

  Which is best for performance index on deleted() tag del or index on not deleted() tag notdel Thanks Hi If you're using VFP8 or earlier you have to use the former. From VFP8 help: "Rushmore cannot use an index created with a NOT condition . For example, the following expression can be optimized: INDEX ON DELETED() TAG DEL But this one cann ...Show All

• SamSmithnz Additional fields in table exported to txt

  Hello, I need to output from a VFP 6 table to a text file. When I use "copy to mytext.txt delimited with ," I get an additional field before and after each of the original fields from the table. This means that in my new text file, fields 1,3,4,6,7,9,10,12,13 etc are empty fields that were not present in the table and fields 2,5,8,11,14 etc are the fields with data. Can anyone tell me how to avoid these "extra" field ...Show All

• Ronak Desai only VFP can control VFP

  is there a posibility that we can open a VFP appilication at a remote location without using any 3rd party software like pcanywhere .  Example...I am at the server and want to re-open a VFP client application which is closed by the user at the client PC.  i am using winsock for the communication between my VFP server applic. and VFP client applic.  pc How could we do that Is anybody has an idea ... Because I want m ...Show All

• jfabel - Groupe JCE Inc. 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

• Dan Moreira Trouble with update MS SQL table with an untypical column name.

  I have problem with updating views of SQL server. When I have name of column for e.x. "Name_en-us" VFP translated this to "Named_en_us".  Unfortunately when I try updating,  ODBC returns me an error. Do you have any idea how to tackle this problem You can use angled brackets on untypical column names (and/or column names which are a keyword, contaning a space etc). ie: DBSetProp('myView.name_en_us', ...Show All

• GaryDeMott Number of variables

  When I create a 200 x 200 array dimension MyArray(200,200) no problem, but when I try to create a 400 x 600 array, I get a "Too many variables" message. How could I make my application work Thank you for your help. Michel Cariotis Prior to VFP9 arrays are limited to 65000 elements. You're exceeding the limit. Even in VFP9 I wouldn't trust available memory and keep elements count low. P ...Show All