Answer Questions

• Star1234 Date formatting in a report

  I have an older accounting app (SBT Pro) that is using VFP 5. I don't have the source code available, but I can modify things in the report design. Currently control text box in bound to variable txt_date which displays in the report as mm/dd/yy (i.e. 07/24/06). I need it to show like mm/dd/yyyy (07/24/2006). I've tried several things, no success. How can I do this Thanks, Shreko Hi Shreko, Please use that if type(' ct_date') = 'C' && check if the field type is character/text ct_date = ctod(cdDate) endif I apologize for not knowing trivial things about VFP, but how do I check the status of the CENTURY variable. I have tried set('CENTURY') in the command window, but does ...Show All

• chris441962 OLE error code 0x80040154. Class is not registered. OLE Object is being ignored

  Hi, I get the error : OLE error code 0x80040154. Class is not registered. OLE Object is being ignored . I get this error when i run a form which has a chart in VFP 6.0. Can somebody help Alex Hi, I cant seem to find the right ocx or dll. If i right-click the OLE chart object on my development pc, it shows MSCHART properties. So, can u tell me what dll or ocx do i need to register at client PC. Alex Register the activex first that chart is using. Thanks MarciaAkins, Your solution worked !! Alex AlexDcosta wrote: I cant seem to find the ...Show All

• David J Oldfield How to implement Mouse leave for a form.

  I have a very small form that opens up to display some info. I'd like the form to close when the mouse leaves the form. I noticed there is no mouseleave or mouseenter for forms. Any other method to do this Thx I thought about puting a container the size of the form in the form and use its MouseLeave method but I thought there may be a better way to do this. There is MouseMove Event method with: LPARAMETERS nDirection, nShift, nXCoord, nYCoord You may close the form when mouse pointer leaves the form surface(setting mouse coordinates) using nXCoord and NyCoord MouseMove can help. Use your imagination. You might also check OnMouseOut at universalthr ...Show All

• CBHCMC VFP9 SP1 DLL Error

  Hi All Shot in the dark, but just wanted to see if anyone else is getting a similar problem. My VFP9 SP1 application has been working fine but over the last month, one of my forms has been returning an error with vfp9r.dll. It's the standard error with the "send report to Microsoft". The forms in question do not do anything different to any other form and I've cut down the code and tried to isolate the problem. However, the error does not happen all the time and some users experience it more than others. The form has not changed recently either. I've tried reinstalling the VFP runtime, giving users admin privledges, etc. Nothing works. The only thing I've got is an entry in the event viewer: The descriptio ...Show All

• Tim Mavers 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. giuln wrote: same problem also in vfp6 and vfp9... Thank you for the confirmation giuln. Hi Darren >> The strange thing is that Round(.575000000000,2) gives 0.58 but the extra ...Show All

• Raba Shani password on my table

  can i put password on my table Hi, To protect VFP dbf, you may take a look at XITech Cryptor. http://www.xitech-europe.co.uk/Cryptor.html Not really. You can do as Andy said, but doesn't buy you much security. It all depends on who are you defending against. A better solution might be encrypting your data. Either the whole table transparently with a product like Cryptor or some columns (like CC numbers, salary, SSN, etc.) For encryption, you can use the old Win CryptoAPI (now deprecated, but free and somewhat easy), or external routines like Craig Boyd's Encrypt / Decrypt functions for VFP . Or you could move your data (like many/most of us do) to SQL Server or similar DB that offers built ...Show All

• zort15 ceiling to the nearest nickel

  Dear Friends, How to round a number in foxpro like the ceiling function in Excel does, giving the number to be rounded as parameter 1 and the multiple we need as parameter 2 eg ; ceiling(4.20,0.05) = 4.50 Is there a possiblity to do the same in foxpro, because the ceiling in foxpro rounds up to the nearest integer eg: ceiling(4.20) = 5.00 there is noway of specifying the multiple we need as in the case of Excel Any help would be greatly appreciated. Thanks satish sorry i understood the question wrong. Dear Andy, Thanks for your quick reply, please note that there was a type error it is not 0.05 but 0.50. Thanks for your solution I am trying it . bye sati ...Show All

• Rajesh Kumar J using tow field index with codebase

  Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay If you think is .cdx file, why don't you re-create it I dont think code base is sending any thing to VFP i think they are creating table the are foxpro compitible. when you say there is no way to create index using OLEDB you mean that there is no way to cre ...Show All

