-
- 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