Answer Questions

• John Oliver (UK)MSP, VSIP Vista compatibility

  I've been searching for information regarding whether applications based on older versions of VFP (say 6.0) will encounter problems running on Vista. The solution itself is 100% VFP running against a VFP database. Has anyone seen any issues Thanks in advance! As far as I know, only the VFP 9.0 extensions (code name Sedna) will actually be tested for Vista compatibility. Whether earlier versions will run is an issue I am not qualified to comment on. There is some information on the VFP Home Page at: http://msdn.microsoft.com/vfoxpro/letters/ ...Show All

• Morn VFP 6 - Auto-numbering with the characters

  I'm trying to write the code to get the desired result: - CN060901, CN060902, etc... Am lost with the existing code (as below) and wld appreicate if you help to correct my existing codes (highlighted brown front). CN060901 stands for:- 06 - Year 09 - Month 01 - Serial number (dn_no from the ".dfbnos" table) **dbfnos is the table name. **dn_no is the field name in the table (.dbfnos). It is the auto-numbering, starting from 01. . Anyway, the date format on the form is 28/09/2006. [CODE] if empty(thisform.pf.pg1.invno.value) select dbfnos goto 3 && Remarks: For Credit Note select dbfbcn seek TRIM('CN' + right(str(dtoc(df_date),4),2) + right("00"+alltrim(str(month(df_date))) ...Show All

• ChrisErven Proper practice - edit a table in a grid.

  Hello everyone; I have a very simple form with a grid. The grid's record source is set to a cursor which contains a subset of a single table: Select * from PriceList where acct = cSomeAcct into cursor curPl I would like to add an edit button on this form which will alllow the user to edit the grid and update the Pricelist table. My question: What is the recommended way of doing this I thought of a few ways including issuing a "delete" and then an "append from", or maybe updatable views. How would you do this Thank you all. Yes really. IMHO it's better to use the table directly. I didn't say filter, I never use filter myself. It might be quite possible to ...Show All

• Jeffrey Harmon Help with expression (one more time...)?

  Hello All...many thanks to all who helped with my previous post. I have hit one more 'snag' in preparing my data. Here's a sample of three fields in my table... MRC REQUIRED DETAILS 4720-00-001-0057 ADLF HOSE OR TUBING SPEC/STD DATA MIL MIL-H-5593,SIZE 4 SPECIFICATION ADJM INNER CONVEYING TUBE MATERIAL RUBBER, SYNTHETIC MEDA MEDIA FOR WHICH DESIGNED AIR CRWL INSIDE SURFACE CONDITION SMOOTH CQCS LAYER COMPOSITION AND LOCATION 1ST LAYER ANY ACCEPTABLE CQCS OUTER LAYER MOLDED RUBBER CRJM OUTER COVERING ENVIRONMENTAL ABRASION RESISTANT AND PROTECTION CRJM ...Show All

• xbrady Hiding deleted items on grid

  Hello What I want to do is to hide deleted items in a grid in real time. I have a grid bound to a PRODUCT table. The grid displays all the products I have. I have SET DELETED ON in the Form's Load event In the grid's INIT event I have SET FILTER TO NOT DELETED() and in the DELETE event I have Thisform.grid.Refresh, to refresh the grid every time I delete an item. In a button called "DELETE PRODUCT" I have the following code DELETE So, when I choose a item in the grid, I click the DELETE PRODUCT button and the grid behaves a little weird, 1- The last record in the grid gets deleted not the one I chose. 2- The grid gets refreshed only when I click in another Item inside the grid. I have tried other ap ...Show All

• sureshv Created Menu with Menu Wizard - Now what?

  Hi, I'm a newbie Visual FoxPro 9 user and working on my first application. I used the Menu Wizard to create the desired pull down menus, but I'm not sure what to do with the Menu now Does the menu get associated with a prograrm or with a form What I want is to have a main window with this menu on it that is always displayed. When you select menu options I want pop-up windows to display with the various programs and forms in them. Any advise on what I need to do to get going in the right direction. Derek Hi Derek When you have your menu open in the designer, there is an option on the system "Menu" menu pad to "Generate". This takes the data you have enetered for your menu and creates an executable file from ...Show All

• Binu Jeesman Arrange the "character string" numbers in order

  I use the character string for number input. What Syntax should I use to sort out the “character-string” numbers as below For example: To sort out according to the number 1 1 12A 3 3 4 4 5 443546 12A 5 443546 555AB 555AB Thank you.   MillBear wrote: Is there any ways to sort the datas in the report designer You mean at runtime Just prepare the data before you run the Report Form ... Have this data sorted by either a SQL ORDER BY clause, o ...Show All

