Visual FoxPro

Page 218




  • Topics
    Replies
    Last post
  • printing control on foxpro 6 reports
    by ibbm
    6 Replies
    Last post by Naomi Nosonovsky
      • Is there anyway to control the printing on reports when in preview mode so that you can print a selection of pages instead of all pages When I hit the print button it doesn't give me any printer options, it just prints. Thanks in advance.
  • Remote Debugging?
    by AHerman
    4 Replies
    Last post by Naomi Nosonovsky
      • Hello, I am looking to see if anyone has experience with a way to debug VFP applications without going through the entire VFP install. I would like to be able to install/run some sort of debug tool at my client sites while I am connected to their server via RDP so that I can debug specific situations without having to be on site or have VFP installed on their server. Does anyone
  • REPLACE command help wanted
    by AlexBB
    14 Replies
    Last post by AlexBB
      • If not mastering counter intuitive VFP object manipulation was not hard enough in the past until I finally got a handle of it, now trying to do it from OleDb .NET code is like moving through heavy water--it is 10 times more difficult. I thought I reached the promised land when I finally made PACK work but my joy was premature. Now INSERT gives me the same trouble. I really prefer to
  • Some questions about VFP
    by Ahsan Amin
    8 Replies
    Last post by Cindy Winegarden
      • 1) When i delete a record from VFPs table, it is marked as deleted but not deleted permanently. How to delete permanently 2) How to select select the records that are not marked in a table 3)iF i use 'Clear' method in a form, the control that are placed on form start vanishing, how to stop that
  • MSCHRT20.ocx erro
    by Christina853
    7 Replies
    Last post by Dietervd
      • I have just restored a machine in which a program is loaded for testing. (I am not the programmer I was just hired). When I try to start the program i get the following error; mschrt20.ocx or one of its dependencies is not correctly registered. I did a full restore from backup to the new machine. The program will not start. Any Ideas I am not a seasoned programmer I am a network adminis
  • Passing multiple variables from forms w/ VFP7SP1
    by KDKephart
    14 Replies
    Last post by Naomi Nosonovsky
      • 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
  • Application cannot run after compile
    by Sixon
    14 Replies
    Last post by Sixon
      • I have a visual foxpro project and compile it in Win32 system application, with Build in the project. But after compilation, the program cannot run. When complie it, I've including the VFP9.DLL and VFP9RENU.DLL files in the project directory.......Please help me...thank's....
  • Request to Refrain from Linking to UT Threads
    by AndyKr
    14 Replies
    Last post by AndyKr
      • I have removed the posts on this topic, and combined them, into a single, separate thread to avoid cluttering up a genuine quesion: Naomi Since you have withheld your E-Mail address I must post this caution publicly. Please do NOT refer to "for-profit" sites - like the Universal Thread - in replies on this forum. The reason is that the Universal Thread is not
  • VFP / ODBC driver / Insert statement / General field
    by Tobias Bendschneider
    3 Replies
    Last post by CetinBasoz
      • Hello, I want to insert a new record in a table (let¡¯s call it "customer") via the vfp-ODBC driver. The customer - Table has one general field in it, wich does NOT allow null values. (The other fields are no problem, I think...) How can i write a sql-Statement wich works Thank you for your help
  • How to remove redundant phrase in field?
    by Littletommy
    14 Replies
    Last post by Littletommy
      • Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown abo
  • How to Copy 2 worksheet from one excel sheet to to 2 Worksheet of another Excel Sheet
    by aditya_050484
    3 Replies
    Last post by CetinBasoz
      • var xlApp, xlWB, xlSheet,f2,fso,oBook,oSheet,oBook1,oSheet1,idTmr; xlApp = new ActiveXObject("Excel.Application"); fso = new ActiveXObject("Scripting.FileSystemObject"); if(fso.FileExists("c:\\Example.XLS")) { f2=fso.GetFile("c:\\Example.XLS"); f2.Delete(); } xlApp.Visible = true; xlApp.DisplayAlerts=false xlWB = xlApp.Workbooks.Add(); xlWB.Sh
  • Search Company function: Type any letters to find a few similar company names
    by MillBear
    8 Replies
    Last post by CetinBasoz
      • Hi all   I create the form to search the company name. I have the long list of company codes & names inside the table (company.dbf).   Form Designer Company Name : <Text1>   <Grid>   Code    |    Company Name     Search Command    Exit Command        For
  • Special functionkeys in forms
    by StevenAnonymous
    1 Replies
    Last post by MarciaAkins
      • Hallo, I put some code in the method of my form. (in a formset) example. Method KEYPRESSED (in form) LPARAMETERS nKeyCode, nShiftAltCtrl DO CASE CASE nkeycode = 28 && F1 THISFORM.addnewclient.Click .... CASE nkeycode = -11 THISFORM.exit.Click ENDCASE RETURN When i run the program. the first time it goes well but the second time my function k
  • webbrowser newwindow event
    by Ivan Horvath
    3 Replies
    Last post by Warappa
      • Dear All, in our application (VFP7) we are using MS WebBrowser control. it is working well, except in one case. we don't allow the new window action. according to the documentation the NewWindow2 event is fired when the user tries to open an url in a new window (right click - selecting Open Link in New Window menu, shift+click, etc). i can catch this event, and returns as cancel=.T. everything
  • problem with buffering table same open
    by aldo joan
    1 Replies
    Last post by dni
      • hello friends: I'm trying to migrate my aplication made in vfp 7.0 to vfp 9.0 . for example: in the invoices forms, i have the table buffering=4 , but in the same table I have other alias, but there are not have table buffering. so at the time, when I clik a replace, it does not update the information to me, until I move the leader or until I clik in tableupdate whit buffering I had these pr
  • finding duplicates with a query with fox 6 or 9...
    by ibbm
    12 Replies
    Last post by ibbm
      • Is there anyway to do a query that displays only duplicate records Preferrably in 6 as I'm not ready for v9. Thanks as always!
  • 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
  • adding a jpeg file address to a field
    by nebraskajanice
    8 Replies
    Last post by skipdcm
      • First, let me apologize as I am real old user of FoxPro 2.0 and have just gotten back to FoxPro via version 9.0 so I am extremely "dumb" but willing to educate myself. My application is: I have a table that contains a number of inventory items. I want to add a field that contain an address for a jpeg file of that item for serveral different reports. Can it be done Thank you in
  • What fires first Init() or Load()
    by rpp
    8 Replies
    Last post by MarciaAkins
      • Does the Init() procedure of a form, fire before the Load() procedure of the form. I am trying to use a SQL Select in the Load() of a form with a passed form property from a ComboList box [a value set within it's Init()]. I had hoped to initialize the passed property before the Forms Load() event and its SELECT-SQL ran, then optionally let the user select different values in the ComboList b
  • Calling a listbox from PRG
    by Eddie N
    4 Replies
    Last post by Eddie N
      • I put the following function in a PRG. It displays properly, but every time I call this function and click the list, it returns an arbitrary string, blank or otherwise. What should I do Code Snippet FUNCTION ASK_s i = 1 condition2 = ssoundex (my_word) frmShow.listbox1. clear do whil i < 6 .and. ssoundex (my_word) = condition2 frmSh
  • "Data provider or other service returned an E_FAIL status" accessing particular table using ADO
    by Darren Woodford
    6 Replies
    Last post by Darren Woodford
      • Please can you help I am accessing some tables using ADODB and when accessing a certain table I am getting the error message "OLE IDispatch exception code 0 from Microsoft Cursor Engine: Data provider or other service returned an E_FAIL status..." This occurs when I use loRS.RecordCount loRS.Sort or after 56 loops of the following code DO WHILE !loRS.EOF
  • Write a FoxPro report to a Word file
    by Bob Gatto
    2 Replies
    Last post by CetinBasoz
      • How can I take a FoxPro reportst and write it to a Word file. I want to be able to open the saved file with Microsoft Word and see everything I saw in the PREVIEW of the report. I used report listeners to write an HTML file. Could I some how use the same thing for Word Thanks, Bob Gatto
  • C++ to VFP Translation?
    by Cody King
    14 Replies
    Last post by CChalom
      • First, I'll have to admit that my coding skills have been unused for several years now, but this is one thing I believe that VFP should handle no problem. Here is the setup: This program gets data from an A to D board and it utilizes DLPORTIO.DLL to address the parallel port and go thru 8 channels. (I know.... old school...but that's why I got it!) I've done the Declare statements t
  • image from file
    by NILKAMAL
    9 Replies
    Last post by Naomi Nosonovsky
      • hi! how do i replace image from file here is my code DO [C:\Program Files\EZTwain\VFP\EZTwain.prg] TWAIN_SelectImageSource(0) * Get list of devices into memory TWAIN_GetSourceList() LOCAL lcFile, lnImageHandle, lnReply lcFile = "C:\Documents and Settings\sony\My Documents\New Folder (2)\IMAGES\IMAGE.jpg" * Get the image lnImageHandle = TWAIN_AcquireNative(0,0) repl
  • SQL Select help.
    by Aleniko
    3 Replies
    Last post by Aleniko
      • Hi; I'm using this command: SELECT polgr.pono,po.podate as podate,polgr.design,polgr.qopen,IIF(isnull(poarrivals.design)," ","Y") ; FROM; krcbp!polgr ; LEFT JOIN krcbp!po ; ON polgr.pono = po.pono ; LEFT JOIN poarrivals ; ON polgr.pono = poarrivals.pono ; WHERE polgr.design = "SU-115" AND polgr.qopen <> 0; ORDER BY podate But I'm trying to get on