Answer Questions

• Huggable_helen set talk off settings scope

  hello, I use vfp 6 and win xp as o/s. my client uses win98. when i run exe on te client's computer . it works as "set talk on " but on my computer it works fine. help. -ravindra thanx fort he help Make sure you compile with a bare Config.fpw file containing TALK=OFF and also do a SET TALK OFF in the Load() method of your form's base class. (it's scoped to the session). ...Show All

• Ro0ke vpos value in frx files

  I'm trying to convert the vpos value (ex. 9479.833) in a report file to actual inches) so that I can give the actual label values for a check to a printer. When I look at the top value in design mode this value is denoted at .53 which I confirm. How is the vpos value converted to inches In the case of my sample value 9475.833 my inches value while I am in report design mode shows as .53in but if I divide the value shown by 10000, I get .9475 and thus my confusion. If I take the hpos value and divide by 10000, I match perfectly with the report design screen value but the vpos value must indicate something other than the vertical position or there is a different calc for conversion to inches. I am tr ...Show All

• Alquimista09 auto increment

  I have a table that I want to add a auto increment integer field. I go into the database designer, Right click on the table I want to add the field to then select modify. Then I insert a field and give it the name client_id set the type to Integer (autoinc) it defaults to a width of 4. Then I tell it to index it accending. This works but on all the existing records it sets the field to 0. If I add a new record it does increment. Thank You USE <tablename> GO top DO WHILE .T. REPLACE <field name> with <field name> + <increment value> IF !EOF() SKIP ENDIF IF EOF() EXIT ENDIF ENDDO USE i am new in vfp ho ...Show All

• Aaron Sulwer Why tooltips won't work for Expressions?

  I've noticed that tooltips won't work for expressions. I'm refering to the tooltips VFP provides when the with of the column is smaller than its content. Is there a way to make tooltips work for column1 in the grid below Public oForm oForm = Createobject('MyForm') oForm.Show Define Class MyForm As Form Width = 420 Height = 460 showtips=.T. Add Object grd1 As Grid With ; left = 10, Top=45, Width=400,Height=200,RecordSource='Orders' Procedure Load Use (_samples+'data\orders') In 0 ENDPROC PROCEDURE init thisform.grd1.column1.controlsource= "('The quick brown fox jumps over the lazy dog')" endproc Enddefine Public oForm oForm = Createob ...Show All

• SQL_newbie Dot matrix printers with Visual Foxpro

  Hello all, We are in the process of converting an old Foxpro 2.6 (DOS) software into VFP, the problem that we face is that the printing is very slow on dot-matrix printers We cannot shift to laser printer as the stationery is pre-printed and has to be multi-part. Can anybody offer the solution Thanks in advance If the printers are on a network, and you're trying to print from other machines, you can use "Set printer to \\machine\printer" and this will bypass any windows drivers and will send text directly to the printer. You will be able to use older reports in VFP keeping the same format. The problem with this method is that there is no way (At leas no way I'm aware of) to print to the local machine bypassing the ...Show All

• RyanB88 PGP file decryption

  Hi All, I'm looking for an API to decrypt PGP encrypted files. I were using command line PGP program to do it. Sometimes it fails, so I decided to look for some other solutions. Another question would be if I could use MS CryptoAPI to decrypt PGP encrypted files Any help appreciated. Thank you in advance. Vasim wrote: I use this product http://www.eldos.com/sbb/ SecureBlackbox, If you decide to use the Component, I can post some code too. Hope this helps. I would appreciate if you would post some code. I have been looking at Eldos as well. I have been having troubles getting even the most basic functions to work. Example: oKeyRing = CREATEOBJECT(&q ...Show All

• farming MyEditor (Edit Control) Validation in VFP-9: STOPPING Menus, etc?

  I'm trying to *stay within myEdit control(s)* until *pProcessing* is finished. I seek *better ways*, per se, from any of you (besides making the form(s) modal). Here are some of my awkward (non-bulletproof) workarounds. In myEditor.VALID ... If pProcessing This.SetFocus * Return .F. Endif To STOP Menus... In _msysmenu: set skip for pProcessing (for every menu bar()... ) OR SET SYSMENU SAVE SET SYSMENU TO ...when pProcessing is finished SET SYSMENU TO DEFAULT (I'd prefer to make _MSYSMENU/SYSMENU just *freeze* ... in a modal (myForm.windowtype=1) manner and not have it *blink* off and on ) To prevent oApp.oToolbar... If pProcessing oApp.oToolbar.enabled=.F. Endif Hiding forms until pProcessing is completed, Etc. Etc. Thanks in adv ...Show All

