Answer Questions

• MukilanP How to fix grid headings?

  Can we do that It does not help if I set: AllowHeaderSing=.f.   BTW if you meant not to allow "sizing" of headers then: thisform.myGrid.SetAll("Resizable",.f.) Thank you. This is exactly I meant. Then what does "Movable" mean For a column it controls whether the order can be changed at run time by dragging a column to different position. I think you meant AllowHeaderSizing. If you set it to .F. header height is not allowed to change. It doesn't have anything to do with column positions (I think you meant it). To do that: thisform.myGrid.Setall('Movable',.F.) ...Show All

• CGuyArun Dynamically enable or disable rows in a grid.

  How can I dynamically enable or disable the current row in a grid depending on a contition I used to use 'when' in Foxpro browse but in a grid the 'when' affects the entier grid. thanks. Prior to VFP9 you can use: this.SetAll('Enabled', yourCondition) Perfect. Thx. Aleniko wrote: How can I dynamically enable or disable the current row in a grid depending on a contition I used to use 'when' in Foxpro browse but in a grid the 'when' affects the entier grid. This code in the grid's AfterRowColChange: This.AllowCellSelection = SomeCondition ...Show All

• PhoenixZero Upsizing and VFP

  I currently have some software that was originally created in the dark ages of Fox, my task is to upsize (make it more marketable) and use Sql Server as the backend. The tables are all upsized roughly 580 of them (ugh!!). Out of that 580 most of them are look ups. Venturing back to the software, the original developer was either a hobbyist or someone who loved job security because there is little or no comments in spaghetti she wrote. Also she wrote her own procedure for handling data calls (this is good, at least at first glance for me since I think I can get it to connect to sql backend without to much work) except that I can't get it "DO" without errors on run, errors related to file locations that don't have files since they ...Show All

• B. Ritter Vfp Converting DateTime Problem in MSSql

  Hi *. i have table on MsSqlServer "art" with 2 fields id int, date datetime and when try to put some value into datetime(), MsSql say go away :( mSql = "insert into art (id, date) values (2, '20061103141100')" =sqlExec(nHandle, mSql) Please give me solution for this problem in Vfp. p.s. Don't give me example with store procedure, 'coz i use mssql for storage only. Thx. Hi, Assign .NULL. value to your variable if you are following cetin's approach (parameterized sql), or replace your date value with NULL if you put your value as string into SQL. lddate = .NULL. SQLEXEC(m.nhandle, 'INSERT INTO mytable (mydate) VALUES ( lddate)') or SQLEXEC(m.nhandle, 'INSERT INTO mytable (mydate) VALU ...Show All

• Georgiev help? textbox

  Hi I am new to vfp and my syntax knowledge is not very good actually its quite bad. I was wondering. How do you recieve user's input through a keyboard in a textbox (cmdtxtbox) and then use that input and save it as a variable (userInput) Thanx for the help Bobby Use the controlsource property on the text box to the same name as your variable, then use REPLACE() to update your table. Make sure you have defined the variable with your setup routine. Bobby110uk wrote: I am new to vfp and my syntax knowledge is not very good actually its quite bad. Then I suggest that you go to http://www.hentzenwerke.com/catalog/fund6.htm and grab a copy of Fundamentals: Building Visual St ...Show All

• vtortola System time - synchronizing, displaying

  Hi experts. Does anybody know how to get the real time from internet. I want to have the real updated time in my application. Second task is to changing the system time. How can I do that Third task is how to display time in form for example in textbox. I know the way with timer but if there is any other way I will be glad to know it. But the consequence is in the order I have written. Mainly the getting real time from internet. Thanks According to wikipedia, Pacific Time observes daylight saving in the same way as Central European Time so as the transitions are the same then the offset will always be the same. Winter: Pacific is UTC - 8, CET is UTC + 1 -- offset of 9 hours Summer: Pacific ...Show All

• Bill Arnette OleDb provider and unc path

  I make ASP page for internet access and i need to read & write data from visual foxpro tables. These tables use new fields type (of last versions of foxpro) like autointeger fields so i can't use ODBC driver. The tables aren't on the sane server where is localized the web server and i need to use the oledb provider and insert this connection string Provider=VFPOLEDB;Data Source=\\DataServer\Application\Data\;Collating Sequence=Machine When i try to access the data i receive an error : Invalid path or file name..... There are problems using OLEDB and unc path names Why there is not an updated odbc driver from Microsoft for newer versions of Foxpro ! !! ! Thanks ...Show All

• Randal Greene DLL Language in Portuguese

  This is my first Post :) I work with VFP since '99 and has been always in english. Dealing with english is not a problem, but for my custumers yes, especially with error messages prompted from VFP (due to program code error ou just a crash). Is there a possibility to translate a Resource DLL to portuguese just like exists in Spanish, French, etc. This avoid me have an error routine to translate some messages (one of the common messages is "The visual foxpro support library is missing or invalid"). thx, DaCosta11. As far as I know all of the existing localizations have been undertaken by dedicated volunteers from that country - Spain, France, Germany and, I think, Russia. If you want a Portuguese DLL I am afraid that you w ...Show All

