Answer Questions

• Rudedog2 pass contents to C#

  hi! this is sort of connected to my other post regarding Foxpro and C#.. in the foxpro program i will type in a name and when i call the C# program it will also contain the name entered in the foxpro program. is this possible How can i do this thanks! From C#, you use ADO.NET, connect to the database that contains the data and query it. There is nothing to it, and it is not related to VFP. A SQL Server database is a repository of data. Which client you use to access that data is immaterial to SQL Server. So it is perfectly OK to insert data from a VFP front-end and retrieve it from C# as you want to do. If you are unfamiliar with C# and ADO.NET, there are forums here for them where you ca ...Show All

• wms103006 The running foxpro app is not the active task in the windows task bar

  Hi; I have installed a VFP9 exe file on a 2003server network. I have noticed that when the app is run, it doesn't become the active task in the windows task bar. This causes some confusion with the users. How would I make it the active task Thx. This is a tip from the late Ed Rauh [MVP]: * In your program's initial setup routine DECLARE INTEGER GetActiveWindow IN WIN32API DECLARE INTEGER GetForegroundWindow IN WIN32API DECLARE INTEGER SetForegroundWindow IN WIN32API INTEGER hWnd PRIVATE nMyAppMainHwnd _Screen . Visible = .T. DOEVENTS () nMyAppMainHwnd = GetForegroundWindow()  && your app has focus at this time * When you want the VFP instance to pop to the top: ...Show All

• Doug 123 export file question

  Hi, I don't know how to export a dbf file to a text file with character fields without quotes. For example, I need that in the text file, fields appear like this: simon 150 manager robert 300 sales representative Thanks, COPY TO YourFile.TXT TYPE SDF Tamar There are 2 ways (at least). If you mean fixed format then as Tamar suggested: copy to filename.txt type sdf Second one is (only remove quotes but keep field delimiter): copy to filename.txt type delimited with "" or: copy to filename.txt type delimited with "" with tab && blank, character   ...Show All

• dax_kun Creating Reports With Multiple Groups

  I am working on a Point Of Sale System and am using VFP 9.0 reports to create an invoice with a list of parts sold to the customer and a separate list of labor sold to the customer. These are both grouped according to the current invoice number. When viewing/printing the report, I would like to have one section or "group" list all of the parts for the current invoice and another section listing all of the labor items for the current invoice. The number of parts and labor items could, and most likely will, be different so they cannot be placed in the same group (to my knowledge). Unfortunately I cannot find a way to separate these into two separate groups using VFP9's report builder, I can only create nested groups and ...Show All

• saarar Passing multiple variables from forms w/ VFP7SP1

  I'm an old Clipper (S' 87) programmer that needs to figure out forms with VFP. The attached code generates a form containing a set of four optiongroups that set basic comm port parameters on the local host for serial communication with an instrument (usually an electronic balance). I'm trying to use the form to replace a series of cascading menus in the original program. My intent is for the form to recognize the 5 existing parameters in the main prg, permit user input and then pass any changes back to the calling procedure or function using a array embedded in the form when the user clicks [OK]. Clicking [Cancel] should leave the parameters unchanged. Can somebody please suggest a technique for passing multiple variables back and forth be ...Show All

• h1 COntroling objects

  I have 2 forms, Form1 and Form2. In Form1 I have a grid and a button, when I click the button I call Form2. What I want to do is to control the properties and methods of the grid inside Form1 from Form2. How can I do this Thanks to all of you. A form receives parameters in its INIT() method. Create a property of the form to keep the parameter received, therefore it will be in scope for the life of the form. Form1.Button1.Click() (or in whatever method you want) DO Form2 With this In Form2.Init(): LPARAMETERS toForm ThisForm.oForm = toForm (no validation code included in example) Now you have a reference in Form2.oForm to the object ...Show All