• ODP 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 Then in your select put that column in last position and in your grid set columncount to be less than field count. Hi , You can try Thisform.mygrid.columns(4).visible=.f. If fourth coulmn is the above said pointer column. ...Show All

• Cilieborg Guidance Required...

  Hi all,         I've developed a VFP application in vers. 6.0. Now that the client wants the same with MS SQL / Oracle. Please someone tell me the list of atricles and other notes i've to go through..... I'm ok with SQL querries.... Please suggest me regarding the -Remote views, SPT's...... The application as a whole has about 2 GB of data in VFP..... It's a multi-user application....running on VFP 6.0 ./ WIn2000 Platform.  Thanks in advance... -Markish Markish, Even within VFP rlock() approach is not very good IMHO. Your application's needs would really shape it. Once I posted a sample code on universalthread demonstrating "rlock" for VFP/MSSQL table in asp.net ...Show All

• DRoden New to InstallShield need help

  I recently resumed writing Visual Foxpro applications. I have not done much with VFP since Visual FoxPro 5.0. I'm currently using VFP 9.0 w/Installshield 5.0. When I create a distribution set and attempt to run it after the install, the form flashes on the screen for a half second and disappears. When I run the prg or exe from inside the VFP environment, they perform as expected. What could I be missing   Rick is right. You seem to be missing a READ EVENTS. VFP needs a wait state. This is provided by the IDE when in development. You need a READ EVENTS while in production (EXE) and a CLEAR EVENTS executed from your exit menu option or exit button on a form or similar. See the very last ...Show All

• CharlieRussell Converting a DAT file into a BDF file

  Hello all I am trying to import a file into FoxPro, it has a DAT extension, is there any way I can convert this to a DBF file Thanks .dat may be a text file output from cobol. first try to open in excel and save it as dbf. else if u can findout the layout u can create a dbf and give the following command use <filename> appe from <filename.dat> type sdf Hello My trouble is that I do not have a data layout of the file. It was a COBOL program that created the file. Thanks Maybe. What is a DAT extension The name itself doesn't tell you anything other than it seems to be a data file, right What is the program or databa ...Show All

• MShetty send mail but don't want the outlook ask permission

  I would like to send the e-mail in the foxpro program using Msmapi32.ocx, I have used the following coding: this.mpssession.logonui = .f. this.mpssession.signOn this.mpmMessage.SessionID = this.mpsSession.SessionID * set for Direct Message Handle this.mpmMessage.MsgIndex = -1 this.mpmMessage.RecipDisplayName = "xxxxxName" this.mpmMessage.RecipAddress = "xxxx@bhss.edu.hk" * Resolve recipient name *this.mpmMessage.AddressResolveUI = .f. *this.mpmMessage.ResolveName *Create the message * mail subject heading this.mpmMessage.MsgSubject = "Status Report" * mail message this.mpmMessage.MsgNoteText = "Build successful!" *Add attachment *Add attachment 1 *this.mpmMessage.AttachmentIndex = 0 *this.mpmMessage ...Show All

• Andrew Shearer ceiling to the nearest nickel

  Dear Friends, How to round a number in foxpro like the ceiling function in Excel does, giving the number to be rounded as parameter 1 and the multiple we need as parameter 2 eg ; ceiling(4.20,0.05) = 4.50 Is there a possiblity to do the same in foxpro, because the ceiling in foxpro rounds up to the nearest integer eg: ceiling(4.20) = 5.00 there is noway of specifying the multiple we need as in the case of Excel Any help would be greatly appreciated. Thanks satish Thanks Lakshminarayana, It happens sometimes, I am working on it , get u latter thanks again satish Check the ROUND() function It will round values to the specif ...Show All

• OctopusThu VFP 9.0 ReportListener Rendeing....

  Hi All, Is there any other way to preview with out using a APP for the _reportpreivew system variable my reqiurement is like i should not have a seperate source for this APP line the ReportPreview. i have to have the source in my basic project and use reportlistener for previewing the reports. Kindly do the needful. Thanks in advance Venkatram Venkatram wrote: do (_reportpreview) with oPrevCont oRepListner = createobject("ReportListener") oRepListner.listenertype = 1 oRepListner.previewcontainer = oPrevCont *!* snip release oPrevCont release oRepListner endproc && repodemo i am getting an error " OBJECT FILE exe path IS IN USE AND CANNOT BE REMOVED FROM THE MEMORY" when i comment ...Show All