• Dan Waters [MSFT] Detect hard diskk serial number.

  Dear Expert, Can I know how to detect the hard disk serial number or code using foxpro Thanks a lots. how to get the hard disk serial no where my app is installed. How can i know which hard disk What Imean is how how to tell wmi to just to return one harddisk which is the hard disk that has my app in it wmi return all hard disk installed in the computer. I dont know which of the hardisk is the harddisk i want . Check application.servername. Hi You can do this using WMI (an internal database of objects maintained by Windows) This code returns the serial # of my local hard disk(s) oWMI = getobj ...Show All

• dweeks Help with rounding

  Help!  I have to round a number to the closest 500 but if last three digits are between 0 - 250 round down, 251 - 499 round up, 500 - 750 round down, 751 up, round up. Example: 2140 should round to 2000 2257 should round to 2500 2660 should round to 2500 2760 should round to 3000 Thanks in advance! Thank you everyone for your help! Can you test Mod(<number>, 1000) to make round Mod(2140, 500) = 140 -> Down (<number> - 140) Mod(2257, 500) = 257 -> Up (simply <number> - 257 + 500) Mod(2660, 500) = 160 -> Down (<number> - 160) Mod(2760, 500) = 260 -> Up (2760 - 260 + 500) and so on. ...Show All

• susanasusana slipstream VFP 9 with SP1 ?

  Anyone know how to slipstreaming Visual FoxPro 9 with current SP1 Sure: copy the VFP CD to a writeable drive, use WinZip to extract the MSP file from the SP1 installation, then run this command (allowing for different file paths) to update the installation directory: msiexec /a c:\vfoxpro9.0\vs_setup.msi /p c:\temp\VFP9.0sp1-KB909149-X86-Enu.msp I just tested an install and it seemed to work just fine. (I had to type in the product key for VFP9 though) Regards Stuart Dunkeld You may try to use same steps from: http://blogs.msdn.com/heaths/archive/2006/12/16/slipstreaming-visual-studio-2005-service-pack-1.aspx Since VFP 9.0 isn't part of VS 2005 (or any other ...Show All

• Mark Jewett - MSFT excel and foxpro

  Dear friends, when exporting datas to excel from foxpro using the copy to command, there after trying to do some calculations and formating the excel file using automatation macros how could I integrate this in foxpro, I don't know where to start. thanks for explaining me the functionality satish Dear friends, I found out the great prg file and my project works as I wanted. nice weekend, thanks for all your kind suggestions especially for cetin satish http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=948945&SiteID=1 You can use macros created in Excel but first you should understand and edit the code generated there. 1) Excel mac ...Show All

• Alex Levin VBA to VFP code conversion

  Can anyone help with converting the following from VBA code generated in Excel to VFP code: Sheets("Notes").Copy Before:=Workbooks("AB0KF3FK.XLS").Sheets(1) Thank you When I have automated Excel and used the copy function, I have always copied a specific range like this and it has worked just fine: *** First get the attrib_ids for the attributes that *** we are saving. They are in column B of the output page lcRange = [B1:B] + Transform ( OUTPUT_COUNT ) oSheet . Range ( lcRange ). Copy () The only time I have ever seens the error That the copy property did not exists was when Excel's automatic catculations was on - you will get better results if you tur ...Show All

• Allen Razdow ComboBox Question - Load field from

  I have a form that has fields from my transaction.dbf database. I want to add a combo box that lists the customer numbers I have setup in the customer.dbf database. What I did was to set the RowSource to Data\customer.dbf, and set the RowSourceType to "6 - Fields". I keep getting "Field Phrase Not Found" error message when I run the form. I've read through this forum and read the Visual FoxPro 9 help text and I'm still confused. Any advise Derek You should open the Customer table in the dataenvironment for the form. Right click the form's background and select dataenvironment. I tried that and now I'm getting a "clias customer is not found ...Show All

• Markus Fritz How to make a web page in VFP

  May I please know what is the easiest way to make a web page using VFP 6 or 7. For a start I may just put some photos and then use a table to accept input from user. Thank you for your help. Rolly Thank you very much for your quick reply. God bless you for helping other people. May all go well with you. Rolly Militar Check www.activeVFP.com , www.west-wind.com etc sites. You might as well get visual web developer along with express editions of .Net products from msdn.microsoft.com/express (and do a simple page within minutes from a VFP table even if you don't know .Net - just an idea you should also check that, anyhing is not that simple f ...Show All