• Leon Zhu Creating an exe from the Project Builder

  Hello, I have finished my firs application and I have troubles with generating an exe to be installed in the customer’s PC. I’ve accomplished all the requirements seemingly for example to copy the dll that indicates the help of VFP, in same the directory where the application is executed, and to start up from an initial program that after calling to the form from this program, I`ve addedd the sentence of READ EVENTS at the end, I execute It and can’t see anything. The exe run like a process in memory (I do check it with the task Administrator of Windows XP). If I have an open sesion of VFP, it works, but if I close it, It does not (AND the client doesn't have installed VFP) Thank you for your support Regards, Alberto ...Show All

• paso install shield Express & FoxPro 9

  I am having a wierd problem creating my install with install shield Express. I seem to be creating the setup file okay and it is even installing good and running the app good, with 2 exceptions. the shortcuts that are created on the desktop and the start menu are only available for the user profile of the person who installed the app. The program seems to execute only when the installing person not anyone else. Even if the other person is an administrator. Please help I am new to this Install shield, before I used VFP 6 with its own installer. Thank You in advance. Hi, You got to select "Customer Information" dialog box from dialog node. This dialog provides "Only me&quo ...Show All

• Shaun Logan how to get all directory name ?

  dear all, in vfp7 how do i get all directory name thanks in advance. Check the ADIR() function. It will return directory names as well as file names Your code works fine! You have to parse through the array looking for items that have "D" in the fifth column - they are the directory names: a=adir(gcdir,"*.*","D",1) FOR lnCnt = 1 TO a IF "D" $ gcdir[ lnCnt, 5] gcDir[lnCNt,1] ENDIF NEXT thanks to u andykr. now i will continued to my coding ... thanks for ur help. i just know the directory name its on 5th column by using display memory hehe ... I had tried this function but i just get 80 and 80 number... my command is a=adir(gcd ...Show All

• Paul Burg SMS through visual foxpro

  Dear Sir, Please send me source code for SMS through visual foxpro, or favour me with some clues. Thanks & regards, - Ravi Awasthi You can send e-mail from VFP to the cell number, provided the mobile service provider has email to SMS facility for e.g if i want to send an SMS to BPL Mobile subscriber the TO field will have email address as: 987049999@bplmobile.com i use this technic to send SMS from your name i think you are from INDIA  the link below gives u the email id format for all mobile service provider in India SMS to Cell Phones in India if you want to know how to send email from VFP go thru this post Connect to Outlook Express and Microsoft Outlook links to Craig B ...Show All

• watch is Problem with Browser activex control

  I have a vfp form with a browser activex control (which I've named ole1). I use the browser to display an html page which uses javascript to create a text editor object like this: var oFCKeditor = new FCKeditor( 'FCKeditor1' ) And then (again in javascript) I can set up the text to be edited like this: oFCKeditor.Value = "Some html <b>text</b> here" Is there a way of accessing the oFCKeditor object from foxpro after the page has been displayed I've tried something like Thisform.ole1.document.oFCKeditor.value but that doesn't work. Malcolm Thisform.ole1. OBJECT .Document.oFCKeditor.Value check this example Loading HTML into a WEB Browser Control from Var ...Show All

• simmons Cannot execute program outside VFP9 IDE.

  I have built my VFP9 application into both .app and .exe files and when I execute them, the VFP9 IDE starts up and runs the program inside of the VFP9 programming environment. As a result I cannot see how the program behaves on its own as if it were installed on a client's machine who does not have VFP9 installed. Could someone please indicate how I can run an application on its own without it having to run within the VFP9 IDE Thanks Place exe and other needed files to a folder. Rename your development folder (if you didn't write code that removes dependency to development folder). Dblclick the exe in explorer. I guess I would be mixing up the main VFP window with the ID ...Show All

• aragon127 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 thanks to both of your explaination regarding this matter. have a nice day and more power... no...not the VFP SCREEN but at windows desktop screen itself. thanks   You can only do that through the Windows Control Panel. The settings are stored in the Registry and I suppose you could change them BUT if I had an application that changed my windows desktop - it would not be on my machine very long! Messing with user settings is a big "NO-NO ...Show All

• Greg D Clark VFP8 & VFP9 error

  This error appears in the Task Pane Manager Class definition MSXML2.DOMDOCUMENT.4.0 is not found Task manager will no longer work. Any suggestions Bryant Minard Looks like you need XML Parser reinstallation. http://support.microsoft.com/kb/269238 http://support.microsoft.com/kb/324460 Are you using something like this: var xxx = new ActiveXObject(" MSXML2.DOMDOCUMENT.4.0 "); if yes I think Alex Feldstein has right . Codes are in xsource folder. What code do you need Someone on a foxpro thread said I need VFP9 SP2 but I can't find that anywhere. C ...Show All

• enric vives Combo in Grid with Incremental Searching

  Hi all I know we can put a combo into a grid and seen in a previous thread a link to Marcia's example on her web site ( http://www.tightlinecomputers.com/Downloads.htm ). However, whenever I put a combo into a grid, the incremental search (based on the interactive change) never works. I can post my code, but just need to know if I'm flogging a dead horse or not. Thanks   Thanks for the reply. Never really thought the incremental search for Combo's was any good.  In the grid, you have to set the typing delay and it is poor.  If didn't work very well.  I would like the validation on the combo itself so it only lets you type what is in the combo.  My code ...Show All