Visual FoxPro

Page 88




  • Topics
    Replies
    Last post
  • Using a JOIN when communicating with SQL from VFP6
    by mrfitness
    4 Replies
    Last post by Alex Feldstein
      • I created two programs in which both connect to SQL database to execute a SELECT query. The first one is a straight forward one with one table and works fine when I display info SQLEXEC(m.lnConn, 'SELECT * FROM Cluster_info', 'cinfo') scan cinfo.cluster_name The second one is trying to JOIN a table and a view. I first went into SQL and used the query view to select and join my table/view to automa
  • How to email with Chinese characters
    by Joe Au
    2 Replies
    Last post by Joe Au
      • I used the code provided by Dave M. as follow: loConfig = CREATEOBJECT('CDO.Configuration') loCdoMessage = CREATEOBJECT("CDO.Message") loCdoMessage.Configuration = loConfig loCdoMessage.From = "info@wantit.nl" loCdoMessage.To = "info@microsoft.com" loCdoMessage.HtmlBody = "Body text" loCdoMessage.Addattachment("c:\file.doc") loConfig.Fiel
  • Little Doubts with Reports - Tables Area...........
    by Paramu
    6 Replies
    Last post by Orkutian
      • Hi there, I have a problem with my reports preview. Actually I used a free Table and its used in area12 [Select 12] in a form. And the Report - Preview is through a command button of a Form¡­ In Command- Window the report is working good [ie. . Do form ¡°abcd1.scx¡±]. At the same time after compiling EXE, if I click the button its¡¯ saying error something like¡­ ¡­¡­¡­.. ¡°File Does not exist¡± But i
  • Thumbnail -Images
    by MM ROy
    10 Replies
    Last post by MM ROy
      • Sir, I am using Visual FoxPro 6.0 version. I want to view (like thumbnail) all the images of a folder (.jpg, .gif, etc.) using with visual foxpro form. The number of images may be varying. I have no idea....Please help... Roy MM
  • How to select a record from a Grid and open a form
    by msw
    14 Replies
    Last post by msw
      • Hello, I'm new to VFP 9, but I'm working at it.. I have a simple form that displays a Grid with my customer records. I would like to double click and or press the enter key on a given record on the grid and open a form to make editing earier and then return to the grid when I'm done. Can anyone give me some help with this... Thanks...Scott
  • Off the screen
    by zahj
    8 Replies
    Last post by dni
      • When i compiled my program as an application, i didn't experience errors while running it. but when i compiled it as an executable program, i get an error that says " ROW OR COLUMN POSITION IS OFF THE SCREEN" I tried compiling it again but i still get the same result. Application is ok but executable is not ok... Help me out please...
  • Side effects of leaving SET STEP ON in code
    by FoxCreek
    13 Replies
    Last post by Tamar E. Granor
      • If we forget to remove a SUSPEND command before deploying a VFP program, the program will throw an error saying ¡°Feature not available.¡± However, if we forget to remove a ¡°SET STEP ON¡± command, the deployed program will not error, but will function as desired, acting as if the ¡°SET STEP ON¡± was not in the code. Are there any known ¡°side effects¡± of leaving a ¡°SET STEP ON¡± command i
  • Error Installing VFP VS_SETUP.MSI
    by 12l
    14 Replies
    Last post by Anonym_123
      • ReInstalling VFP9 en mi W2k3 Standard SP1 the error message: "The windows installer: z:\vs_setup.msi could not be opened. Setup will not continue. This is a default response to an error. If you see this please save log files and RAID a bug." What happend Thanks
  • REPOST: NOPAGEEJECT not working in VFP9
    by riptramm
    14 Replies
    Last post by Tamar E. Granor
      • If our OKI Microline 320 turbo printer always ejects a page after the command <<REPORT FORM myreportfile.frx TO PRINTER NOPAGEEJECT>> in a program, is this in all likelihood a VFP 9 software bug or is there a simple solution other than printing to a text file Could it be a faulty installation Also we've found that in printing 40 reports using VFP9 report forms, 3 or 4 will print out
  • caps and number lock
    by jmom
    5 Replies
    Last post by jmom
      • Maybe this is an issue with terminal services, but when a user uses a exe through terminal services, I check on the user's caps and number lock using the numlock() and capslock() and store it to a variable. Then I do a numlock(.t.) and a capslock(.t.) statement right before they do a form. Right before leaving the main form in an exit button, I have a capslock(<variable1>) and a numlock(<
  • Drag and Drop with Listbox
    by hangover
    10 Replies
    Last post by nautic20
      • I have a control consisting of two listboxes which allow the user to drag and drop items from the left listbox to the right listbox to copy them across, or drag and drop items within the right listbox to change their order. I have got the mechanics of it working reasonably well using the OLEDragDrop methods of the listboxes, however it is not as slick as I would like. There are three improv
  • How to 'multithread' ServerXMLHTTP in FoxPro 7?
    by SJH22
    8 Replies
    Last post by Claude Fox
      • So, Ive got a dilema and maybe some of you can help me. Im using ServerXMLHTTP as an object to download about 500,000 web pages and I need to figure out how to run multiple instances of XMLHTTP. For simplicity sake, this is what I have right now: objXMLGET = CREATEOBJECT('MSXML2.serverXMLHTTP') FOR x = 1 TO 500000 ThePage = " http://webpage id =" + STR(x) objXMLGET.Open
  • type question
    by dvidal
    1 Replies
    Last post by Rick Borup
      • Hi, is there a function to retrieve the datatype of a fox table field . For example, how will be the code to check if the field employee_name (from a fox table employee) has datatype character. I found a function type(), but I want to know if there is an easier way to do this validation. Thanks,
  • Foxhelp index and search pane is empty and not working
    by S&amp;#225;ndor T&amp;
    4 Replies
    Last post by Sandor Torok
      • Hello, I have VFP6 and VFP8 in my notebook under Windows XP SP2. There was an error opening any html help: "Cannot Open the File: Mk:@MSITStore:<any>.chm" I found in one of the forum the next commands to do in the CMD window: regsvr32 %systemroot%\system32\hhctrl.ocx <press enter> regsvr32 %systemroot%\system32\itss.dll <press enter> After them the foxhelp a
  • Comparing VFP table Records with an Oracle database table
    by kuuku
    1 Replies
    Last post by AndyKr
      • I have table AB which is a VFP table and table CD which is in an Oracle database. Is it possible to compare the records in table AB with that of table CD and then create a new table in VFP for the records in AB not in CD using VFP and if so how is it done
  • how to enclose quotation marks in a string...
    by ibbm
    7 Replies
    Last post by ibbm
      • I am trying to use this statement thisform.lstSearchList.RowSource = "select branch,clientcode,alltrim(lastname)+ '", "' + firstname,ffid from &lcf where upper(lastname) = alltrim(upper(lcCheckValue)) order by lastname, firstname,branch,clientcode into cursor temp" but it doesn't like the + ", " obviously as it's already enclosed in a string. Can
  • 'Copy File to' command using variables
    by mrfitness
    3 Replies
    Last post by mrfitness
      • I am not sure why I am getting an error, maybe someone can help figure this out I have used the code before and it works fine, it copied an excel sheet from the server and pasted it into the folder I was working in and renamed it. I am trying to copy an excel book that its purpose is simply being a blank book to copy and populate values in. I am using a variable to name the new excel book. I am us
  • Virtual keyboard problems
    by RickyPontes
    4 Replies
    Last post by RickyPontes
      • I'm building a Virtual keyboard in Fox Pro. So far no problem, but now i'm having some problems with the cursor keys and delete key. This is the code I'm using for the A key click and it's works fine. DOEVENTS force keybd_event(65,0,0,0) keybd_event(65,0,2,0) DOEVENTS force but the delete key and cursors key it's not working. I'm using code 46 for the delete key and 37,38,39 a
  • Get external IP adress
    by miltoncwb
    7 Replies
    Last post by Naomi Nosonovsky
      • Dear Experts, How can I get the external IP from a vfp program just like I visit www.checkip.org Thanks you in advance. Milton
  • DBF Viewing on DataGrid?
    by rattlesnake316
    5 Replies
    Last post by CetinBasoz
      • How to connect and view a DBF File on the datagrid What command can be used to SELECT Data on the DBF File Also what provider to choose to connect to a DBF File Hope someone could help me. Thanks in advance!
  • Display "Running query..." progress bar
    by hangover
    10 Replies
    Last post by Naomi Nosonovsky
      • How do I make the "Running query..." progress bar display when executing an SQL query within my VFP9 application I have tried both SET TALK ON and SET NOTIFY ON but it is still not displaying. Which other commands can affect whether it is displayed or not Thanks.
  • Future of Visual Foxpro
    by FoxyNet
    14 Replies
    Last post by Craig Berntson
      • 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 product
  • Using VFoxPro 9 and SQL to create a table
    by Zaphod2003
    9 Replies
    Last post by Zaphod2003
      • Can someone tell me what's wrong with this code CREATE TABLE countries( ; id n(10,0) PRIMARY KEY , ; ccode c(2) UNIQUE , ; CHECK ( LEN ( ALLTRIM (ccode))=2) ; ERROR "Currency code must be 2 characters", ; currency n(10,0), ; CHECK ( currency >0), ; cname c(30) UNIQUE ; ) I have indentified the problem to be with the code CHECK (
  • slipstream VFP 9 with SP1 ?
    by bimalr1
    3 Replies
    Last post by Stuart Dunkeld
      • Anyone know how to slipstreaming Visual FoxPro 9 with current SP1
  • Data Environment
    by Gemstones
    6 Replies
    Last post by Gemstones
      • In developing an application must I have the tables I am saving data to or accessing information from in the data environment of the form or can I access them by using the USE command. Also if I don't need to include the tables in the data environment what are the pros and cons of including them. My application is a multi-user one where most times more than one user is accessing the same form at t