• Chakkaradeep Expecting Advise on A Graphics Problem

  Hi Everybody, I've project, that I have to use a custom worldmap and show some other drawing according their coordinates.Now I managed to draw the worldmap with FORM.LINE method. To zoom in/out I have to scale the worldmap. When I scaled 10x or much more times I can see the part that is on the form. And the other parts of the worldmap which is extended out of the form is lost. Because the LINEs that are created with LINE method aren't objects, form doesn't show any scroll bars to scroll left/right/up/down. So I need some thing like a canvas so that I can draw anything on it. And even it is off view I can managed to scroll to the extended drawing parts. Any ideas KAYA,Tolga Hi Cetin I tried really lots of things.& ...Show All

• nbrege Automatic Testing Tools

  Does anyone has experience with a tool that helps to automate the testing process for a huge application built in VFOX 8.0. I found many tools for that purpose but not many support Visual Fox Pro. http://www.automatedqa.com/products/testcomplete/index.asp It supports UI testing for VFP How to: Use the Automated Test Harness http://msdn.microsoft.com/library/en-us/dv_foxhelp9/html/afcaef34-96c4-40bb-937a-8e4fe6df3380.asp frame=true ...Show All

• Adrian Heath View grid scrolling while using the vertical bar

  Is there a way to see the grid scrolling while the user drags the vertical scroll bar I think its called ' Continuous Scroll'. thx. ...Show All

• bitpaq.com problem with class

  i get the error ole error class is not registered...... what does this mean and how do i fix it i read the vfp help files on it but it was too confusing for me. how do i register it First, you need to know what ActiveX control is causing the OLE error. Then determine what file its contained in, its usually an OCX or DLL file, i.e. COMCTL32.OCX. Then run the following command either using Start->Run or using the command prompt - REGSVR32 COMCTL32.OCX May be is the error OLE error code 0x80040154. Class is not registered... and you will need to register the active x you are using. ...Show All

• Timm Hagen Problem trying to create an Encryption Library

  I have followed the example for creating a C# Encryption Libary, but receive numerous errors with regard to no overload method ' ' requires 2 arguments, I have verified that my code is exactly as the example provided by microsoft and found no difference. Has anyone ever tried this code and had problems. Is there any other code to create an encryptoin library in C#. I would appreciate any and all assistance. I am responsible for figuring out how to encrypt the connection string for our web config files in Asp.net page. (we dont' have the .net 2.o framework, we are using Visual Studio 2003 with 1.x framework Thanks Heather Hi Heather. In Encryptor.Encrypt e Decryptor.Decrypt, replace this row ICryptoTransf ...Show All

• ratslav GetFile

  The statement lcFile = GETFILE([PDF],[Scanned doc],[Select document]) causes some machines to totally freeze up. Seems to affect Win2k machines and not XP or 2003. Statement is in a command button in a container in my vcx classlib. Used to work fine till I started building exe's on my 2003 server Any ideas AndyKr wrote: I think that Alex means that GetFile() is merely a wrapper around the Windows API call that opens Windows Explorer. Therefore the issue is nothing to do with VFP, but more likely to do with the WIndows system. Andy That's exactly what I meant. Maybe I did not make it clear. In re-reading, I should've said wrapper around the API. It is not Windows Explorer per se. ...Show All

• Flap Rotation vfp helpfiles not working

  this code is copied straight from vfp 9.0 help files. i just added the two paramateres this code works in vfp and when i run just the application on the computer that has vfp installed. however it is not working on non vfp computers. on a non vfp computer all i see is a wait window that says rendering and its tallying up the pages. PARAMETERS REPNAME,ANGLE_OF_TILT LOCAL oListener oListener = CREATEOBJECT("rotateText") oListener.ListenerType = 1 REPORT FORM &REPNAME OBJECT oListener #define FRX_OBJCOD_PAGEHEADER 1 DEFINE CLASS rotateText AS ReportListener IsInPageHeader = .F. PROCEDURE Init() DECLARE integer GdipRotateWorldTransform In GDIPlus.Dll ; integer graphics,single angle,integer e ...Show All

• KAAU sending email from VFP through MS Outlook

  We have the following code for sending email to Outlook. The email gets sent, but the font size is always 36 px or 36 pt (we tried both). None of the <cr><lf> show up. The email is one big paragraph. Can anyone help   Here is the code: LOCAL loApp, loEmailItem, cHex  lnsize = '"' + str(gaPointsize(Slcrm.nbodysize),2,0)+ '"'  cHex = ''  nDec = Slcrm.nColor    nPower = 8  DO WHILE nPower > 0       cHex = cHex + hexdigit(INT(nDec/16^(nPower-1)))       nDec = MOD(nDec,16^(nPower-1))       nPower = nPower - 1  ENDDO  lcColor=  '#' + RIGHT(cHex,6) * lcColor = '#' + strtran(Transform(GetColor(),'@0'),'0x ...Show All