Visual FoxPro

Page 198




  • Topics
    Replies
    Last post
  • backup and append records
    by honey1016
    3 Replies
    Last post by honey1016
      • please correct my backup program. -backup.prg- SELECT pds_data USE MESSAGEBOX("This will create backup files "; +"Click OK to continue.",65,"Backup Utility") WAIT ("Copying files...Please Wait.") WINDOW AT 10, 30 NOWAIT TIMEOUT 4 backup_cdx = 'Backup\'+"BIRPDS_"+substr(alltrim(dtos(date())),3,6)+".cdx" backup_dbf = 'Backup\'+"B
  • How to fix grid headings?
    by Lightening
    5 Replies
    Last post by AndyKr
      • Can we do that It does not help if I set: AllowHeaderSing=.f.  
  • Prblem in Ejecting in VFP 6.0
    by nrpanda
    1 Replies
    Last post by dni
      • Hi, I am working with Visual Foxpro 6.0, Windows XP Professional. I am using TVSE SP 145 (DOT MATRIX) printer with compatible Epson LX 1000 driver. Actully, I need two tax output form to be printed. For this, I created two tables, say, file1.dbf and file2.dbf, each having 5 - 10 fields(all r of character fields, where their sizes varry from 10 to 50).For this, I developed "taxrep
  • reading a directory for a existing files
    by Novelle
    14 Replies
    Last post by Novelle
      • hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle
  • Problem when updating!!!! Help!!!
    by pamtru
    10 Replies
    Last post by Naomi Nosonovsky
      • Hi i have a problem when running this query in shared mode or set exclu off. update table set field=5 It is very slow in a network or mapped drive. The crazy thing is that if the mapped drive is to a directory in the local computer it is very slow too. Example use c:\table shared update table set field=5 this go allright but now let suppose that i shared the fold
  • Command Window in Vista
    by AlexBB
    14 Replies
    Last post by Tamar E. Granor
      • I hope Tamar Granor will read it. It seems she may be familiar with Vista. I have touched on this problem in my previous post. In VFP 9 Management Studio under Vista, the Command WIndow behaves like the mouse cursor/pointer when you set it up in slow motion and with traces. In addition it frequently bounces back to the place it started. It is unbelievably weird. It is very very, and I mean
  • DCT FILE
    by dni
    14 Replies
    Last post by dni
      • I have a huge dbc data base. It is working perfect in vfp 7 sp1. When I am trying to use it in vfp 9 sp1, I receive a error in DCT file when I try to browse or use some tables (not at all, jus few tables).
  • Visual FoxPro DataBase RI
    by FCoronel
    0 Replies
    Last post by FCoronel
      • How can update a customer VFox database , where its RI has changed is there any way to automatize this task I¡¯ve tried to generate a DBC but the RI always seems to need a "visual" generation trough the RI editor. Thanks, Fernando
  • Page setup settings in VFP9
    by Naomi Nosonovsky
    4 Replies
    Last post by Naomi Nosonovsky
      • Hi everybody, I found that if you open a report, go to File\Page Setup\Printer Setup\Properties and then change Print Quality (say, to economode or 300 dpi instead of default 600 dpi, this setting is preserved while the report is opened in design-mode, but when I save the report and re-check these properties, they are back to default. Note, that the rest of the properties such as tra
  • Fox Pro SynTax Error
    by Brad Corbett
    5 Replies
    Last post by CetinBasoz
      • ok, I not a Foxpro Wizard and Ican't figure this out I get a "Syntax Error" msg when I try and run this from VB.net. Not the most Descriptive Message. I can't see anything wrong with this. Any helpp will be appreciated. Insert Into MWDUS Values (Date(2007,4,3),"685174",560907,.F.,.T.,"AK","","BARROW", "INTREPID","2&qu
  • Errors running FoxPro Stored procedures in .NET windows app
    by TechMate
    10 Replies
    Last post by TechMate
      • Hi I want to run a stored procedure in user selected database which basically creates two new tables to be persisted in the same database. I am able to call this stored procedure but I keep getting the same error "One or more errors occurred during processing of command." There are no details of what the error is specifically about. I am able to run the same stored procedure using Mic
  • SUBSTR() STRTRAN() with Large Text Files
    by Docpro777
    11 Replies
    Last post by Docpro777
      • Greetings Venerable Masters and Dear Friends, With a 'large' text file (HTML) edit requiring about 500 - 600 text-edits (deletions) (below) ... it takes 10 + seconds to execute and longer over LANs. My only question thus: Is there a faster way to make 500 text deletions to a large-text file Or, how might you consider doing multiple edits with large text files Thanks in advance for any co
  • Copy and Past function under VFP9
    by Lightening
    6 Replies
    Last post by Craig Berntson
      • I found the Ctrl+C and Ctrl+V function under VFP9 is not working on the users' end. Sometimes, I found the same problem on my PC. What seems to be the problem
  • Display "Running query..." progress bar
    by hangover
    10 Replies
    Last post by Naomi Nosonovsky
      • How do I make the "Running query..." progress bar display when executing an SQL query within my VFP9 application I have tried both SET TALK ON and SET NOTIFY ON but it is still not displaying. Which other commands can affect whether it is displayed or not Thanks.
  • "Multiple-step operation generated errors. Check each status value."
    by Steve-0
    14 Replies
    Last post by Steve-0
      • I am getting the following error when trying to update an existing Foxpro database using the VFPOLEDB.1 provider and ADO: "Multiple-step operation generated errors. Check each status value." I have tried about every combination of cursor types and locations but cannot get it to work. Here is my code: Dim ADODBConnection As New ADODB.Connection() ADODBConnection.Con
  • Remote View
    by djun_kang
    3 Replies
    Last post by djun_kang
      • Select table1.field1,table1.field2,iif(isnull(table2.field1,spac(10),table2.field1) as Name From table1 left join table2 ................... What i want to ask is how to do IIF part when using remote view Can I use the same Select in Remote View Or may be there is another command to use to substitute the IIF when using Remove View
  • New Word breaks old DDE code
    by rhersom
    3 Replies
    Last post by rhersom
      • A user of our legacy VFP 7 app is finding that the program blows up on the following DDE command being sent to Word 2003 SP2. Older versions of Word 2003 handle the command with no problem. maxed= DDEExecute (ddehandle,"[If AppRestore()=0 Then AppRestore]") Any idea where the last few living DDE experts hang out
  • userprompt
    by Dhabu
    4 Replies
    Last post by Naomi Nosonovsky
      • How to promt user to enter the date in prg file. once it is entered i would like to save it to variable. I am using vfp6.0
  • Server Name?
    by Docpro777
    9 Replies
    Last post by Docpro777
      • Dearest Friends, FoxMasters, Geeks and/or venerable MVPs, Looking at Sys() commands, etc. I can't seem to be able to 'display' a name for the LAN Server(s). Sys(5) works for the "Drive" of course, but Sys(5) fails to be meaningful for a Server Name : ...eg. "DellDimension4300", "Martha", "Ivan", "MyLanServer", etc. I've searched help files
  • Removing Tomb
    by Bit
    7 Replies
    Last post by Alex Feldstein
      • Hi, An VFP application form is closed with the right upper corner x sign. User does not aware the application has not been terminate completely. A tomb xyz.exe remain unclosed. Since "close all" can not be used, what else can avoid the tomb formation (Thisform.release or else ) Regards, Bit
  • how could i close a program with-in VFP?
    by Madix_t
    10 Replies
    Last post by Madix_t
      • Good day to all How could i close an open program (ex. word, excel or any open program) from VFP thank you very much for any help
  • Updating DBF from SQL server
    by tazvier
    6 Replies
    Last post by tazvier
      • Hi to everyone. I have the following issue; I need to update some information in DBF files but with a SP from SQL server. I have a linked server in my SQL server pointing to DBF directory. When I execute the following commands, I get everything ok: Select * from LinkedServer...mytable Insert into LinkedServer...mytable values('fiel1',¡¯field2','') But when I execute Update and
  • keyboard {leftarrow}
    by miltoncwb
    5 Replies
    Last post by Naomi Nosonovsky
      • Dear Experts, The previous post was incompleted, sorry. I am working on a data entry grid with 20 columns, when the user reach the last record and press down arrow, then append blank and move the cursor to column1 of the new record, I put the following code in keypress event : If nKeycode = 24 select cr_1 appe blank thisform.grid1.SetFocus _col = thisform.grid1
  • form in add mode
    by NILKAMAL
    3 Replies
    Last post by CetinBasoz
      • hi! i am new in foxpro some one help me out for this problem from my main menu to add new record (one to many) in form , form open good but it show me a first record i need append should blank and cursor need in first field
  • 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