Visual FoxPro

Page 250




  • 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
  • Importing a Query to Visual Foxpro into an excel sheet
    by 970935726
    5 Replies
    Last post by Cindy Winegarden
      • Ok people. This is probably is very simple or maybe very complex. I need help and I am far from an expert. I have a Visual FoxPro database (9.0) in my C: drive. I want, from Excel, to query this database and throw the results into the current workwheet (or any worksheet for that matter). Eventually I would like to throw the results into the worksheet starting at a specific row. Is th
  • Bug of the function Isupper() just FYI
    by Igor Nikiforov
    2 Replies
    Last post by Igor Nikiforov
      • Code Snippet Local i For i = 0 To 255 If Isalpha(Chr(i)) And Upper(Chr(i)) == Chr(i) And .Not.Isupper(Chr(i)) i, Chr(i) Endif Endfor * displays 131, " " and 223, "s" * Version(1) returns Visual FoxPro 09.00.0000.3504 for Windows [Nov 4 2005 17:39:44] * * Version(3) returns 00 && English ** but this bug exists for all version of VFP * This bug has an impact on
  • Locate Command
    by Ahsan Amin
    5 Replies
    Last post by Fox Me Up
      • I am trying to compate a textbox value with field value and using found() function to check if found or not. I am entering the same value as it is in a table field but found() function returns false. I am using the following code: LOCATE FOR ALLTRIM(SubName) == 'thisform.txtSubName.Value' IF FOUND() MESSAGEBOX("This subject already exists") RETURN ENDIF
  • VFP MVPs - Please Contact Me
    by Joe Morel - MSFT
    4 Replies
    Last post by CChalom
      • To all VFP MVPs: If you do not currently have moderator permissions in this forum and would like them, please send me some email at joemorel AT microsoft DOT com. I've noticed situations in which you might like to create some sticky announcements or FAQ posts, and I'd like to help you get the tools you need to make these forums work for your community. Thanks all!
  • Visual foxpro 9 watch hang
    by cristi_bd
    11 Replies
    Last post by cristi_bd
      • I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and&n
  • config.sys
    by Lakshmi N
    1 Replies
    Last post by dni
      • If it is win 98 or below (operating system), then open config.sys and FILES = 100 BUFFERS = 33 then save reboot and it should work. if config.sys is not there, then create one using notepad or copy con config.sys (in the root directory) if it is win xp or win 2000 but not vista then locate config.nt and then give FILES = 1
  • finding duplicates with a query with fox 6 or 9...
    by ibbm
    12 Replies
    Last post by ibbm
      • Is there anyway to do a query that displays only duplicate records Preferrably in 6 as I'm not ready for v9. Thanks as always!
  • Grid and checkbox
    by kippm99
    1 Replies
    Last post by Don Higgins
      • I have a grid with 7 cols of data, the last being a checkbox. My goal is when the checkbox is checked the value in col 5 is put into col 6. I have the necessary code in "After row change" and it works but is there a way for it to show immediately and not when I go to a different cell with the mouse
  • Trouble getting dates in Report
    by Anomaly
    7 Replies
    Last post by Naomi Nosonovsky
      • Hi, Im creating a report and I need it to print out the from and to dates that the user has selected to search by. Do I simply put it in as the report variables Or is it more complicated then that
  • File In Use
    by AlexBB
    14 Replies
    Last post by AlexBB
      • Trying to execute a delete command from .NET with OleDb driver I get an error: File in Use. It seems strange that a similar command appeared to have executed once before. That command is downstream of this one and that worked while the code around this one was not yet debugged and this ExecuteNonQuery was simply bypassed cmdm . CommandText = "execscript('USE crossRefTable in 0 EXCLUSI
  • NOT A TABLE
    by NGUYEN XUAN KHANH
    4 Replies
    Last post by Vladimir Zografski
      • RECENTLY I HAVE A TERRIBLE PROBLEM ABOUT DATABASE IN VISUAL FOXPRO 8. THERE ARE 400 DBF FILE IN MY DBC. 2 DAYS AGO, AFTER INPUTED DATA, I EXITED THE APPLICATION. THE NEXT MORNING I RAN THE APPLICATION, IT MESSAGE TO ME THAT "NOT A TABLE". I CHECKED AND FOUND THAT 300 DBF FILES GOT ERROR "NOT A TABLE". ALTHOUGHT MOST OF THEM WEREN'T INPUTED DATA AND POWER AND HARDWARE WERE IN GO
  • Unexpected parsing behavior in VFP 9
    by Jim Vahl
    3 Replies
    Last post by CetinBasoz
      • Encouraged by Naomi's lighning response to our browser question, I thought that I'd report another unexpected behavior. When testing the browse error, I disabled our toolbar, with the result that there were no forms in the _screen.forms collection. The following code failed with a "forms is not an object" error, even though the expression to the left of the AND evaluated to FALSE
  • File In Use
    by AlexBB
    14 Replies
    Last post by AlexBB
      • Trying to execute a delete command from .NET with OleDb driver I get an error: File in Use. It seems strange that a similar command appeared to have executed once before. That command is downstream of this one and that worked while the code around this one was not yet debugged and this ExecuteNonQuery was simply bypassed cmdm . CommandText = "execscript('USE crossRefTable in 0 EXCLUSI
  • Problem indexing views
    by Hans L
    14 Replies
    Last post by Hans L
      • I am trying to index a view. After having created the view in a prg file, created with Gendbc, I add (in the prg file): USE vwMysoft INDEX ON cname TAG Namn OF vwMysoft USE In other words, I use the same commands I would use for a table. Okay Then, when I open a form where I need the indexed view open, I do: USE vwMysoft SET ORDER TO Namn Error message: Variable Namn is not found. Either I am m
  • Best way to assign default value to combo
    by Aleniko29139
    5 Replies
    Last post by CetinBasoz
      • Hi all; Back to the stupid simple questions: What's the best way to make one of the items in a combo show as default, and make the coltrol source affected accordingly Currently I assign this.value in the init and also assign a value to what the control source is. I have a hunch there's a better way. Thanks.
  • ON ERROR causes controls on forms to disappear
    by Derek Dowle
    14 Replies
    Last post by Naomi Nosonovsky
      • I have a routine that exports selected data to an excel spreadsheet that works perfectly. If an excel file with the name chosen already exists then the user is warned. If the data is being exported to a file that is open then a program error message appears and when help is pressed 'File access is denied (Error 1705)', which is to be expected. To overcome this I have used the follow
  • Still "File is in use"
    by Victor BA
    4 Replies
    Last post by Victor BA
      • I started programming in VFP, and i'm having a bad time running forms, each time i run it can work or not, but after i stop running it and try to open the form for designing purposes or modifications, sends the message "File is in use"...everytime.. I have to close VFP an reopen it so i can use it again I tried the CLOSE ALL command, but still when i open the project again and choo
  • About creating PDF Report using VFP 9.0
    by ashishvjoshi@hotma
    8 Replies
    Last post by ashishvjoshi@hotmail.com
      • How to create PDF report using vfp 9.0
  • VFP online with DNN
    by Fox Me Up
    4 Replies
    Last post by Claude Fox
      • ok i love vfp... but i just started a new job doing web programing.... I use something called DotNetNuke... now its kind of simple all i do is make individual modules in C# ( i take the dll file and the web-user-control) My question is, is there any way i can build individual modules in foxpro and make it work with DotNetNuke ive been searching around the internet but cant find any examples of co
  • FoxPro Ver 8 problem with Ver 7 form doc
    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
  • form help
    by NILKAMAL
    5 Replies
    Last post by MarciaAkins
      • hi! i create a simple table as below field name datatype name c address c state c photo memo(binaray) now i create a form with all field but i want photo from my file how do i get from file ( with button ) and save for record thanks
  • msxml3.dll error when using XMLTOCUROSR()
    by TonyVFP
    5 Replies
    Last post by AndyKr
      • When using the XMLTOCURSOR() function in version 9, I receive the follow message [msxml3.dll : The system cannot locate the specified object ]. Steps taken include uninstalling VFP9 and reinstalling both 7 and 9 and installing the service pack and registering the dll separately. The code works fine in version 7 but not in 9; Test Code lcxmlalias = 'xmlalias' lcfilename = 'c:\indir\pfpcxm
  • Export DBF into Text file
    by polachan
    14 Replies
    Last post by hangover
      • Dear All I am new in FoxPro and dBase Please help me for writing a routine in dbase/foxpro that will export any dbf file to a text file that we can read in. Regards POL
  • Domain user as the anonymous account, problems...
    by Mantorok
    3 Replies
    Last post by Clemens Vasters - MSFT
      • Hi all I have a domain account called sa-inetcms, I run my ASP.Net 2.0 web service under this account (configured in IIS 6.0). However, when it tries to perform an INSERT into a local table on the service, it says that the table (a foxpro dbf) is read-only, I've checked all permissions on the server, the sa-inetcms account has full permissions to everything it needs, yet it still fails. Any ideas