Visual FoxPro

Page 195




  • Topics
    Replies
    Last post
  • Linking Foxpro table to Access 2003
    by rkennebeck
    4 Replies
    Last post by rkennebeck
      • I am trying to link a foxpro table in Microsoft Access 2003 using ODBC. The package I'm linking to is in VFP 9 (I believe). When I do the link, and then try to open the table, it says: "The field is too small to accept the amount of data you attempted to add...." When I view the structure in Access, I notice that there are several binary fields. When I query the tabl
  • Rerunning the query for a grid
    by mathmo
    4 Replies
    Last post by dni
      • I've got a grid on one of my forms (created simply by dragging and dropping a query from the data environment onto it). I'd like the data in the grid to be be updated depending on what the user has selected from a combobox (i.e. have the query be run again based on the new user selection from the combobox). Refreshing the grid isn't enough, I haven't been able to get the grid to show anything else
  • 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
  • Marcia G. Akins and every body help me..
    by le tan duc
    3 Replies
    Last post by le tan duc
      • In any key (in registry), always have a string named "(default)" (there is always have a string named "(default)" in any key) Please help me to read and set new value to this string ( (default) ) Thanks
  • select sum( ) into array return null
    by Dwntrdr
    3 Replies
    Last post by CetinBasoz
      • Does anyone have any idea why the following code : select sum(patfee - patpaid + patapp - patpay) from cledger ; where chart == oPatient.get("chart") and date() - entered < 30 ; into array aResult returns a .NULL. into the array, which is qutei contrary to the documented behaviour of : Note If the SQL SELECT statement does not return any records, an existing a
  • VC+VFP+ADO+filter
    by boldeagle
    1 Replies
    Last post by CetinBasoz
      • why "filter "attribute not support wildcard "%" in the front£¬but it is ok for those not prefix with"%": str.Replace(' ','_£¡'); str.Insert(0,'%'); sqlStr.Format("comment like '%s'",str); m_pRecordset->Filter=(_bstr_t)sqlStr;
  • FWRITE always return 0
    by Eddie N
    2 Replies
    Last post by Eddie N
      • I open and write a file in low-level, using FOPEN and FWRITE. All goes well except one. When I call the FWRITE, the return value is always 0 , whereas the HELP file clearly stated that "FWRITE( ) returns the number of bytes written to the file. If FWRITE( ) can't write to the file for any reason, 0 is returned." But the file is there, the string written to the disk. Code Snipp
  • Little Doubts with Reports - Tables Area...........
    by Paramu
    6 Replies
    Last post by Orkutian
      • Hi there, I have a problem with my reports preview. Actually I used a free Table and its used in area12 [Select 12] in a form. And the Report - Preview is through a command button of a Form¡­ In Command- Window the report is working good [ie. . Do form ¡°abcd1.scx¡±]. At the same time after compiling EXE, if I click the button its¡¯ saying error something like¡­ ¡­¡­¡­.. ¡°File Does not exist¡± But i
  • Retriving data from DBF file
    by Helloworld2482
    9 Replies
    Last post by CetinBasoz
      • I am trying to retrive selected records from foxpro DBF file, i am using VB6 and for connectivity i am using ODBC. Foxpro DBF file is having more then 4 lacks records and it is taking lot of time to bring the records. Can anybody help me to solve this issue, Regards
  • command window always on top
    by mark1110
    2 Replies
    Last post by mark1110
      • Hi, I am trying to figure this out for over an hour without much luck. When I open a table and browse it, the command window always stays in front. How can I get it to go to the back so it won't be in the way Thanks, Mark
  • MS Access importing visual foxpro tables
    by Dave Mosby
    14 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
  • Open Source VFP?
    by Claude Fox
    12 Replies
    Last post by Tamar E. Granor
      • Ok, this article looks fairly balanced and states that MS is seriously considering an Open Source VFP!: http://arstechnica.com/journals/microsoft.ars/2007/04/03/developers-petition-for-the-return-of-visual-foxpro
  • Browse causes Fatal Exception in VFP 9 Runtime
    by Jim Vahl
    3 Replies
    Last post by Naomi Nosonovsky
      • We have a widely-distributed application written in VFP6. We are contemplating migrating to VFP 9. We're using SP2. During testing we have encountered an error which we can't get around. The same code runs fine under VFP 6 as well as in the development environment. We use this for debugging. When using a table with +/- 1000 records and then BROWSEing that table, VFP throws a Fatal error: Except
  • forms: control values
    by jmom
    2 Replies
    Last post by Naomi Nosonovsky
      • I have put a checkbox control on my form. The Controlsource is just a variable, not a field from a table. I store .f. to the variable in the load event of the form. In the LostFocus(), I check on the thisform.<control>.value. If it is 1, then i store .t. to the variable if it is 0 then i store .f. to the variable. By the time it goes into a program ran from this form, i have a operand/
  • 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
  • Insert data into FoxPro database
    by suednym
    4 Replies
    Last post by suednym
      • My C# application attempts to insert data into a Fp database. I have used the data adapter config wizard to create the Select and Insert commands. When I attempt the insert I get the following eror message : Server was unable to process request. --> System.InvalidOperationException: OleDbCommand.Prepare method requires all parameters to have an explicitly set type. etc etc An extr
  • Validations on Textbox
    by Ahsan Amin
    14 Replies
    Last post by Phil Brammer
      • 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
  • Visual FoxPro9 Report Designer BUG
    by MariusR&amp;#64;R
    10 Replies
    Last post by VSCG
      • 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
  • how to set focus (or place the cursor) on a field in a form using code...
    by ibbm
    13 Replies
    Last post by CetinBasoz
      • Going back to the olden days I used to be able to move my cursor by using the code _curobj = _objnum(myfield) How do I do this in Fox 6 What I am trying to do is at the click of the command button, clear my screen and start the user on the first or second field depending on what he is doing. Thanks in advance.
  • Troubles with a form --Expression Evaluator Failed--
    by Spangltk
    2 Replies
    Last post by AndyKr
      • In my form the user is typing the name of a product in a text box. Then they will add attributes to that product. I want to have a label underneath the text box that will dynamically change with what they are typing. Searching for existing products and displaying the closest match. That way if they want to edit an already existing project they can find the name. this is my code, its placed in the
  • 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
  • How to use sql server database
    by Hemangi
    6 Replies
    Last post by Darren5559
      • Hi All, I got really very good help through this forum! i need to access sql server database through VFP. pls show me how can i do that. how connection string works in VFP. Regards Hemangi
  • Passing multiple variables from forms w/ VFP7SP1
    by KDKephart
    14 Replies
    Last post by Naomi Nosonovsky
      • I'm an old Clipper (S' 87) programmer that needs to figure out forms with VFP. The attached code generates a form containing a set of four optiongroups that set basic comm port parameters on the local host for serial communication with an instrument (usually an electronic balance). I'm trying to use the form to replace a series of cascading menus in the original program. My intent is for the form
  • Indexing of foxpro application
    by allyabbas
    5 Replies
    Last post by dni
      • Hello, I have an issue regarding a visual foxpro application. When u work..it freezes and if u reindex it tell u to delete index file and restart indexing. i dont know which file to delete etc. I have to find a solution very quick as i am not being able to use the application. Thanks & kind regards Ally
  • importing from excel
    by JonathanVickers
    22 Replies
    Last post by JonathanVickers
      • 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 connec