Historical FoxPro

Visual FoxPro General

Index ‹ Visual FoxPro

- Previous
  - 1
    - How to send email by using default email client installed on user's machine Hi All, I want to know if there is any way to send email in foxpro through default email client installed on user's machine. I am using MAPI currently to send emails. Thanks Tag: Historical FoxPro
  - 2
    - adding carriage return and line feed through foxpro oledb provider Using ado.net with the foxpro ole db provider I am trying to insert a record in the database that has a memo field. In the memo field I am trying to add some data seperated by a carriage return and line feed. Unfortunately, when I run it I keep getting a "Command contains unrecognized phrase/keyword" oledb exception. I have tried using string concatenation to add my parameter values to my query string and added in parameters using the " " but I keep getting the error. Any ideas on how to get this to work This is really frustrating. Tag: Historical FoxPro
  - 3
    - MS Access importing visual foxpro tables Win XP Pro - Access 2003 - current ODBC driver for VFP Set up an ODBC connection via control panel/admin services using a free table directory - the target directory has many dbf files that are visible in the "browse" window - - I then try to use the Access link table "wizard" - choose ODBC connection - - select the ODBC link I created - - the "wizard" presents a list of dbf files to which I can create a link (or alternatively import) - Here is the problem - only some of the dbf files in the directory are visible in the "wizard"s list - - why is this and what can I do about it Thanks in advance for your help. Dave Mosby Tag: Historical FoxPro
  - 4
    - How to create a VFP program whose name should not be shown during runtime in task bar, task list, systray ? Hi, I need a VFP program whose name should not be shown in Windows Task Manager list, neither in Task Bar nor in System Tray during run-time. How can i achieve that Can it be done through VFP 6.0 Any example or idea plz With regds. nrpanda ----------------------------------------------------------- A VFP 6.0 Programmer Tag: Historical FoxPro
  - 5
    - Need help with report expression I want to evaluate two fields before I include it in my report. I'm not sure if what I have is correct, can someone help me with the syntax: IIF(EMPTY(grntradd) OR ISNULL(grntradd) OR PROPER(grntradd)=PROPER(mailaddr),"Not Available",PROPER(grntradd))) Thanks, Jennifer Tag: Historical FoxPro
  - 6
    - Command Window in Vista 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 it, very slow! Anybody knows how to handle it Thanks. Tag: Historical FoxPro
  - 7
    - Assigning an array to an Activex property I am using VFP9, Sp1, and am trying to assign an array to an Activex property but I keep getting a "type mismatch" error. Using the same control and similar code works using VB6. Using the object browser shows the property to be of type variant and at runtime, using the debugger, shows it to be an array of type "Z", and the array I'm passing to be an array of type "A". Here are code snippets from both applications (in both cases assigning values (numbers, strings, etc.) to other properties of the control work okay): ========================================== VB code - works fine Private Sub Command3_Click() Dim arrRx(8) As Variant arrRx(0) = "string 0" arrRx(1) = "string 1" arrRx(2) = "string 2" arrRx(3) = "string 3" arrRx(4) = "string 4" arrRx(5) = "string 5" arrRx(6) = "string 6" arrRx(7) = "string 7" o.RxNumbers = arrRx ========================================== VFP9 code (for Click event) - get "type mismatch" DIMENSION arrRx[10] arrRx[1] = "string 0" arrRx[2] = "string 1" arrRx[3] = "string 2" arrRx[4] = "string 3" arrRx[5] = "string 4" arrRx = "string 5" arrRx[7] = "string 6" arrRx = "string 7" o.RxNumbers = arrRx ========================================== Thanks for your help, Mike Tag: Historical FoxPro
  - 8
    - importing from excel Hi, I'm struggling to import from an excel spreadsheet into foxpro. The problem is there's a "remarks" column in the xls which may contain more than 255 characters, so I want to import that column as a memo field. I've tried using APPEND FROM, but that's just putting nulls in the field. I've also tried IMPORT, but that just gives me a character field. I've tried setting up an ODBC connection - that gives me the memo field, but never with more than 255 charcters in it. And I've tried going through access, all to no avail. Any advice gratefully received! Tag: Historical FoxPro
  - 9
    - webbrowser newwindow event Dear All, in our application (VFP7) we are using MS WebBrowser control. it is working well, except in one case. we don't allow the new window action. according to the documentation the NewWindow2 event is fired when the user tries to open an url in a new window (right click - selecting Open Link in New Window menu, shift+click, etc). i can catch this event, and returns as cancel=.T. everything is nice. but when i press the CTRL+N in the browser control the system opens a new IE window in the same session (doesn't require any login). please give me some help, advise, how could i catch CTRL+N keypress (i don't see Keypress event in webbrowser activex) Ivan Tag: Historical FoxPro
  - 10
    - Importing data from Excel into a FoxPro Memo field Hi I'm trying to import data from an Excel spreadsheet into a Foxpro v8 memo field using the APPEND FROM command something like this, but the field is blank after I run the append. CREATE TABLE "C:\Blah\TESTMEMO.DBF" NAME "TESTMEMO" (TESTMEMO M NOT NULL) APPEND FROM "C:\Blah\TESTMEMO.xls" TYPE XL8 SHEET "SHEET1" Any ideas how I can do this Thanks Tag: Historical FoxPro
  - 11
    - Outlook 2003 won't open My outlook 2003 seems to have froze. When I click to open outlook it won't open it seems like it's trying but then times out. I have recieved no error messages it just seems like theres an icon to open it but no program. This is a new occurance, I have never had any problems before. Please advise. Thanks Dan Tag: Historical FoxPro
  - 12
    - How to fix grid headings? Can we do that It does not help if I set: AllowHeaderSing=.f. Tag: Historical FoxPro
  - 13
    - How to Copy 2 worksheet from one excel sheet to to 2 Worksheet of another Excel Sheet var xlApp, xlWB, xlSheet,f2,fso,oBook,oSheet,oBook1,oSheet1,idTmr; xlApp = new ActiveXObject("Excel.Application"); fso = new ActiveXObject("Scripting.FileSystemObject"); if(fso.FileExists("c:\\Example.XLS")) { f2=fso.GetFile("c:\\Example.XLS"); f2.Delete(); } xlApp.Visible = true; xlApp.DisplayAlerts=false xlWB = xlApp.Workbooks.Add(); xlWB.Sheets.Add(null,xlWB.Sheets(xlWB.Sheets.Count)); xlWB.WorkSheets(1).Name="Redmond_Enabled"; xlWB.WorkSheets(2).Name="Redmond_Disabled"; xlWB.WorkSheets(3).Name="PHX_Enabled"; xlWB.WorkSheets(4).Name="PHX_Disabled"; xlSheet = xlWB.WorkSheets(1); xlSheet.Activate(); xlSheet.Cells(1,1).Value = "job name"; xlSheet.Cells(1,2).Value = "job ID"; xlSheet.Cells(2,1).Value = "a"; xlSheet.Cells(2,2).Value = "a1"; xlSheet.Cells(3,1).Value = "b"; xlSheet.Cells(3,2).Value = "b1"; xlSheet.Cells(4,1).Value = "c"; xlSheet.Cells(4,2).Value = "c1"; xlSheet = xlWB.WorkSheets(2); xlSheet.Activate(); xlSheet.Cells(1,1).Value = "job name"; xlSheet.Cells(1,2).Value = "job ID"; xlSheet.Cells(2,1).Value = "a"; xlSheet.Cells(2,2).Value = "a1"; xlSheet.Cells(3,1).Value = "b"; xlSheet.Cells(3,2).Value = "b1"; xlSheet.Cells(4,1).Value = "c"; xlSheet.Cells(4,2).Value = "c1"; var oExcelApp = new ActiveXObject("Excel.Application"); var oWkBks = oExcelApp.Workbooks; oWkBks.open("c:\\Example_PHX.xlsx"); oBook = oWkBks.Item(1); oSheet = oBook.Worksheets.Item(1); oSheet.Activate(); oSheet.Cells.Select(); oExcelApp.Selection.Copy(); xlSheet = xlWB.WorkSheets(3); xlSheet.Activate(); xlSheet.Paste(); oBook = oWkBks.Item(2); oSheet = oBook.Worksheets.Item(2); oSheet.Activate(); oSheet.Cells.Select(); oExcelApp.Selection.Copy(); xlSheet = xlWB.WorkSheets(4); xlSheet.Activate(); xlSheet.Paste(); xlSheet.SaveAS("C:\\Example.XLSx"); xlApp.Quit(); xlApp = null; CollectGarbage(1500); After copying 1st worksheet to the 3rd worksheet,it throws Exception..Please suggest where I am doing wrong...Is there any problmem of garbage collector Please reply me to adityamandlekar@yahoo.com or v-admand@microsoft.com if possible..its urgent!!! Tag: Historical FoxPro
  - 14
    - userprompt 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 Tag: Historical FoxPro
  - 15
    - Some more Excel automation questions Hi all; - Is there a way to lock cells so the excel user can't modify them - I am trying to setup an excel sheet where each line in the sheet may neet to have multpiple 'child items' which the user needs to create. For example an order line item which the user may need to break into different production status lines. Is this something that can be done in excel Thank you all, AK. Tag: Historical FoxPro
  - 16
    - Why won't this commit to the local FoxPro Table? Each time I run this statement on the form I receive the following error: Alias "txtdescription" is not found. UPDATE adtype ; SET adtype.description = ALLTRIM(Thisform.txtDescription.Value), ; adtype.rate = ALLTRIM(Thisform.txtrate.Value), ; adtype.priority = ALLTRIM(Thisform.txtpriority.Value), ; adtype.headingnum = ALLTRIM(thisform.cbopageType.Value) ; WHERE adtype.booktype = cAddEditAdtype.booktype AND ; adtype.bookcode = cAddEditAdtype.bookcode AND ; adtype.adtype = cAddEditAdtype.adtype Thanks in advance, I think it is something very simple, but not obvious to me. RPP Tag: Historical FoxPro
- Next
  - 1
    - Validations on Textbox I am trying to implement validation on textboxes placed on a form using ISNull function. I placed the code in a procedure and calling it on the click event of a button but does not work. I want also want to check for numeric and character data. here is my code IF ISNULL(thisform.text2.Value) then MESSAGEBOX("Please enter customer name") ENDIF Tag: Historical FoxPro
  - 2
    - File is in use by another Hi all, One of my client is using my inventory program (developed in FoxPro 2.6 for windows) for last 4 years without any problem. Two days before client's computer operator reported to me the following situation; "I just turned on pc. First thing I did after that is I started your program and suddenly got an error message 'FILE IS IN USE BY ANOTHER' and stopped on the line 'INDEX ON CO_NO TO COMPANY' from the .prg file." I approached the client's office and had a look on the code and made sure that the dbf is opened exclusively in that workarea. I tried to run the program and got th same error message as reported above. When I came out of foxpro by cancelling the program, System Tray ballooned up the message 'FILE COMPANY.IDX FILE IS CORRUPTED. RUN CHKDSK/F'. When I tried to run the CHSDSK /F from the DOS Prompt, It gave an error mssage; 'CANNOT LOCK CURRENT DRIVE. CHKDSK CANNOT RUN BECAUSE THE VOLUME IS IN USE BY ANOTHER PROCESS.' What should be wrong with it Please help me. Tag: Historical FoxPro
  - 3
    - Drag and Drop with Listbox I have a control consisting of two listboxes which allow the user to drag and drop items from the left listbox to the right listbox to copy them across, or drag and drop items within the right listbox to change their order. I have got the mechanics of it working reasonably well using the OLEDragDrop methods of the listboxes, however it is not as slick as I would like. There are three improvements I would like to make and would gratefully appreciate any help or advice: 1) My algorithm for identifying which item in the listbox the cursor is over has been formulated through trial and error (using the FONTMETRIC function) and is not wholly reliable. Is there a 100% accurate means to determine this 2) Better yet, is there a way of highlighting the listbox item that the cursor is dragging over so that the user can see exactly where the dragged item will be dropped 3) Also, is there a standard DragIcon to use for listbox items and, if so, where can I obtain it Many thanks. Tag: Historical FoxPro
  - 4
    - Memo file is missing or invalid Hello, I have a DBF file an I need to open it. I have VFP9.0 and when I try to open it I get a message suc as: "Memo file C:\....\myfile.fpt is missing or is invalid." Is there a way to open this file I will deeply appreciate advices or ideas.. Thanks. Tag: Historical FoxPro
  - 5
    - image from file hi! how do i replace image from file here is my code DO [C:\Program Files\EZTwain\VFP\EZTwain.prg] TWAIN_SelectImageSource(0) * Get list of devices into memory TWAIN_GetSourceList() LOCAL lcFile, lnImageHandle, lnReply lcFile = "C:\Documents and Settings\sony\My Documents\New Folder (2)\IMAGES\IMAGE.jpg" * Get the image lnImageHandle = TWAIN_AcquireNative(0,0) replace image with lcFile * Write the image to a disk file lnReply = ; TWAIN_WriteNativeToFilename(lnImageHandle,lcFile) * Release the image handle TWAIN_FreeNative(lnImageHandle) * Check for errors IF lnReply = 0 * image successfully written to file ELSE * something went wrong ENDIF now problem is my image field show me a path (e.g C:\Documents and Settings\sony\My Documents\New Folder (2)\IMAGES\IMAGE.jpg ) but not actual image (when i click on image field) is it possible to get image insted of path before i click Tag: Historical FoxPro
  - 6
    - Need better performance with FP Tables I am working with FP tables from an old warehouse managment system and the SLOOOW performance is killing me. Not being a FP person, I have some general questions. I have several access databases that have linked tables to FP. These are particularly slow. The server that contains the FP tables has a 100MB Nic on a 10/100 switch. If I changed that out, would my calls be faster When running updates on large recordsets (1000+ records), are the updates happening client side and being feed back to the table I have IIS on the FP server, could I set the table directory as virtual root and let the server do the work. This seems like it would speed things up. Any other tips Regards, Dave Tulk Tag: Historical FoxPro
  - 7
    - Problem with Vista Windows mail Hi everyone, We have this foxpro 8 program that getting email from Outlook 2000, 2003, 2007 with MAPI32. It works fine until we try it on Vista's Windows mail. Everytime it runs "fetch" and get the meesage, the program will just break and pop up an error message saying "An error occurred communicating with your MAPI message system. If you are using Microsoft Outlook try checking the 'Verify email address when sending messages' checkbox in the System Screen on the Other tab" It could be that the MAPI32 doesn't support Windows Mail but I can't find any reference on Microsoft website. Has anyone ran into this problem before Thanks Jack Tag: Historical FoxPro
  - 8
    - DCT FILE 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). Tag: Historical FoxPro
  - 9
    - Visual FoxPro9 Report Designer BUG This issue is somehow related to CTRL+V (Paste) action of an object in report designer and TAG Memo field in .frx file. This is actually terrible thing because you can loose all your code in INIT procedure in Report. Steps to Reproduce: Just try to do the following actions: 1. CREATE REPORT 2. Add a Field box with some text 3. Open INIT procedure in data environment 4. Add some text 5. Close INIT procedure (but don't exit report) 6. Select a field just created and copy paste it 7. Open INIT procedure in data environment again HERE you have an error... Visual Explanation can be found: http://www.geocities.com/taimanas/index.html Can anyone reproduce this issue too Tag: Historical FoxPro
  - 10
    - Sqlexec() command line maybe too long. I am trying to post data from a Foxpro file to a sql sever. This has been successful, however when i try adding some more data, it fails (most of the time crashes). So i have shortened the command line by storing the variable i want to call in "m.Sg_Subject" I then call this in my sql exec() as shown below: SQLEXEC(m.temp1, "INSERT INTO MsgInfo (ID, creator, created, sequenceNo, EnvCount, Status, StatusTime, Body, BodyType, Subject); VALUES ( MsgInfo_ID, Strategic.sg_creator, &temp_time, MsgInfo_ID, '0', '3', &temp_time, Body_ID, 'ASCII', m.Sg_subject )") As you can see i have included m.sg_subject into the values and this works fine unders the column subject, however, if i add an additional column after Subject and inserts its value, foxpro crashes, I have been told this is because the command line maybe to long for FoxPro to execute, any ideas how i can over come this ...as in add more to my command line, so as to include more fields after subject Tag: Historical FoxPro
  - 11
    - OLEDragDrop errors I have written a database application for logging requests, and I am trying to create additional functionality such that the user can drag and drop an Outlook email onto the application and it will automatically create a new record populated with the relevant details (e.g. request date, requestee, etc). I have got the 'difficult' stuff working fine - i.e. when an Outlook email is dragged and dropped the OLEDragDrop method correctly identifies it as an Outlook email and extracts all of the relevant details. However, when it tries to run my 'AddRecord' method to create a new record the application hangs. (When I step through it it hangs on the line which calls the method. Anything I do from that point on causes VFP to crash with either a 'mismatched pushjmp/popjmp' error or a 'Fatal error: Exception code=C0000005'). The application consists of a Top-Level form with a toolbar. The 'AddRecord' method is within the toolbar object and works fine when called from the Click method of the toolbar's 'New' command button. Is there a limitation on calling methods contained within another form or toolbar from a form's OLEDragDrop method Tag: Historical FoxPro
  - 12
    - Display "Running query..." progress bar 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. Tag: Historical FoxPro
  - 13
    - Recursive function call stack cleanup Below is a program that calls two recursive functions. With the first one, I am able to watch as the call stack is built with each instance of the function one by one, and then am able to watch as each instance of the function is removed from the call stack, one by one. With the second function, I can watch the call stack grow as each instance of the function is added, but after the last instance of the function is added, and the call stack pointer is at the top of the stack, that function then returns, and it seems as if that instance of the call stack immediately returns to the next line in the program, after the line that initially called the function. It seems as if all of the parent instances of the function on the call stack are skipped. I know this is not what really happens, because the final value after the functions return to the main part of the program is correct. However, I would like to be able to use a breakpoint or a suspend, so that after the second function is called, as each instance of the call stack have all been added, and then start returning to the parent instances, I can stop the program each time and know that those instances are actually being removed one at a time, and not being cast off into memory as a leak. Any ideas All of my efforts with the second function have not been successful. Struggling with this led me to creating the first function, in which I was able to successfully watch the recursion step by step. However, I really would like to verify the same thing on the second function. Thanks. *------------------------------------------------------------------------------ *- Program Name..: recursiveFun.prg *------------------------------------------------------------------------------ *- Description: Visual Foxpro Recursive Factorial functions *------------------------------------------------------------------------------ *- Synopsis...: This program demonstrate two different versions *- of recursive functions that both determine the factorial *- value for a number. In this case, I've used 10 *- for simplicity. *- *- Source: http://fox.wikis.com/wc.dll Wiki~RecursionInVFP~VFP *- *------------------------------------------------------------------------------ Private ll_Cntr PRIVATE ll_funcCntr PRIVATE ll_stuff CLEAR ll_Cntr = 10 ll_funcCntr = 0 ll_stuff = 0 "Beginning program!" fact = Factorial1(ll_Cntr) STR(ll_Cntr) + "! = " + STR(fact) *!* fact = 0 *!* fact = recFun(ll_Cntr) *!* STR(ll_Cntr) + "! = " + STR(fact) "End of program!" FUNCTION Factorial1 LPARAMETER n IF (n < 1) IF ll_funcCntr < 10 && track function call instances ll_funcCntr = ll_funcCntr + 1 "In Factorial1 instace " + STR(ll_funcCntr) ENDIF ll_stuff = ll_stuff + 1 ELSE IF ll_funcCntr < 10 && track function call instances ll_funcCntr = ll_funcCntr + 1 "In Factorial1 instace " + STR(ll_funcCntr) ENDIF && recursive call ll_stuff = ll_stuff + n*Factorial1(n-1) ENDIF && program returns here after each recursive call IF (ll_funcCntr > 0) && track function call cleanup "Performing Cleanup on function instance " + ; STR(ll_funcCntr) ll_funcCntr = ll_funcCntr - 1 ENDIF RETURN ll_stuff && returns to next line after function call && in the main code above **-- End Function FUNCTION recFun LPARAMETERS n && After the last recursive call, does the instance && of the function on the top of the call stack && return to the line after 'fact = recFun(ll_Cntr)' && && Or does it return to the next parent instance of the && function on the call stack until the last instance && of the function has returned to the calling command && && Is there a way I can stop the program in this function && after each instance of the function on the call stack && returns RETURN IIF(n>1,n*recFUN(n-1),1) **-- End Function Tag: Historical FoxPro
  - 14
    - Little Doubt with Grids Hi There, Actually I have a Grid containing 2-columns, and through the Add Object Method, I added the object of Combobox to the grid [column1]. Also the Combobox is having 2-columns...datas from table. When I click the 1st column of grid the combo box is acting properly.. My requirement is, If I select the First column of combobox, The First column data is replacing to column1 of grid automatically, but the second column of combobox data also need to replace the column2 of grid...at the time of selection it self.. for that anyone to help me please.... Above From...Paramu Tag: Historical FoxPro
  - 15
    - Catch "The uniqueness of primary or candidate key is violated." (Error 1884) in Browse window Hi Everybody, Help me, please I have problem with unique index. How to catch the message "The uniqueness of primary or candidate key is violated." (Error 1884) in Browse window (or Grid control). Because I want to display my message instead VFP's meassage. I use VFP9. Sorry because my english is not good! Thanks everybody Tag: Historical FoxPro
  - 16
    - Report Designer Hi all Is there date sorting on the field in the report designer Thank you. Tag: Historical FoxPro

Dumarest

This is really historical, back when FoxPro was independent. I just had a full system crash, and now want to get my one database with FoxPro back up. It will not run. Calls for a dll which is in fact on the system, but indicates that reinstalling the .exe file is desired. But ...... That is years ago, and any source material is on 5 1/4 inch diskettes if I still have them [generally these have long ago been discarded]. Any ideas welcome.

Re: Historical FoxPro

dni

What is FoxPro back up A third party software

Re: Historical FoxPro

Tamar E. Granor

If you have back-up, you can just copy the necessary files onto your recovered (replaced ) drive. Older versions of Fox don't need to run through an installation process.

Tamar

Re: Historical FoxPro

Cindy Winegarden

By "back up" he means "back up and running." :-)

Re: Historical FoxPro

Dumarest

That makes sense, but the required DLL is on the system, presumably reloaded by the new installation. But FoxPro does not know where it is, and clearly I do not know where it ought to be.

Dumarest

Re: Historical FoxPro

Dan Freeman

What version of Windows
What version of Foxpro
What dll is it asking for

You haven't given any of this information.

I personally have experience with Fox products going back to Foxbase in the early 1980's. There have been a LOT of releases since then. What on that continuum do you consider historical ;-)