Visual FoxPro

Page 146




  • Topics
    Replies
    Last post
  • how to get around processing a field if a command button is clicked.
    by ibbm
    8 Replies
    Last post by Naomi Nosonovsky
      • I have a data entry screen with fields that get validated and command buttons on the bottom to add, save, delete etc. when the cursor is on a field that has a valid event and I click on Save, the valid event happens before the save. I want to override all field validations if a command button is pressed. How do I do this Thanks in advance.
  • append the parent & child table
    by myfoxpro
    2 Replies
    Last post by Naomi Nosonovsky
      • What can i do if i will append the parent and child table For example the parent table is employee.dbf and the index is id_no(candidate) and the child table is name_child.dbf(regular) the index is id_name(id_no+name). How about if i will append the records in employee.dbf and name_child I dont want to upload with the same records... Thanks
  • Forms vs Formsets
    by rpp
    9 Replies
    Last post by Christof Wollenhaupt
      • I would like to know from the experts. Is it better practice to utilize forms instead of formsets A novice question, thanks in advance for replying. Richard
  • Copy File Error in Visual FoxPro 7?
    by Paul B Walker
    7 Replies
    Last post by Tamar E. Granor
      • When a COPY File Command is executed and a space is in either a folder name or a file name, the instruction is unable to handle it. I have tried a technique to put in " quote marks in the manner '"<path><filename>"' but then it gives me a syntax error. Is this a bug or am I entering the full path and filename wrongly If this is a known bug, is there a patch for it If not
  • 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.
  • 1938
    by dni
    4 Replies
    Last post by CChalom
      • When I am using "BROWSE...." in a click method I receive the error: "Object not contained in a form" If I press "Help" I have the error: Object is not contained in a "Name" (Error 1938) If I press "Ignore" it seems to working... Some ideeas
  • problem of SET NAMES
    by Darren5559
    1 Replies
    Last post by CetinBasoz
      • hi, i am using VFP9 with mysql and odbc 3.51 connector. i have a table called 'user', and the structure is as follow :- user_id varchar(10) password varchar(10) because i have to develop a system which can support chinese character, so i define a command "SET NAMES BIG5" in the mysql connector, this changes make the size of columns becomes double during View or SPT, instead of varchar(
  • blob field and reports
    by Richard1_1970
    1 Replies
    Last post by Alex Feldstein
      • I have a free table with a .tif saved in a blob field. Can anyone provide me with a small sample code or tell me how to display my picture in a report and a form directly from the blob field
  • SUBSTR() STRTRAN() with Large Text Files
    by Docpro777
    11 Replies
    Last post by Docpro777
      • Greetings Venerable Masters and Dear Friends, With a 'large' text file (HTML) edit requiring about 500 - 600 text-edits (deletions) (below) ... it takes 10 + seconds to execute and longer over LANs. My only question thus: Is there a faster way to make 500 text deletions to a large-text file Or, how might you consider doing multiple edits with large text files Thanks in advance for any co
  • (HELP) how to write a program for keyword search in memo field
    by fonn
    3 Replies
    Last post by CetinBasoz
      • I would like to seek help in writing a program in FoxPro 7.0 to open the memo field "expr" in many different reports, in which specific keywords "DUPLEX=1" or "DUPLEX=2" is stored in the memo field "expr". P.S. The keyword "DUPLEX=1" or "DUPLEX=2" is not the only things stored in the memo field. The keyword appears in different lin
  • check for filetype
    by ScottCamp
    10 Replies
    Last post by ScottCamp
      • Ok...I'm Back...LOL I'm trying to modify and old custom program someone made for us years ago. Simply to move files from one place to another. Everything works great. I'm trying to check if a file type exists in a directory (since the names will always be changing but the file type will always be a .jpg). If it does, then copy everything in that folder over. if a .jpg doesn't, then give a me
  • How To Findout Users System in VFP?
    by Paramu
    3 Replies
    Last post by Paramu
      • Hi There, Well. Actually I want to give Authentication rights for users to access my program accrding to their login... Suppose one user will log on different places of desktops...So I need to identify his system..means which user is currently sitting on which system.. For that I need to identify the system name or any ID ...And another thing is ..some systems they are using
  • Data not getting written to SQL.
    by Pauly C
    4 Replies
    Last post by Pauly C
      • We recently upgraded client to latest version of app that was also upgraded to VFP 9. Our client runs app in Citrix environment and we are seeing strange behaviors that at times data doesnĄ¯t get stored to the SQL Server 2000 backend, IĄ¯ve been able to prove this by creating and setting up auditing on SQL Server. At times itĄ¯s a segment of data at other times an entire row of data is lost. All o
  • Recursive function call stack cleanup
    by FoxCreek
    3 Replies
    Last post by CetinBasoz
      • 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
  • Primary Key Set up
    by AlexBB
    10 Replies
    Last post by AlexBB
      • I have a very pessimistic view on the FoxPro prospects in Vista. Nothing is working and it does not seem to make any sense even trying to fix it. Just too many things are screwed up. So I've decided to use my VFPOLEDB databases, write completely new C# ADO .NET code for handling all operations that before in XP were done by FoxPro Code. In order to do it I have to set up primary keys on my tables.
  • Get column name in SQL query
    by Victor BA
    14 Replies
    Last post by Naomi Nosonovsky
      • How can i obtain all the records in a specific column like: select field1 from table but instead of the name "field1" use a column number i'm guessing : select 2 from table // The number 2 being the third column (starting at 0)... is this the right way Thanks.
  • Storing the path of an image in a VFP9 table
    by Eduardo D
    3 Replies
    Last post by CetinBasoz
      • How can i store the path of an image in a table the path is c:\fish\cat.bmp After storing the path how can i retreive this image using a form. Im using VFP9
  • 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
  • Visual foxpro and Navision c/odbc
    by RobSmit_Vixia
    2 Replies
    Last post by RobSmit_Vixia
      • Has anybody any idea how to connect with VFP to an C/SIDE Navison database with the supplied C/ODBC 32 driver The notorious enexpected token error pops up every time No problem with Excel/access 2003 or Winsql But building reports in that stuff is rather too much work The problem is known on the Web. If possible please a tip If not possible please why not. Any ex
  • Why is qeury so slow?
    by Lightening
    10 Replies
    Last post by Lightening
      • I used this query statement. Code Snippet Sele a.*,b.address ; From NewCal a; Left Outer Join customer b On all( a.work_no)=b.wo_type+allt(str(b.wo_no)) Table A contains less than 1,000 records and table B contains about 30,000 records. In VFP6, it takes me a few seconds to get the results. In VFP9 + SP1, it takes me 4 min
  • How to make the new records on top of the existing records on the Grid
    by MillBear
    3 Replies
    Last post by dni
      • Hi There is existing records in the Grid. When I enter a new few records next to the existing ones in the grid, all the new datas are rolled on the bottom of the grid instead of the top (see Figure 1). 'Goto Top' donĄ¯t seem work well for my coding. How to make new records on top Valid Procedure of the TextBox do while i<50 and .textbox.value = dpq_refno
  • How to Call Web Page With POST Method in foxpro9
    by surinder singh
    1 Replies
    Last post by dni
      • Hi All I am here again with a new problem Problem: I need to show a web page to users that accepts 2 parameters say name & password through foxpro. But I need to call this web page by using POST method. i.e. if I call this web page by shellexecute function then it shows me the passed paramters in the url like this. web page: https://localhost/test/users/index.html https://localhost/test/users/
  • How to create a dBase III Table with a CDX index
    by Sergio Aguilar
    7 Replies
    Last post by dni
      • Hello, I'm trying to create a table of dbase with a cdx index, but when I create the index, the type of it is MDX, so I want to know if there is a way to create the dbase file with a cdx index in vb.net, tnx for your help
  • 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
  • Remote SourceSafe
    by Darren Woodford
    9 Replies
    Last post by Darren Woodford
      • Hi Guys Has anyone got any feedback they would be willing to share on 'Source Anywhere for VSS' (http://www.dynamsoft.com/Products/SAW_Overview.aspx ) by Dynamsoft. I am thinking particularly of integration with various versions of VFP. I tend to have all of my projects using the IDE integration and am hoping that this will work with this product. I am currently working from home on an acce