Answer Questions

• Tim Greenwood FoxPro for Mac OSX

  FiveTech Software is developing FiveMac, a software tool that will provide the FoxPro for Mac OSX functionality using the CA-Clipper language (http:// www.harbour-project.org ). First screenshots: http://fivetechsoft.com/forums/viewtopic.php t=4779 Product development announcement: http://www.fivetechsoft.com/english/fivemac.html Forgive my ignorance, I don't work with Mac,but AFAIK already there were a Foxpro for Mac since 90's, no Screenshots look more like a Clipper for Mac. ...Show All

• Limehill Column Visible in Grid

  Ok, I am creating a grid and I need to create a column called "ProvRecno" to use for a refrence pointer. I can make the column, and I can see all the info I need, however I want that column to be non-visible. I am not sure how to set this column to visible = .f. The Grid is built from a SQL select, and I need some way to select the column titled ProvRecno so that I can set its visibility to .f. Any Ideas Hi Cetin, Can we set the columns' width property to zero in case of older versions.... Regards, Markish Yes I agree with you... Probably he is asking for his version is old and doesn't support visible = .f. behavior as it does under VFP9 (wish posters alw ...Show All

• MrKWatkins Produce error when running the form

  Hi, When running the form, I got the error. The error is "Error loading file - record number 61. grid_detail < or one of its members>. ControlSource : Alias 'NEWDETAIL' is not found." I'm not sure where i go wrong on my form. Thank you. >> for me i wont use alias hm i more on thisform.gridbox.recordsourcetype = 4 && SQL >> thisform.gridbox.recordsource = "select sql statements " There are no SQL statements in my database. Purely written in VPF 6. MillBear wrote: My senior IT said that there is a bug in the Visual Foxpro 6 software itself. The codes in the open file and close file method in the Data Environment has switched places. So have to c ...Show All

• ZZia primary key?

  How do u auto increment a primary key in vfp You just INSERT into the table and it happens automatically. For example here's a chunk of code that creates a database of my Windows Media Player music library. close databases all create database c:\temp\musiclib create table c:\temp\band ( iBand i autoinc, cBand c(60) ) create table c:\temp\album ( iAlbum i autoinc, iBand i, cTitle c(80), dAdded d, cGuid c(38), iYear i ) create table c:\temp\songs ( iSong i autoinc, iAlbum i, cTitle c(128), iLength i ) set safety off lcRootPath = "C:\Documents and Settings\David\My Documents\My Music\" lnBands = adir( laBands, lcRootPath + "*.*", "D", 1 ) for i = 3 to lnBands if ( ...Show All

• white2grey rounding bug in vfp8?

  I have found what seems to be a rounding bug in VFP8. Any ideas how I can get around this please I was doing some testing when I found that I was a penny out on digging deeper it seems that when lnValue = 0.57500000000000, Round(lnValue,2) gives 0.57!!!!! when it should give 0.58. This is causing my validation to fail. Is this a bug The strange thing is that Round(.575000000000,2) gives 0.58 but the extra 0's in the scenario above are causing the difference. Hi Darren >> The strange thing is that Round(.575000000000,2) gives 0.58 but the extra 0's in the scenario above are causing the difference I think that this is a limitation of VFP's floating point number implementation. As sta ...Show All

• ProxyPro how do i change the desktop background?

  Good day to all experts.... how could i change the desktop background programatically i would like that if a user change my desktop background...at the time I open my VFP application it automatically search my desired background and changed it. Thank you no...not the VFP SCREEN but at windows desktop screen itself. thanks   thanks to both of your explaination regarding this matter. have a nice day and more power... _screen.picture = "myPicture.bmp" or you can add an image control. If you mean color only _screen.backcolor = rgb(255,255,255). You can only do that through the Windows Control Panel. The settings are stored in the Registry and I suppose y ...Show All

• Herru Perdana Update AND Insert SQL text field (over 256 characters) into FoxPro memo field using OLEDB - VBScript version

  I've seen many responses in the various 200+ documents I've reviewed to solve this issue, but I can't seem to find an example that actually works. Just a simple example of using VBScript to insert more than 256 characters into a FoxPro text field. I'm using SQL DTS ActiveX Script task to export data from SQL 2000 into FoxPro (there are many reasons for using this method as I have various tables to update and people to notify) I'm using the latest FoxPro OLEDB provider. I've attempted using a recordset and updating using appendchunk. That didn't work. I have to test each line for an error and I originally thought that there was an issue with the appendchunk method, but I discovered that none of the recordset type ...Show All

• Andreas Leitel Filename and nullchars

  I hope everyone had a good xmas and santa gives you a lot of presents :) Now, my question: try this code in VFP9: pParam1 is a parameters which contains a folder name. The folder must contains EMLs, but can be another file, just change the extension. cString =pParam1 + Chr(0) nEMLs =aDir(aEMLs, pParam1 + "\*.EML") For iEMLs =1 To nEMLs cString =cString + aEMLs[iEMLs, 1] + Chr(0) EndFor StrToFile(cString, "C:\FileNames.TXT", 0) If you open the TXT file with Notepad.EXE you will see squares and other unreadable chars. If you open the file with FileToStr() and post the content in the VFP _screen, the names are ok, but if you send it to a messagebox() you'll see an empty messagebox. Thus, if you send to the messagebox( ...Show All

• Martimus Private data Session for Prg Files?

  Is it possible to set a prg file to a private data session For most of my reports I have an associated prg file to handle all the data processing, and then call the report to format the data the data out on viewing\printing. I am currently using a DataSession class (basically a form with a private datasession) that handles theses report calls. Since the prg is called from a DataSession class it stays in the private data session, and I have to pass any parameters though the DataSession class to the Prg. Is there a way I can set the Prg to a private data session and bypass this middleman class Or an I just Doing this I a totally half-assed way and should be doing this totally different Thanks, Sam ...Show All

• migs Copying from one sheet to another within the same book

  I am creating a workbook for a local company using excel. I've got most of the book worked out except that when information is input into the "main" sheet I need the same information - the entire row - copied over to another sheet within the same book depending on certain criteria. In other words, if the value in a column is 2 then copy the entire row to sheet 2, if it's 3 then copy to sheet 3, and so on. Is there a way I can accomplish this kind of automation Anything you can do in Excel can be done through COM Automation. The easiest trick is to record a macro while doing the actions in Excel. This creates a VBA file. The code it produces is not the best otr the most efficient, but it copies ...Show All

• jbelisle Exe Packer

  Hi! I look for a freeware exe packer. I tried ULX but it doesn't work. Thanks for your help, Manu ...Show All

• Sajal Mahajan Setting up session defaults.

  Hio all; I would like to set default session settings (Like talk, excl, etc) in all my forms. I am not sure if I should do this in the init of my baseform class, or somewhere else Thanks. Yes if you edit the code. If your form(s) have dataenvironment then form.load might be too late either. Then code in dataenvironment.beforeopentables. The Init() is too late - you need this code in the LOAD() and the first command in the list should be SET TALK OFF But yes, your base form class is the place for it. Thanks Andy; Does this mean that I need to issue a dodefault() in my forms when I edit the load method ...Show All

• strelzj Weird "IIF" problem

  Hi, I seem to be getting a problem running the IIF statement using this particular code: "iif(((maturity)-(m.dday1)) between 365 and 730, 1, 0) as TERM" Basically Foxpro is saying that I'm missing a comma in this particular line of code. However, I can't seem to figure out where to place the comma. Thanks in advance! thanks so much! works like a charm! :) IIF() is an XBASE command. You are mixing with the BETWEEN SQL construct. Try using the BETWEEN() xbase function instead: Iif(Between(maturity-m.dday1,365,730),1,0) ...Show All

