Answer Questions

• Joel40096 newbie here...

  hi to all... i have a form named customers and i have txtboxes to input all information i needed. i have a grid that shows all the records in the table customer. works fine on loading. now, i have 2 buttons previous and next respectively. my codes are as follows: Previous Button: USE customer if not BOF() skip -1 thisform.refresh() if BOF() go top endif endif Next Button: USE customer if not EOF() skip thisform.refr ...Show All

• JoshRoss _urlcombobox problem

  I am trying to use this object since it offers much convenience as opposed to shellexecute. This is the problem I run into. When I issue commands in INIT: THIS.AddItem ("www.msn.com",1,1) THIS.AddItem("www.yahoo.com",2,1) THIS.AddItem("www.pdr.net",3,1) The items appear in combobox doubled. This set of urls is repeated twice! Not every url is doubled individualy but the whole set of three urls. This i ...Show All

• David Portas 2 open files for a foxpro.exe file being used by a particular user

  When you run a foxpro application exe file that is located on a server from a workstation it will display 2 instances of the application being accessed by a particular user. You can verify this by going to: Control Panel/Administrative Tools/Computer Managment/Share Folders/Open files. You will see 2 open files for a foxpro.exe file being used by a particular user. This seems to only happen with foxpro applications. Why is this By defau ...Show All

• Luis P Clearing a cursor

  I am working with a cursor that I use to import XML information to. When I am done with the XML information, I want to clear the cursor for other input from the same area; however, I am unsure as how to go about this. Any ideas >Are cursors R/W by default CREATE CURSOR ( ... ) cursors are read/write by default. Cursors created by a SQL-SELECT are not. Hi Dave Ahem....if I may be permitted to extend your note.... ...Show All

• RGIMatt VFP8.0 Chaining Reports

  I have an app that used to run correctly. A few weeks ago I got hijacked and haven't been able to configure the reports correctly again. Here's the scenario: I have an HP LJ 9000 which has the ability to stack and staple and has four paper sources. The app gathers data and then prints a series of summary and detail reports. The summary report is printed on colored paper and the detail reports on letterhead, obviously from two different pape ...Show All

• Sudeep Ghosh How to visualize an SQL server table in MSDE?

  Hi! I want to visualize an sql server table in a grid, and then, modify my data, and upgrade the original table in sql with a button! Is it possible using sqlexec( ), and without using wizard tool Il I want to make a select in a sql server table, how I can visualize that in visual fox Thank you! Browse command opens in its own window. That's normal. If you want to view in a form grid then create a form and grid. Set grid's recordso ...Show All

• cdavid foxpro dos to visual foxpro 9 conversion

  I am trying to convert an existing application I created many years ago in foxpro 2.5 for dos, but when I try to run my programs I get this error: File 'get_last_key.prg' does not exist. Can anyone help me. I'm completely new to visual foxpro any help will be greatly appreciated. Thanks, bertle The sample code you showed basically sets the function keys to run a program called Get_Last_Key which seems to ...Show All

• Bill Altmann records disappear forom tables

  A few days ago I ran into yet another problem with Fox. i have a database where the tables were supposed to be filled with the content of some text files. Those files are dumps of my old dBase tables. I have a routine in Fox code that reads the text file, generates necessary number of records and fills the fields with the content between some delimiters in the text file. Anyway, it is not the first time I do it with almost the same code. I tr ...Show All

• Allan_M Can i do any control when i click the close button in the control bar of the form ?

  thank every one Hi there. Clicking the close button triggers an event calling the QueryUnload method. Any code there will run when you click on the close button. Hope this helps! yag Group Manager VS Data   jet su wrote: i means i want to pop one messagebox to make sure whether colse the form,but i don't want to use the command button to do this. so if i use unload or queryunload event,the form will be closed even u clicke ...Show All

• arianraj DO FORM does not work in exec (for me)

  I have close to 50 clauses, it turns out, DO FORM in my application. They all work perfectly well in interactive mode with the browser but do not work at all in exec after I built it. By "do not work" I mean that I do not even get an error message. Those statements are completely ignored. What I've done so far is trying to find a formula under which I could call outside forms. As I mentioned, when a statement DO FORM <formName> ...Show All

• Reggie Yim editbox control snaps.

  It is a fairly mild problem but still an inconvenience. I have an editbox and a text is assigned to it in the following manner: THISFORM.Pageframe1.Page4.Edit1.ControlSource = "(ThisForm.cData)" All other operations are done programmatically. I may force it to count the number of lines and go to a specific line and highlight it. It does. But then after a while, perhaps in about 2 minutes, it snaps to the first line (beginning of ...Show All

• xp2005 creating dll with add object inside

  my test-source (named "TestClass.PRG"): DEFINE CLASS video as custom olepublic ADD OBJECT VideoPlayer AS OleControl WITH OLeClass="MSComCtl2.Animation.2" ENDDEFINE oVideo=NEWOBJECT("video","testclass.prg") => OK oVideo=NEWOBJECT("video","testclass.dll") => Ok oVideo=CREATEOBJECT("testclass.video") => ERROR: "ClassFactory cannot sypply class" ...Show All

• Andrew Toner HOW TO START AUTOMATICALLY A .prg FILE!

  I have save my project in this folder: C:\Documenti\Visual Foxpro Projects\cescoproject In my project I have a example.prg file! In the form load procedure I have write: DO example But when I execute my program, foxpro return me this error: "File 'example.prg' does not exist" or "File 'c:\.....\another folder\example.prg' does not exist"! But if I go in the "Code section", and chose example.prg then the DO BUTTON ( red ! ), and next I'll ...Show All

• Carles Garcia Emailing attachements

  I searched the forums here looking for a way to create emails from Visual Foxpro, and found what I was looking for in another thread using this code provided here: #DEFINE olFolderInbox 6 #DEFINE olFolderOutbox 4 #DEFINE olMailItem 0 #DEFINE olRecipient 4 #DEFINE olRecipients 17 #DEFINE IMPORTANCENORMAL 1 loApp= CreateObject ("Outlook.Application") loNamespace = loApp.GetNamespace("MAPI") loFolder = loNamespace.GetDefaultFolder(o ...Show All

• CBoland-SARK creating dll with add object inside

  my test-source (named "TestClass.PRG"): DEFINE CLASS video as custom olepublic ADD OBJECT VideoPlayer AS OleControl WITH OLeClass="MSComCtl2.Animation.2" ENDDEFINE oVideo=NEWOBJECT("video","testclass.prg") => OK oVideo=NEWOBJECT("video","testclass.dll") => Ok oVideo=CREATEOBJECT("testclass.video") => ERROR: "ClassFactory cannot sypply class" ...Show All