Visual FoxPro

Page 61




  • 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
  • image from webcam
    by NILKAMAL
    4 Replies
    Last post by dni
      • hi! one more question i use before ms access in access i bought dbpix but how do i do in foxpro so i can take image from webcam and save for record thanks
  • Record count of a table
    by Ahsan Amin
    3 Replies
    Last post by Alex Feldstein
      • i am trying to make a program that will 1. pop up a file open dialog box using a mouse click on a button on form 2. user will select a dbf file and it will be stored in variable 3. i want to count no. of records in table using this variable I am trying to write the following code but does not work: private gcTableName as Character CLOSE DATABASES CLOSE TABLES OPEN DATABAS
  • Fax Report Using VFP9
    by emery
    11 Replies
    Last post by emery
      • As resolved in "VFP Fax Integration" thread , I have been using Jaime's method to fax Reports with graphic/image and it works very well for VFP6. set printer to name "Fax" report form myReport to file "myfile.tif" noconsole Recently I compiled and ran my program using VFP9, I got the following Program Error: OLE IDispatch exception code 0 f
  • 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
  • Outlook contact details
    by hangover
    14 Replies
    Last post by CraigBoyd
      • This might not be the right forum for this question given that it mainly concerns Outlook (although I am accessing it from VFP), but I am hoping that one of you smart and helpful people may know the answer ... I am trying to obtain to populate a VFP table with the details that I can see in my Outlook 2002 address book. I have had some success at obtaining details such as Name, Email
  • Farewell
    by AndyKr
    10 Replies
    Last post by Joe Morel - MSFT
      • Recent events, and postings, in this and other forums have convinced me that I am no longer able to act as a moderator in this forum and have asked that my moderator's privileges be withdrawn. I shall no longer participate in this forum and hope that whoever takes on the task will do a better job than I. Later: I have been asked to say where I can be found outside this fourm so yo
  • Filename and nullchars
    by DaCosta11
    6 Replies
    Last post by DaCosta11
      • I hope everyone had a good xmas and santa gives you a lot of presents :) Now, my question: try this code in VFP9: pParam1 is a parameters which contains a folder name. The folder must contains EMLs, but can be another file, just change the extension. cString =pParam1 + Chr(0) nEMLs =aDir(aEMLs, pParam1 + "\*.EML") For iEMLs =1 To nEMLs cString =cString + aEMLs[iEMLs, 1] + Chr(0) EndFor
  • go to googleearth
    by bijansaba
    9 Replies
    Last post by Naomi Nosonovsky
      • Hi i Hi i want tape name of one city as TEhran in a textbox and click on one boutton and automatic go to show this city in googleearth what must i do thank you
  • Memory Pointer from ADODB.Stream
    by CChalom
    10 Replies
    Last post by CChalom
      • I need to Save an Image to a Stream using GDI+ Rick Strahl suggested me to try using ADODB.Stream To make it work, I need to obtain the Handle, the memory pointer that ADO reserver for my Stream This handle will be passed to GDI+ further I've searched all over the web, but did not find any tip on that... Maybe I didn't look at the right places... Any tips Below is the code that I want to use for
  • Arrange the "character string" numbers in order
    by MillBear
    6 Replies
    Last post by CetinBasoz
      • 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
  • Report Output - Revised
    by Brian Branco
    1 Replies
    Last post by AndyKr
      • My prior example was not correct... I have a client with the following reporting requirement. An example would be the report would run off A/R data and the customer uses the source field to categorize customers. Customer A - NJ1 - Invoices dated 03/01/07 - 03/09/07 Customer B - NJ2 - Invoices dated 03/10/07 - 03/31/07 Customer C - NY1 - Invoices dated 03/15/
  • Copy File Error in Visual FoxPro 7?
    by Paul B Walker
    7 Replies
    Last post by Tamar E. Granor
      • When a COPY File Command is executed and a space is in either a folder name or a file name, the instruction is unable to handle it. I have tried a technique to put in " quote marks in the manner '"<path><filename>"' but then it gives me a syntax error. Is this a bug or am I entering the full path and filename wrongly If this is a known bug, is there a patch for it If not
  • Empty Picture Box
    by dalegoble
    6 Replies
    Last post by CetinBasoz
      • I have a form with a picture box. I store the path to the photo in a table and retreave it to show the picture, works great. But what i need to do is when there is no picture on that record make the picture box container non visable on the form. Can I do this with code Thanks Dale
  • how to escape from valid event
    by RavindraPatil
    6 Replies
    Last post by Naomi Nosonovsky
      • Hello, Suppose an user is adding a record and he is on a field which needs validation. He tries for long time but can't enter valid data. So he wants to give up and exit from the form. But he cant click anywhere without entering valid data in that field. In such case how to help the user to exit pl. help
  • why does Read Events release Main window
    by Hao Q.
    14 Replies
    Last post by Hao Q.
      • Sorry if this topic has been brought up before... I'm working project, which I set the main window as modeless. In order to prevent the form to be released at the time of initialization, I put THIS.SHOW and Read Events in Main.Init. However, after the form is initialized, the object main for main window is released from the memory (I view status of variables in the debugger window). If I'd like t
  • Will VFP6 work with Windows Vista
    by Derek Dowle
    13 Replies
    Last post by CDFAUX
      • My company operates a series of VFP6 runtime databases successfully in the Windows XP environment. We currenly have one PC loaded with Windows Vista. When the runtime setup is run it does not install the runtime files onto the Vista PC. Can VFP6 work in the Windows Vista environment How can this problem be overcome Many thanks in anticipation.
  • Object assisted report in dot matrix printers
    by Junar
    2 Replies
    Last post by dni
      • I encountered a problem using object assisted reporting. Preview works fine but when I tried printing it in dot matrix printers like Epson FX-890 or Epson LQ-2170, it printed smaller fonts and the whole letter size paper was only printed 3/4 of its size, what could be the problem To further determine the cause of the problem, I tried printing it using report behavior 80 and it came
  • Little Doubts with ListView....
    by Paramu
    5 Replies
    Last post by Markish
      • Hi There, Well. & Thanks in advance. Actually I added a table data's to Listview...But I want to locate my cursor in Listview ...according to my Textbox...value... for that any Command same like Locate for.... My Codings...For Data's added in ListView.. ---------------------------------------------------------------------------------------------------------------
  • refresh form
    by NILKAMAL
    14 Replies
    Last post by Naomi Nosonovsky
      • hi! i create simple form with table field and i create another two textbox in sam form (which is not table field) when i go to next record the table field got refresh but other two textbox have same value of previous record so can anybody tell me how do i do to refresh all field including textbox( not table field) thanks
  • Determining if multiple EXCEL spreadsheet tabs exist before import
    by GR1206
    14 Replies
    Last post by Naomi Nosonovsky
      • Is there a way to determine if an EXCEL spreadsheet contains multiple tabs, and if so, bring back the name of each tab in order to select the one that you want to import data from I'm trying to import data into VFP from EXCEL, and normally use the IMPORT function and identify the spreadsheet tab by name. This time, I want to know 1) the total number of tabs in the spreadhsheet, and 2) the
  • Combobox Default Value
    by Derek Dowle
    6 Replies
    Last post by Derek Dowle
      • I am using a combobox on a form in VFP9. The form has a series of comboboxes which assist the user in filtering records. Each combobox has RowSourceType = 2 and RowSource = "the name of the cursor" Each combobox displays the correct list of options when the form is run. When the form is run all the boxes appear empty. I need one of the comboboxes to display a default v
  • how to get around processing a field if a command button is clicked.
    by ibbm
    8 Replies
    Last post by Naomi Nosonovsky
      • I have a data entry screen with fields that get validated and command buttons on the bottom to add, save, delete etc. when the cursor is on a field that has a valid event and I click on Save, the valid event happens before the save. I want to override all field validations if a command button is pressed. How do I do this Thanks in advance.
  • find path of desktop users
    by bijansaba
    3 Replies
    Last post by Naomi Nosonovsky
      • hi i wnat find the path of desktop user and save my file on it
  • Proper practice - using class properties in forms/reports.
    by Aleniko
    11 Replies
    Last post by dereck27
      • Hi all; A pretty simple question: lets assume I have a class which is used for entering a range (customers, dates etc). It consists of 2 text boxes. I am dropping this class into a form which is producing a report. My question: What is the common/best way of accessing the control source of the textboxes in the class I can do any of the following: - Access them directly by their relative names (ie