• sangminny Produce error when running the form

  Hi, When running the form, I got the error. The error is "Error loading file - record number 61. grid_detail < or one of its members>. ControlSource : Alias 'NEWDETAIL' is not found." I'm not sure where i go wrong on my form. Thank you. MillBear wrote: My senior IT said that there is a bug in the Visual Foxpro 6 software itself. The codes in the open file and close file method in the Data Environment has switched places. So have to correct them in the right form method. Now the form runs well. Glad to hear it runs now. VFP 6 (a very old version) had a few bugs like all complex software, but not that one. Methods don't "switch places". Someone must have inadvertently done somet ...Show All

• Santhosh Pallikara setsystemtime cannot set millisecond

  Hi, I want to set the system clock of my PDA (WM2003) to milliseconds. I use now setsystemtime but it seems that it doesn't set the millisecond field, (year/month/day/hour/min/sec is ok.) because if I call getsystemtime directly after this method it returns always 0. Anybody can help My code: SYSTEMTIME st; st.wYear = year; st.wMonth = month; st.wDay = day; st.wHour = hour; st.wMinute = minute; st.wSecond = second; st.wMilliseconds = millis; SetSystemTime(&st); No, not directly. The code as I see is a C code using SetSystemTime winAPI. I simply have the same API call in a prg and working right (under XP:). It might be related to your PDA and/or OS. Under ...Show All