Answer Questions

• johnconway26 combobox problem

  I would like my combobox to look like the combobox of ACCESS where I could reduce the size of the first column to 0 so it will only show the second column. Like the zipcode(the 1st column) and the description or place (the 2nd column). I would show the description but internally I am storing only the zipcode but as a user one would only see the description. Hope you could help me again, thanks. Is there a workaround so it won't ...Show All

• Derek Newkirk View, Query or Cursor?

  I have a form that pulls info from an ODBC source via a Remote View. When I try to RUN my form, my entire project locks up. Is this because the info pulling from ODBC is too large How can I fix this Any ideas Should I use a cursor instead of a remote view Or unselect fields in the Update fields selection There is a connection overhead. Past that the amount data comes into play. You should create parame ...Show All

• Fred Liang read from a file

  Hi. I'm pretty new to fox so bare with me plz. I want to read info from a txt file, but need to know how to go to the next line once each line has been read. Thanks. J lcText=filetostr(yourfile) lcLine1=mline(lcText,1) lcLine2=mline(lcText,2) There are n ways to do that in foxpro. One way is to parse lines into an array. ie: local array laLines[1] alines( laLines, Fil ...Show All

• JuanManuelC An icon instead a 'Memo' in grids.

  Hi All; Is there a way to have a grid display an icon instead of memo or Memo for memo fields I'd like to put an icon if the memo field is not empty. Thanks, Aleniko Change the default txtBox control in the column to an image control. What I sometimes do instead is to use a button (cmdBox) that says "Notes" as caption. It looks better than the word "Memo" and when you click on it a child form o ...Show All

• granny8 Reading binary data

  Dear all, I want to read binary data from a FoxPro database. The data in the table contains a MS Word document. I don't have clue how to do this. I tried to read the data in a string but only the first 8 characters are returned. When I try to store the data in a byte array I got a InvalidCastException. When reading a datafield which contains plain text everything works fine. I use Visual Studio .NET 2005 with C#. My Code: sQueryDoc + ...Show All

• Lakshmi Kiranmayi 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

• oufan222 Programatically Placing Controls on a Form

  A table's fields are: Text, XformCoordinate, YformCoordinate. What would be an efficient way to  process the  records , placing a label for each record at the form coordinates specified in the record with the label's caption equal to the text field in the record. Thanks, Joe Laden (an old Clipper programmer) scan lcLabelName = 'lbl' + padl(recno(),3,'0') oForm.NewObject(m.lcLabelName,'Label') w ...Show All

• Gidon J VFP to show UPS tracking info.

  Hi; I have a place in my app where I populate a grid with various info including a txtbox that stores a UPS tracking #. I'd like to make this 'clickable' so it opens up a web browser to show the ups tracking info from the UPS site. I would need to do the same for fedex. I have no idea where to begin. Any pointers and ideas would be greatly apreciated. Aleniko. Cetin; Thanks. Took me a f ...Show All

• Alex Thomas How to print a Table structure?

  Hi, is there a way to print a table structure (table fields, not the table contents) on the printer either programmaticaly or by a menu What I mean is when you modify a table their is no way to print the structure of the table! This is what I m trying to achieve. To print the structure of the table on the printer. So far I always had to press the PrintScreen button and then go to the Paint program, Paste and print . But of course this is n ...Show All

• MichaelMiller Safe vfp exe from virus

  Dear Experts I have observed that sometime some virus attacks on visual foxpro exe file, I mean any exe compiled in vfp, and virus writes some codes in exe. Next time when I try to run same exe it shows following error message D:\ginning\accounts.exe is not a Visual Foxpro .Exe file Then I check the size and creation time. The size is increased and time is also changed. Is there any method to lock exe so virus could not write something in vi ...Show All

• Timothy Tim video control

  While waiting for answers to my other post I tried to play with a video control. It gives me an error I cannot understand: cFileName = JUSTSTEM ( JUSTFNAME ( cLine )) THISFORM . O_VIDEOPLAYER1 . cfilename = cLine THISFORM . O_VIDEOPLAYER1 . playvideo ( cFileName , 100 , 100 ) cLine is the complete path to an .AVI file. The error is that "no parameter statement is found" Is anybody familiar ...Show All

• Suresh B 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

• luker Biometrics on VFP

  Hi,    I have this biometrics device which am planning to integrate in Visula Foxpro... what will i do to capture the finger print using the VFP application, is there any Add-on component for the VFP to enable it from doing so Any advice is greatly appreciated! Thank you! Regards, -Dodo Roa- Hello. There is no standard for this that I know of. The company that delivers the biometric device is likely to have a SDK ( ...Show All

• atame what is the maximum field VFP9 can handle

  Good day to everybody... just a little problem with my update at VFP interface with my back-end database I dont have this problem updating my employees table in SQL2000 with 35 columns at my VFP interface, but recently I add another 3 columns at my table, that's where I encounter this problem. Inserting a new record or deleting there's no problem, but when i edit a particular record then saved the changes,the update is OK.. but after I clo ...Show All

• danieldp how to configure properties of treeview in run time?

  I have a problem to disable the treeview object when the program is running, please help. the command which I used is : thisform.mytreeview.enabled = .f. I can disable it manually when I right click on the object and in the treeview property window. Any advise is very appreciate. Try - Thisform.mytreeview.enabled = .f. Thisform.mytreeview.object.enabled = .f. Hope this help It works. Thanks a lot. ...Show All