Visual FoxPro

Page 48




  • Topics
    Replies
    Last post
  • How to import data from csv file
    by surinder singh
    7 Replies
    Last post by CetinBasoz
      • Hi all How to import data from csv file. Csv file : name,add,description ( delimited with ,) Table fields: name c(20), add c(20), description M I am using append from command but "description" field getting nothing. Thanks
  • How to create a calendar in report?
    by Lightening
    9 Replies
    Last post by Naomi Nosonovsky
      • Trying to create an event calendar in VFP6 report Have a table with 2 columns, cText, dDate Created a group based on Week(dDate) -- group by every week. Add 7 fields for dDate value across a row, with each like iif( dow(dDate)=1, " "+SUBS(DTOC(DDATE),4,2) +" Sunday","") iif( dow(dDate)=2, " "+SUBS(DTOC(DDATE),4,2) +" Mon
  • Combining Word Docs with FoxCode
    by JedP
    3 Replies
    Last post by Tamar E. Granor
      • I would like to be able to combine several word docs that I store in a foxpro table into a single word doc. The files are created using the FileToStr() function and stored in a blob field type. Field text1 and field text2 each contain a seperate word docs. Code is like this: liblob1 = text1 liblob2 = text2 liblob3 = text1 + text2 StrToFile (liBlob3, "c:\dev\test1.doc&
  • file access is denied (tools needed)
    by jan_sc
    4 Replies
    Last post by CetinBasoz
      • hi all, is there a tool that allows me to find who does actually locking a particular dbf file thanks. regards.
  • How to get the dbf table's Field Name and Field Type and Field Size
    by polachan
    10 Replies
    Last post by polachan
      • Sir How to get the dbf table's Field Name and Field Type and Field Size . Please help me by providing a program tips in foxpro to find out name , type,size of each field in a table For example I have a table employee having the following field code c(5) Name c(10) dept c(30) Salary n(10,2) remark memo(50) I
  • Dbf Autoincrement with ADO
    by Walker Boh
    14 Replies
    Last post by dni
      • Hello everybody, I created a table with an autoincrement field( CREATE TABLE `Synch_LogFile` ( `ID` I Autoinc NOT NULL, `TableName` C (100) NOT NULL, ...) ) when I try To open it by ADO with VB (Select * From Synch_LogFile) I get this error message: [Microsoft][ODBC Visual FoxPro Driver]Not a table. What's I'm doing wrong Thanks,
  • I can't see the content of the last field of the record
    by Markspiz
    14 Replies
    Last post by CetinBasoz
      • I tryed to open a "dbf" table with VFP to read some data with mi preferred platform (VFP). But in the last field of the record I can't read the right data (VFP return all blanks fileds). If I try to MODIFY STRUCTURE of the table in VFP the lenght of the record is 1614 bytes, an other utility for managing dbf table give me a record size of 1870 bytes. Is there a way to read this table cor
  • Pls...give me a command To Blink A Particular record in Listbox [VIsual Foxpro 9.0]
    by Paramu
    9 Replies
    Last post by Tamar E. Granor
      • Pls...give me a command To Blink A Particular record in Listbox [VIsual Foxpro 9.0] Actually I added few records in listbox...But I want to blink a particular record in listbox....pls...give me command... list box coding is thisform.list1.clear use abcd go top do while .not. eof() thisform.list1.additem("example") skip endd
  • CONFIG in top-level application
    by Donquick
    8 Replies
    Last post by Naomi Nosonovsky
      • Hi, I am using VFP6.0. Acouple of questions about application creation. 1) I notice a config.fpw is created in the progs area by the application builder, which is presumable just for setting up config for this application. If i modify the fpw by putting a 'Command = XXX' line in it and generating the application then it doesn't seem to run the command when the app starts. Similarly u
  • 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
  • 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
  • Why is qeury so slow?
    by Lightening
    10 Replies
    Last post by Lightening
      • I used this query statement. Code Snippet Sele a.*,b.address ; From NewCal a; Left Outer Join customer b On all( a.work_no)=b.wo_type+allt(str(b.wo_no)) Table A contains less than 1,000 records and table B contains about 30,000 records. In VFP6, it takes me a few seconds to get the results. In VFP9 + SP1, it takes me 4 min
  • About using imestatus()
    by xuyca
    4 Replies
    Last post by xuyca
      • Hi, I am using imestatus() to change input method between English and Chinese. It worked good in windows 2000. But it doesn't work in window xp. imestatus(0) always change to Chinese input and imestatuss(1) doesn't work. code is as follow: =imestatus(1) && using Chinese input =imestatus(0) && using English input Anybuddy know why
  • How to avoid "Saveas" dialog box while using IE ExecWb(4,2)
    by Tang Jian
    8 Replies
    Last post by Claude Fox
      • Dear all, I want to save all contents of a web page to local harddisk automatically, pictures included if any. But while I use the following code, the dialog box shows. Any one have good ideas *****mycode in vfp9, Windows XP, ie6******** ee=CREATEOBJECT("internetexplorer.application") ee.Visible =.t. ee.Navigate(" http://www.baidu.com/ ") wait window "wait for a
  • compiler
    by Old Foxpro Dood
    14 Replies
    Last post by AndyKr
      • I work for government and unfortunately we are a little behind on versions, but I do have a problem which my dbase,sco foxbase, microsoftfox brain can't handle. A project was created in Ver 7 with no compilation or execution errors prevelant. When proj is opened in Ver 8 and a particular form is opened the error displayed says "SYNTAX ERROR 10" .... my old feeble brain has tried debugger
  • Foxpro version compatibility
    by Econdoc
    2 Replies
    Last post by Alex Feldstein
      • I have many applications written in Visual Foxpro 6.0. I probably should upgrade to Version 9.0. My major concern is whether my old applications will run in Version 9. Can someone advise me Will I have problems How major Thanks.
  • Access copy/paste buffer from program
    by Gary Demi
    2 Replies
    Last post by Naomi Nosonovsky
      • How do I store to (or read from ) the copy/paste buffer from a VFP 9 program.
  • 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
  • Why my VFP exe file cannot be launched?
    by Lightening
    9 Replies
    Last post by Lightening
      • I complied my program under VFP6 into an exe file in the program folder. But it cannot be launched. I believe there is nothing wrong with the code, because I just made a minor change. The funny thing is that if I copied the file to other folders on the same drive, it works! And even more wear is that some old version VFP exe files could not be launched from within that program folder, either. I
  • delete record
    by honey1016
    3 Replies
    Last post by Docpro777
      • when you are in data entry screen and i want to delete the record. In parent table i already delete the record but in child table i was'nt able to delete. help me. thanks
  • A couple questions about the OLE DB data provider
    by mbarry
    12 Replies
    Last post by mbarry
      • Hello! I'm looking to access a VFP database from an ASP.NET web application and I have a couple questions about the OLE DB data provider. 1) Can I use the latest VFP 9.0 OLE provider with a VFP 6.0 free table directory Should I expect any problems 2) Does the OLE DB provider have any dependencies on VFP E.g. could I install it on a machine without VFP and still be able to manipulate my d
  • VFP - Word Integration - Updating Existing Word Macros
    by Stuman99
    4 Replies
    Last post by Stuman99
      • I have been updating our word integration as we port our application from fp2.6 to visual foxpro. This means that I need to develop a conversion program that will update all the old template documents that users have. The approach I am researching is that I will create new template documents and then copy the contents of the old template into the new template. Has anyone programmically copie
  • Why _pageTotal always shows 1 ???
    by Lightening
    9 Replies
    Last post by Tamar E. Granor
      • in VFP9, I tried to use use my table report form test noconsole preview "Page " + TRANS(_PAGENO) + " of " + TRANS( _PAGETOTAL) But the _pagetotal value is always 1 although the report contains 4 pages. What is that
  • drop-down combobox problem
    by MillBear
    11 Replies
    Last post by MillBear
      • Hi I'm still struck with the combo drop-down part problem for nearly 2 weeks and need help from you. When the values of these 2 textboxes match with each other, the list of employee is able to display on the combo drop-down. But I have one problem :- The list of employee on the combo drop-down repeat unnecessary (even a few blanks) when i changes the values of textboxes. How to refres
  • Reporting failures from COM server
    by Darren Woodford
    5 Replies
    Last post by Darren Woodford
      • I am writing a COM Server in VFP9 and have a question as to how to report failures back to the calling client application. For example I have a method that creates a customer object and returns it back to the calling client. However if the customer record can't be found then my COM server is unable to create the customer object. In this situation I was returning NULL. However I have found t