Visual FoxPro

Page 255




  • Topics
    Replies
    Last post
  • Overcome 255 character limit in grid control
    by Marc Bachman
    11 Replies
    Last post by Naomi Nosonovsky
      • I am using a grid control on a data entry form within an existing application. I have been advised ( at a VFP group ) to use an edit box on the grid control instead of a text box to overcome the 255 character system limit for this field. I have tried this, but it hasn't worked, even after recompiling. I'm not sure whether there is more to do, or whether I need to change my procedure, or even if th
  • Need better performance with FP Tables
    by SerialCoder
    12 Replies
    Last post by SerialCoder
      • 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 run
  • Trying to establish a relationship
    by Hans L
    9 Replies
    Last post by Hans L
      • I have always found it very difficult to establish relationships :-) Where I have read about them, I find that I cannot get the entire picture. I have my two tables, I have the correct fields, all is correctly indexed, and then, what When I read ... SET RELATION TO [ eExpression1 INTO nWorkArea1 | cTableAlias1 [, eExpression2 INTO nWorkArea2 | cTableAlias2 ...] [IN nWorkArea | cTableAlias ] [A
  • 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
  • filter breaks in vfp?
    by jmom
    6 Replies
    Last post by dni
      • Hi, I have a form that used a freetable that is filtered in the load event. select <alias> set filter to <custnumber field> = <certain number> I also have on error set filter to <custnumber field> = <certain number> throughout different parts of update events of my textbuttons Somehow a user got to see an unfiltered table. I have not been able to
  • refresh form
    by NILKAMAL
    14 Replies
    Last post by Naomi Nosonovsky
      • hi! i create simple form with table field and i create another two textbox in sam form (which is not table field) when i go to next record the table field got refresh but other two textbox have same value of previous record so can anybody tell me how do i do to refresh all field including textbox( not table field) thanks
  • barcode scanners
    by Fox Me Up
    3 Replies
    Last post by Aleniko
      • hi guys... one of my clients would like a barcode scanner. How can i emplement one into my foxpro app Is there any thing that plugs into a usb or something and when scanned it just reads in as if someone typed in those values on a keyboard Any help or recomendations is much apreciated. Also how much do they run for
  • Validations
    by Ahsan Amin
    11 Replies
    Last post by CetinBasoz
      • I am trying to validate numeric and character type data, entered by user in textboxes placed on the form. Can any expert tell me which functions to use or you could tell me what should i type index button of VFPs help to find all type of data validation functions
  • replace image with own name
    by NILKAMAL
    14 Replies
    Last post by NILKAMAL
      • hello! is any way replace my image with include reeno or any field data like i take image from my webcame and it store in one folder after that i use replace command so it save path in my field but when i replace that time image name want to change here is my code below DO [C:\Program Files\EZTwain\VFP\EZTwain.prg] TWAIN_SelectImageSource(0) * Get list of devices into memory TW
  • Append Records with multiple child tables
    by honey1016
    4 Replies
    Last post by AndyKr
      • What can i do if i will append the records with many child tables and it wil not affect to the database if your already append the records Please give some example of append. Thank you very much
  • Not Enough Memory o Complete the Operation.
    by AlexBB
    14 Replies
    Last post by AlexBB
      • There is a chance that this is not the forum where I will ultimately get an answer since I do not know where the root of the problem is but still I am asking for everyone's attempt to brainstorm. It is actually a continuation of the previous notorious PACK <tableName> thread. Since I felt that I ran into a stonewall I devised a DEVIOUS (!) plan to crack the problem. It appears to ha
  • receive value returned by an exe
    by RavindraPatil
    4 Replies
    Last post by dni
      • dear friends, I want to know how is it possible to recieve a value from a standard exe file and store it  in a variable e.g. if "returnvalue.exe" file returns a number that is to be stored in a variable "mvalue". how to do it
  • MS Access importing visual foxpro tables
    by Dave Mosby
    28 Replies
    Last post by Dave Mosby
      • 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&qu
  • RichText Control
    by Daniel CW Tan
    2 Replies
    Last post by Daniel CW Tan
      • Hi All, How do I print a report with a memo field that has richtext control in a form What I am trying to do is print the report with the same bold and italic fonts as the text in a memo field using richtext control in a form. Does anyone know if this can it be done Thanks in advance.
  • delete currant rec
    by NILKAMAL
    6 Replies
    Last post by NILKAMAL
      • hi! i am new in vfp here is my problem when i delete it delete first record in table not which i view (or currant record) here is code #DEFINE MSGBOX_YES 6 #DEFINE C_MSGBOX1 36 #DEFINE C_DELETE1_LOC "Are you sure you want to delete this customer - " #DEFINE C_DELETE2_LOC " " lcMessage = C_DELETE1_LOC + ALLTRIM(CHECKCUST.First_NAME) + C_DELETE2_LOC lcLAST_NAME = C
  • Comparing cdx, idx, ndx
    by Bit
    5 Replies
    Last post by CetinBasoz
      • Hi, I found that there are serveral type of index format for a foxpro table ama.dbf Does it mean that if I use i> If I use cdx index, then the syntax would be index on height tag height. use ama order height. or use ama set order to height ii> If I use idx, then the syntax should be index on height to height use ama index height or use
  • ole erro class not registered
    by Fox Me Up
    4 Replies
    Last post by Fox Me Up
      • im using the foundation datetime class _olecalendar and i keep getting an ole registration error. The system im using it on is windows server 2003. I have looked on google for a solution but none of the ones i found worked. I cant register the .ocx control b/c i dont no where it is. Please help me get this class working I have never gotten this error before but on all the other computers i
  • How to access methods of an Activex in a .prg
    by Geoffrey Callaghan
    6 Replies
    Last post by Geoffrey Callaghan
      • I have created a Winsock Activex control in a FoxPro 6.0 program, and it works OK, but I don't know how to access the DataArrival function in code. If I was in a form, I'd just double click on the control and it would be there, but since I created it using CreateObject, I don't know how to tie a function to that event. Geoff Callaghan
  • How to show properties window to a file in foxpro
    by surinder singh
    14 Replies
    Last post by surinder singh
      • Hi I want to show the properties window to the file selected by user on right click -> properties option. (as this is shown with any file when we right click on that file and click on properties option in widows explorer) If anybody knows about it , please tell me how to do this If any one knows to do this in Visual Foxpro then it will be good for me.
  • Default values
    by Hans L
    8 Replies
    Last post by AndyKr
      • I seem to have some trouble getting default values to show, in particular in optionsgroups. Where would I state the default value I have one optiongroup with 15 values, and I want no 11 to be the default. I tried to put 11 in .value, but that does not seem to work. Hans L
  • Debugger Failure
    by Victor BA
    1 Replies
    Last post by Dan Freeman
      • I have a BIG problem... an error happened in VFP while i was working, and now, each time a use the debugger even by accident (program exception), opens and cycles the "Select Directory" dialog, and keeps showing itself, i can't cancel it, or select a folder, it keeps showing, and i have to quit VFP the hard way (with Task Manager), i need the debugger to be functioning!! , can i reset i
  • Showing one form from another
    by Hans L
    11 Replies
    Last post by Hans L
      • Situation: I am in a form A, click on a cmd, and it opens another form B and hides the current form A. In form B, I click on a cmd and I would like to show form A and release form B. The release of form B works, of course, but not the showing of form A. I have never seen anything about whether it is possible to make changes in or affect one form from another. Is it (I guess it would work with a fo
  • Problems faced in deletion
    by SrikarGhanekar
    2 Replies
    Last post by MarciaAkins
      • I have developed my own software to carry out bulk data processing. I am using multiple files within the programs. Abruptly for a certain file I see the file does not exist message. When I explore the folder the file is converted to .TMP file. It does not get restored to its original name. This happens only when I issue PACK or Sort command. At a time nearly more than 15 files are open
  • How to add View to custom menu/ Non DOS COPY
    by Gary Demi
    2 Replies
    Last post by Gary Demi
      • 1) I have developed an app which has it's own menu (replacing the standard foxpro 9). Now that I am trying to use Modeless forms I want to add a View menu to keep track of them and select the proper one. Can I copy (and how do I do it) VFP 9's standard view menu If not what is a quick way to do this. 2) I am using the RUN command to copy jpg's from 1 directory to another, how can I avoid going to
  • Copying a numeric value with decimals from a cursor into excel without rounding up
    by mrfitness
    14 Replies
    Last post by Naomi Nosonovsky
      • I am having trouble with copying numeric values with decimal places into excel. I have a select statement (some being sums of numeric fields with 2 decimal places) with a group by function and I place these results in cursor c1. When it tries to enter this value into excel, it rounds all values up. (eg 309.66 becomes 310) I tried changing the format of the excel file to numeric with 2 decimal plac