• Andrew Buyan VFP 3.0 on XP

  I need VFP for a small project, and I don't want to spend USD 600 for a new version (is there a beta version still available ) Is it ok to install VFP 3.0 on Win XP Thank you, Tor Henrik > i'm currently using vfp 6.0 for almost 4 months. So far, it does not give any problem. What's the difference between vfp 6.0 and 7.0 See:  http://fox.wikis.com/wc.dll Wiki~VisualFoxProVersionFeatureConcordance   Note: You should always start a new thread when asking on different subject. ya me too. i wont recommend u develop program using vfp 3.0. pls using vfp 7 and above..... more stable ... Beta is not available anymore ...Show All

• Alexey Nayda converting xml to foxpro table

  Hi, I own an insurance and investment company and just play around with some foxpro applications for my business. I have developed several helpful database programs for such things as tracking insurance quote requests that come in, etc. in VFP ver 5.0. I just purchased VFP 9.0. I am pretty much clueless as to what xml does or how it works (i don't even know what it stands for); however, I am now in need of being able to suck data that is currently in xml format into a vfp database and vice versa. I tried playing around with the smltocursor and related commands, but they are way over my head. Is there a simple program code someone has that will just convert this for me Or is there one of you folks out there that I could hire for a small ...Show All

• DTHMTLGOD Connect to Outlook Express and Microsoft Outlook

  Dear Expert, Can I know how to connect to the Outlook Express and Microsoft Outlook using FoxPro Like the data in a memo feild how I connect or send out using the Outlook Express and Microsoft Outlook Or Can I generete email using FoxPro Thank you.     Marcia; Can one use CDO if the SMTP server is an ISP Bankim, I don't know the answer. Maybe you don't know but writing in uppercase is considered as "shouting at". Both Alex and Marcia are trying to help and they don't deserve to be shouted at. I believe you didn't know that rule:) PS: I had the luxury to meet both of them in person and they are ...Show All

• Aleko_b Convert ADO recordset to a Foxpro DBF free table

  Hi,     I currently have a need to convert an ADO recordset to a DBF. I've seen some posts here on how to create and write to a DBF using C# in conjunction with the VFPOLEDB provider. I mocked some code up in VB6 similar to the example and I am able to open the dbf in VFP6 no problem. However, I'd like to find out what ADO to Foxpro field type conversions would work. The ADO recordset comes as a result of a query from SQL Server 2000, so there are bound to be some datatypes that will not convert natively. I've come up with this matrix so far based on some MSDN Library materials.     SQL DataType              ADO DataType   &nb ...Show All

• learnerplates Future of Visual Foxpro

  Hello friends, I have a general question. What will be the future of VFP The reason for asking this question is because, our company is planning a major commercial software development. So far we were very much satisfied with VFP. But now doubts are being raised whether we should base our investment on this platform or consider something new like VB.NET. Especially when we hear that the products will not be served beyond 2009!!! Any sincere opinion will be a big help. Thank you. As far as Vista is concern, there is still hope of SEDNA update which will make foxpro interface similar to vista. Beside VFP will work on Vista (as 32 bit). But still we dont know what will be there after Vista. Last but not the least, second part ...Show All

• KitWest 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. 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 = getobject("winmgmts:") oDisks = oWMI.InstancesOf("Win32_PhysicalMedia") for each oDisk in oDisks     "serial # " + oDisk.SerialNumber next The syntax will be slightly different for VFP6 or earlier, and this could be run remotely: see here for more info. --stuartd This code only works on WinXP, what about the code in WinMe or Win98 Please, let me know ..... ...Show All

• Mortsdeh Report: Counting / totaling groups.

  Is there any new fetures in VFP report designer which will allow me to easily count the group bands I have some reports which I need to show the number of items in one of the group bands (In other words the number of times a group band is printed). Thx. initialize a counter and incriment its value when ever a line has been printed and display the counter. There's nothing new for this. You can do it the same old way, with a pair of report variables. One keeps count and the other tracks the current value of the grouping variable. Set it up like this: Name: nGroupCount Initial Value: 0 Value to Store: IIF(uGroupVar = <the grouping expr>, 0, 1) Calculate: Sum Name: ...Show All

• ShadowRayz Looking for some good software to document a project.

  Hi, I want to document a project written in VFP 6.0 I would be interested in a software which lists all programs/functions called for every menu option avaiable on the main menu. Also I want to list all dbfs used and all memory variables created for each program file. Thanks in advance. Regards, Dinesh jain_dinesh@hotmail.com >> I want to document a project written in VFP 6.0 Is there something wrong with the VFP Documenting Wizard then Hi Andy, Thanks anyway for your kind help. Regards, Dinesh You could try http://www.eqeus.com/pdm.php That is a freeware VFP documenter, but I don't know if it will do what you want. Otherwise I don't know what to tell ...Show All