Visual FoxPro

Page 84




  • Topics
    Replies
    Last post
  • Search the subfolders from different folders
    by Karan CHAN CHAN CHAN
    9 Replies
    Last post by CetinBasoz
      • Hi all, I am preparing a small program, the main idea is to convert the txt file to .dbf. There is an "A" folder contains 405subfolders, i have to convert the file from the subfolder of "A" to subfolder of "B" ("B" folder also got 405 subfolers which have the same subfolder name with "A"). Now the problem is --> how do i se
  • Sqlexec() command line maybe too long.
    by Lolu
    8 Replies
    Last post by CetinBasoz
      • 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
  • merge fields ... right justify
    by rwsgy
    12 Replies
    Last post by Naomi Nosonovsky
      • I want to merge two fields and somehow right justify the second field (dollar amount) so that the decimal places are aligned like this: Record #1 Location = The Palace House Amount = 125.56 Record #2 Location = Convention Center Amount = 1.10 Record #3 Location = USA Wharehouse Amount = 6457.54 then RESULT should be: The Palace House 125
  • 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
  • textbox length
    by Ahsan Amin
    10 Replies
    Last post by PB_UK
      • when i enter something in the text box the cursor automatically moves to next record ater entering 30 characters. I have not set it's lenth. so what's the reason
  • how to gather m. variables from a form into table where it's updated in a procedure outside the form
    by ibbm
    14 Replies
    Last post by dni
      • Hi, I have created a form to update/add info into a table depending on the actions. I use a prg file for the actual update as this routine is used in several other procedures outside this form. in the INIT() of the screen I either do a blank screen if an add or display the record if it exists. I do this with a scatter memvar command. The objects on the forms have controlsources of m
  • VFP7 COM+ object and ASP.Net 2.0 on IIS6 - Interop issue
    by cpf
    7 Replies
    Last post by cpf
      • Hi,I wonder has anyone managed to get his/her VFP7 COM+ object run on ASP.Net 2.0 on IIS6 1. I compiled the object using MTDLL and deployed into my SBS2003. 2. I think this shouldn't be a security problem as I didn't manage to get it run even I have set the IIS6 worker to Local System. 3. The COM+ object has actually initialised. Codes in INIT method has actually run (I put CREATE TABLE ..... in
  • VFP6: Problem saving data
    by MillBear
    6 Replies
    Last post by AndyKr
      • Hi all The VFP database system is running in the server so that all the workstations can share it. The user complained that she could not save the data after amending. I tested to see whether I was able to save it on my side. It works successfully. I went back to the user¡¯s workstation to verify it but still the same problem. I tried other workstations and found no problem so far.
  • Dot matrix printers with Visual Foxpro
    by Farhat Fakih
    14 Replies
    Last post by Lakshmi N
      • Hello all, We are in the process of converting an old Foxpro 2.6 (DOS) software into VFP, the problem that we face is that the printing is very slow on dot-matrix printers We cannot shift to laser printer as the stationery is pre-printed and has to be multi-part. Can anybody offer the solution Thanks in advance
  • how to create a setup wizards?
    by honey1016
    2 Replies
    Last post by AndyKr
      • Sorry for the incomplete questions before. Yes, i know how to build an executable but i really don't know how to create a setup wizards in Version 7.0 but in Version 5.0 you can only click the Tools--->Wizards--->Setup. Where's the Setup Wizard in Version 7.0
  • Using database in network
    by Sixon
    3 Replies
    Last post by dni
      • I've build a database program with Visual Foxpro, and use Visual Foxpro database/table. Example : Select 1 use c:\data\table1 But sometimes my database/table located at server drive (my network place). So I typed, for example : Select 1 use \\server\data\table1 It doesn't work properly, because Visual Foxpro cannot recognize the network drive. How to solve this problem ....thank'
  • I am trying to use a form's properties in a program but i am having trouble accessing the active form.
    by ibbm
    11 Replies
    Last post by Tamar E. Granor
      • I have a form that collects data and when the user clicks on "Confirm" I'm trying to run an update.prg which is called by many other routines in my application. Rather than add a whole lot of methods to the form I was hoping I could use this program. I am newbie to OOP so maybe I am taking the whole wrong approach. I have added properties to my form that i want to access. In pa
  • Assigning an array to an Activex property
    by Mike@hcc
    8 Replies
    Last post by Mike@hcc
      • 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"
  • 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
  • Finding users who open tables
    by Riclo
    2 Replies
    Last post by Bruno Yu - MSFT
      • I need to know how to find users who have the tables open in a directory. I found a solution but i've get an error message at the registry. If somebody knows how to do this i'll appreciate the help. Thxs.
  • I need new version of foxtools.fll
    by BIENVENIDO AYBAR
    3 Replies
    Last post by BIENVENIDO AYBAR
      • Please, I have a serious problem My upgrade Vfp 9.0 came with FOXTOOLS.FLL of date 12/13/2004 and this one does not have the instructions _edsave and _edclose (). It is supposed that SP2 and ¡° Sedna ¡° should have them but nevertheless it does not have them. It looks like to me a bug of Microsoft. _wontop (), _EdSendKey (lnwhandle, 42), _Edrevert (lnwhandle) and others if they are
  • GENDBC and Filters
    by CChalom
    7 Replies
    Last post by CChalom
      • Hi, Is there a modified GENDBC version available that allows the recreation of a DBC keeping the filter expressions from the tables contained Thanks in advance Cesar Chalom
  • Combo
    by Ahsan Amin
    4 Replies
    Last post by Ahsan Amin
      • LOCAL nCnt FOR nCnt = 1 TO thisform.cboCourse.ListCount IF thisform.cboCourse.List(nCnt) = ALLTRIM(a_Courses.CourseName) thisform.cboCourse.Selected(nCnt) = .t. ENDIF ENDFOR But selected item is not apearing on top of the combo's list.
  • Performance of Foxpro OLEDB
    by cajin
    13 Replies
    Last post by CetinBasoz
      • I am working on a project which accesses foxpro 9.0sp1 database through OLEDB. The datbase has about 1million records. My code simple and straighforward just like below, conn.Open(); OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = "DELETE FROM mytable" cmd.ExecuteNonQuery() conn.Close(); But it will take a very long time to mark all records as deleted
  • wait windows
    by jmom
    4 Replies
    Last post by Naomi Nosonovsky
      • Is there a way to change colors on wait windows so they stand out more
  • Olecontrol parameters
    by andrew552717
    14 Replies
    Last post by dni
      • Hi! I need some help again. I have small ocx in vb and I want to use it in vfp6.0. It is working in vb this way: FK524ID1.SetIPAddress lpszIPAddress, CLng(txtPortNo.Text) where lpszIPAddress = "192.168.1.201" and txtPortNo.Text="5005" In VFP, when I dclick on "SetIpAddress" method in the Properties window, it is poping up new window with
  • Copy and Past function under VFP9
    by Lightening
    6 Replies
    Last post by Craig Berntson
      • I found the Ctrl+C and Ctrl+V function under VFP9 is not working on the users' end. Sometimes, I found the same problem on my PC. What seems to be the problem
  • Setting a date in VP 6
    by ibbm
    4 Replies
    Last post by ibbm
      • I want to set a date field to zeros I use to use "replace datefield" with {"00/00/00"} but vp 6 doesn't like it. Any help would be appreciated. Thanks
  • Using grid
    by AngelOfPirate
    3 Replies
    Last post by Louie Angelo Guirigay
      • I have a grid in my program that display an information in sorted and the moment I click any data within the first colum of my grid it automatically display all information in the corresponding objects within the form. What i want to do next is, if ever the focus within the grid and i type the first letter of the record which i want to find it would highlight the record that starts with the charac
  • Compile Problem
    by Ed W
    4 Replies
    Last post by SPeck2200
      • Hi, I've been working on the program a number of contributors helped me with several weeks ago. Though I've been making steady progress, something beyond my experience popped up today. I'm using VFP 6 and I'm trying to run a program from the command window. The command I am using is: DO c:\pathname\filename.prg I am getting an error window with the following message: c:\pathna