Visual FoxPro

Page 125




  • Topics
    Replies
    Last post
  • Multiple Dataset in the same table object
    by Zoop
    18 Replies
    Last post by Zoop
      • Hi, I'm pretty new in ReportViewer. I would like to show fields from two differents db tables in the same table object. Example : I have an object inside my object datasource. Let's say, an "Employee" object (which is my datasource), containing a "Company" Object, and I want to access a property of the Company object. Automatically the datasetname is set to "Employee"
  • asp.net with foxpro database problem
    by GCS
    8 Replies
    Last post by CetinBasoz
      • hi i use .net framework 2.0 to build asp.net pages but i use a foxpro data base , so i faced by a problem when i publish this pages , and when browse it from iis , i can display the page but the controls such as combobox which should be filled from the foxpro database ,is empty so my pages cant retrive the data from the foxpro database note :- when i run this pages from the CLR , its ok
  • programmatically finding out if dbf is part of dbc??
    by drhoades32
    5 Replies
    Last post by drhoades32
      • I'm going through a directory that has free tables and a dbc. I can get all the dbf names and info, but I don't know how to identify if a dbf is in the dbc or is a free table. Is there a function that will give me that info or does someone have code that pulls this out of the dbf header file Thanks!!! ** Code snippet with problem in red below** ADIR(laArrayTables,".DBF","D",
  • cursors and html
    by jmom
    18 Replies
    Last post by jmom
      • I run a query and and information is stored into a cursor. In VFP 6 I can open a report and preview it with cursor and save it as html. In VFP 9, I do the same thing. When i choose to save it as html, the open dialog box pops up. Since info is in cursor, I can't choose a table. Then the GenHTML error stating the htm could not be created. Is there something I am missing
  • 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
  • VFP9::Printer setup with 'modify report' problem
    by Damien559424
    8 Replies
    Last post by Damien
      • Hello, I have two questions around the report and printer setup 1 - We encounter a strange behaviour on two different computers when using the same software : in our software, we have a command button that do a "modify report" command, in order the user can modify his report. When using this command button we have the "file / page setup" menu available. On one c
  • move question
    by dvidal
    4 Replies
    Last post by Alex Feldstein
      • Hi again, I want to know if there is a function or command to move a file in visual fox pro 7. For example, if i want to move 'c:\users\pru.dbf' to c:\myapplicaction\pru.dbf. Thanks,
  • vfp8 code errors in vfp9
    by orderinc
    11 Replies
    Last post by orderinc
      • The following code snippet works fine in VFP8 but the 'use (mfile)' invokes the catch code in VFP9. When running without try catch, use (mfile) simply does nothing the 1st time it is run, but does open up the file the 2nd time it is run. I am deleting the CDX file previous to this code being run. mfile=mmomfile select 0 try mtagfound=.f. use (mfile) mi=1 milen=30
  • 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
  • Importing data from Excel into a FoxPro Memo field
    by MartinnitraM
    4 Replies
    Last post by Naomi Nosonovsky
      • Hi I'm trying to import data from an Excel spreadsheet into a Foxpro v8 memo field using the APPEND FROM command something like this, but the field is blank after I run the append. CREATE TABLE "C:\Blah\TESTMEMO.DBF" NAME "TESTMEMO" (TESTMEMO M NOT NULL) APPEND FROM "C:\Blah\TESTMEMO.xls" TYPE XL8 SHEET "SHEET1" Any ideas how I can do this Th
  • VFP to SQL2005 OLE DB "errors"
    by ed_hand
    8 Replies
    Last post by ed_hand
      • I'm trying to bulk load tables in SQL 2005 from a Visual FoxPro 7 database. We have the latest VFP OLE DB driver loaded and have run into an odd issue. When viewed from the table designer in VFP the tables have all columns set to not null (null column is not checked). However there are lots of rows with "empty" values for columns with both numeric and date data types. When I run a
  • printing report in vfp as excel grid lines
    by vineet4001616
    3 Replies
    Last post by Naomi Nosonovsky
      • How i print report as excel grid lines in vfp can you give a source code to generate report as excel report printing with gride lines vineet
  • Full Screen Question
    by Yin Lai
    14 Replies
    Last post by Yin Lai
      • I am using visual foxpro 7.0. I need to set my program to full screen and limit the user option. That's mean, user just can use that computer to key data using the program and cannot do anything else (cannot open other program) except if they log out. Hope some expert can help me solve the problem. Thank you very much.
  • Report pulling incorrect data
    by MauriceHErbst
    5 Replies
    Last post by Rick Borup
      • I am modifying an existing report and program and have attempted to add the new fields to the cursor the report runs but instead of the actual last labor date I am getting whatever is in the first record in that corresponding field in that table. I believe it is in the SQL statements but cannot get it to pull correctly no matter how I modify it. I have ran this query as a view in SQL 2005 and i ge
  • Help with expression (one more time...)?
    by Littletommy
    14 Replies
    Last post by Littletommy
      • Hello All...many thanks to all who helped with my previous post. I have hit one more 'snag' in preparing my data. Here's a sample of three fields in my table... MRC REQUIRED DETAILS 4720-00-001-0057 ADLF HOSE OR TUBING SPEC/STD DATA MIL MIL-H-5593,SIZE 4 SPECIFICATION ADJM INNER CONVEYING TUBE MATERIAL
  • VFP6: Problem saving data
    by MillBear
    6 Replies
    Last post by AndyKr
      • Hi all The VFP database system is running in the server so that all the workstations can share it. The user complained that she could not save the data after amending. I tested to see whether I was able to save it on my side. It works successfully. I went back to the user¡¯s workstation to verify it but still the same problem. I tried other workstations and found no problem so far.
  • Modeless Forms & with different datasets
    by Gary Demi
    4 Replies
    Last post by Lonny R
      • I have a modeless form with a listbox. I populate the listbox in the form.init method with a sql select statement. i.e. select * from mydbf into cursor curMyList for ..filter.. (where filter is a passed parameter to the form) with thisform.list1 .RowSourceType = 2 && Alias .RowSource = 'curMyList' .requery() endwith This works fine but all copies of the form end up using the same data
  • Memory leak in COM Server when passing array data?
    by Michael S.
    3 Replies
    Last post by CetinBasoz
      • Hi, I'm trying to investigate why calls to our VFP COM Server seems to leak memory and hopes somebody can explain what is wrong. When following the memory consumption on the COM Server process instance in the Windows Task Manager the 'Mem Usage' explodes. I've created a scenario involving VFP and VB that seems to reproduce the problem. I'm using VFP 9 SP1 and VB 2005 (as included in Visual S
  • date question
    by dvidal
    2 Replies
    Last post by Alex Feldstein
      • Hi, Someone knows if there is a function or something like that in fox 7 to calculate the difference between two dates. Thanks,
  • How to open a tiff file ?
    by c y h
    7 Replies
    Last post by Naomi Nosonovsky
  • date question
    by dvidal
    2 Replies
    Last post by Alex Feldstein
      • Hi, Someone knows if there is a function or something like that in fox 7 to calculate the difference between two dates. Thanks,
  • visual foxpro free tutorial
    by Lakshmi N
    3 Replies
    Last post by Carl Warner
      • Can anybody know web site where FREE visual foxpro tutorial is avilable for people who want to upgrade from fox on dos and fox for windows 2.6.
  • Copy to delimited
    by BigFoz
    4 Replies
    Last post by BigFoz
      • Hi, I need to be able to create a standard ASCII file delimited with tabs. However the default for the command: COPY TO file .txt DELIMITED WITH TAB produces the character " wrapped around all fields. Does anyone know a way of producing a standard tab delimited file without the " characters Cheers, Paul.
  • DELETE / PACK
    by AlexBB
    8 Replies
    Last post by AlexBB
      • I am wondering if a statement can be construed which will do DELETE (record) & PACK on the same command line. If it is possible I would prefer to run just one command from .NET rather than two. Thanks.
  • VFP Fax Integration
    by emery
    10 Replies
    Last post by emery
      • Hi, I tried #2 method and stuck. Then I tried #1 method, it works for report with graphic. However, I need a way to pass parameters to Send Fax Wizard. Thanks for your help. Emery ------------------------------------------------------------------------------------------------------------------------------ Method #1: When I used the following code to fax