Visual FoxPro

Page 1




  • Topics
    Replies
    Last post
  • Help me: build messagebox()
    by le tan duc
    9 Replies
    Last post by Naomi Nosonovsky
      • use API(), I want to build a function MESSAGEBOX() (as Messagebox() in VFP) (with it i don't want to fix my programs) (messagbox() i have build have parameters similar to Messagebox fuxnction in VFP) Thanks
  • Locking VFP rows from C#
    by 5p1d3r
    11 Replies
    Last post by Naomi Nosonovsky
      • We are wanting to create new records in a FoxPro database from c#. The database in question does not have autoinc, but has a 'sequence' table instead. The 'sequence' table has two columns 'file' and 'next_val'. To get the next primary key for the CUST table, simply: SELECT next_val FROM sequence WHERE file = 'CUST'; UPDATE sequence SET next_val = next_val + 1 WHERE file =
  • 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(<
  • Speeding up Foxpro - New Server - Multicore ? Xp V's Server
    by J Garland
    9 Replies
    Last post by dni
      • Good morning, I am looking at a new machine to speed up a db i have in foxpro. My quick question is for speed. Does Foxpro take advantage of Quad Cores over Duals and Is their a performance increase in Foxpro for Server OS instead of XP With Thanks Jason
  • Using VFP to bold a row in excel
    by mrfitness
    14 Replies
    Last post by Alex Feldstein
      • I have a program that returns the value of a query and places it into excel. But I also entered a row of static text as headers. I want to bold the columns I want without doing a statement for each individual cell to be bolded. I cannot remember how to bold a selection of more than one cell in one command line. i.e. .sheets[esheet].cells(1,1).Value = "Contractno" &&COLUMN HEADER
  • ERROR FOXPRO
    by JAY MANNELLA
    6 Replies
    Last post by dni
      • WHY EVERTIME I REBOOT MY P.C GET BOX MESSAGE, CANNOT LOCATE M.S VISUAL FOXPRO SUPPORT LIBARY
  • Extract the filename and extension
    by Bit
    2 Replies
    Last post by Bit
      • Hi, My program needs to feed in the filename components. Is there any command to extract the filename and extension separately e.g. Test.txt Extract result is "Test" and "txt" separately. Regards, BIT
  • 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
  • Southwest Fox 2007
    by Rick Schummer
    0 Replies
    Last post by Rick Schummer
      • Southwest Fox 2007 October 18-21, 2007 Arizona Golf Resort and Conference Center in Mesa, Arizona http://swfox.net It is our pleasure to announce the fourth annual Southwest Fox Conference, presenting the latest in Microsoft Visual FoxPro development techniques, new changes in VFP 9.0 SP2, Sedna Components, and interop with other technologies with sessions from some of t
  • DBF to CSV conversion
    by ram_mv
    13 Replies
    Last post by dni
      • Hi, I am converting a dbf file into csv file using C#. My program is working fine for file having fewer columns in dbf file. If the dbf file has more than 255 columns, I am getting the error "FILENAME" is not a table. I am using Visual foxpro OLEDB friver. I downloaded drivers from http://www.microsoft.com/downloads/detai ls.aspx fa milyid=e1a 87d8f-2d58 -491f-a0fa -95a3289c5 fd4&
  • Too much white space along the bottom of VFP9 report
    by BABSBINI
    5 Replies
    Last post by Naomi Nosonovsky
      • Hi All, We have created a report which works fine in terms of data output. However, sometimes the bands move to the next page even though there is enough space at the bottom of the page. We have tried to control the white space by using the "Start group on next page when less than" setting on the report designer. But this doesnt seem to fix the issue for us. No matter what the setting
  • How to control the scanner with VFP?
    by hoabinh
    5 Replies
    Last post by AndyKr
      • Hi everyone, Could I build a program in VFP to control my scanner as: connect, scan, and save file.... Where could I find out the TWAIN OCX support for it Thanks a lot.
  • Filtering records in grids
    by Derek Dowle
    8 Replies
    Last post by Naomi Nosonovsky
      • I have a grid and a combobox placed on a page of a pageframe. The grid successfully shows the required data from a table. The combobox is used to filter the data on the table. I have placed the following code in the interactive change of the combobox. m.cProjType = THIS.value SELECT tmpProjData SET FILTER TO tmpProjData.ProjType = m.cProjData THISFORM.upgf1.pa
  • cannot quit visual foxpro
    by HowardW
    14 Replies
    Last post by dni
      • Subject message appears altogether too often - during my development, user sessions, etc. Similar messages imply this could be caused by the task pane. I do not knowingly use the task pane and have the auto startup turned off. Sure enough it happened again - tried clear all; release all, clear events, sqldisconnect(0), etc. - all the things I could think of and tried before. No luck. Then I turned
  • Include tables bug?
    by hangover
    7 Replies
    Last post by CetinBasoz
      • Having successfully included a database and its tables into the compiled .exe of my application (see separate thread), I have now encountered a problem which appears to be a bug. When I run an SQL query normally - e.g. SELECT COUNT (*) FROM table INTO ARRAY laTest - it works fine. But when I run the same query using the EXECSCRIPT function - e.g. = EXECSCRIPT ("SELECT COUNT (*)
  • Uploading the Parent table
    by honey1016
    3 Replies
    Last post by honey1016
      • -My append program please help me SET EXCLUSIVE off CLOSE ALL tabname =thisform.combo1.value set safety off sele 4 use &tabname alias &tabname append from getfile() - this is my sample uploading button. I have combobox to select the table for uploading. But how about in parent table I want to upload all data but the id no is the primary key. What if the table have 25 records and the
  • Forum Usage
    by Naomi Nosonovsky
    14 Replies
    Last post by AndyKr
      • Since this thread has gone off-topic, may I please ask few questions about this forum usage. 1) How can I see replies in the chronological order E.g. I only want to see the latest replies but I can not figure out how to do it. 2) Can I turn off Alerts for good I often forget to uncheck them when posting a message. 3) Why most of the messages appear in a very small unreadable f
  • translate from c++ to foxpro
    by StevenAnonymous
    2 Replies
    Last post by RGBean
      • typedef struct { short version; char cardNumber[BEID_MAX_CARD_NUMBER_LEN + 1]; char chipNumber[BEID_MAX_CHIP_NUMBER_LEN + 1]; long documentType; BOOL whiteCane; BOOL yellowCane; BOOL extendedMinority; BYTE hashPhoto[BEID_MAX_HASH_PICTURE_LEN]; BYTE rfu ; } BEID_ID_Data; Thanks in advance,
  • Select Statement INTO table removes table INDEX
    by Kadrin
    4 Replies
    Last post by Kadrin
      • Hello, I am working on a project where I need to put parts of a table into another table using a SELECT statement. Later in my project I use that table and have to use the Index as well but when I insert the selected information into the new table my index is erased from the table. Is there a way to solve this
  • Open Source VFP?
    by Claude Fox
    12 Replies
    Last post by Tamar E. Granor
      • Ok, this article looks fairly balanced and states that MS is seriously considering an Open Source VFP!: http://arstechnica.com/journals/microsoft.ars/2007/04/03/developers-petition-for-the-return-of-visual-foxpro
  • Uploading data with multiple child tables
    by honey1016
    5 Replies
    Last post by Lakshmi N
      • What can i do in my uploading i was created it from forms i have a combobox that have 8 list of values, the one is the parent table and the rest are child tables I select it one by one to upload the data because for consolidation. I want is to transfer in program and I want is one transaction in uploading. I mean if I click the program or (do program) I will upload the 8 tables. But the parent tab
  • CD/DVD Burning
    by BrianSc582555
    4 Replies
    Last post by dni
      • I need to have the ability to burn CD/DVDs from a foxpro application which will be running on Windows XP and eventually Windows Vista. I understand I can do this using IMAPI however I can find no documentation on how to do it. Please help
  • the grid's recordsource is from combobox
    by freadomfee
    3 Replies
    Last post by AngelOfPirate
      • Hello, I have a beginners question. In my form I have a grid, combo box, some edit boxes. When I run the form the grid is already filled with values by default, when I select one of the rows in the grid, particular values are showed in the text boxes also (mainly the values of the selected row in the grid). When I select the value from the combo box which filters some information (I use cursor for
  • Windows Vista and VFP9
    by jdlim
    2 Replies
    Last post by jdlim
      • Howdy, Just asking if you guys have heard of this. My problem is I have 5 field laptop users 3 using Vista and 2 using Windows XP. My 3 Vista users always complain that about 1 out of 10 forms they make wont save. The main command i was using to save was SELECT main_table APPEND FROM my_temptable where the controlsource of the textboxes were the fields on my_temptable. (these t
  • REPORT FORM TO A WORD FILE
    by JLucio
    5 Replies
    Last post by Naomi Nosonovsky
      • Somebody knows how can I send an output of a REPORT FORM to a Word File. I mean a file .DOC. I have to preserve fonts, size, etc. It is to send documents by mail. Dont work only ASCII. Thanks in advance