Visual FoxPro

Page 169




  • Topics
    Replies
    Last post
  • Include tables bug?
    by hangover
    7 Replies
    Last post by CetinBasoz
      • Having successfully included a database and its tables into the compiled .exe of my application (see separate thread), I have now encountered a problem which appears to be a bug. When I run an SQL query normally - e.g. SELECT COUNT (*) FROM table INTO ARRAY laTest - it works fine. But when I run the same query using the EXECSCRIPT function - e.g. = EXECSCRIPT ("SELECT COUNT (*)
  • SMS through visual foxpro
    by Ravi Awasthi
    5 Replies
    Last post by SharathMum
      • Dear Sir, Please send me source code for SMS through visual foxpro, or favour me with some clues. Thanks & regards, - Ravi Awasthi
  • Error Msg: Connection:xFoxComm is busy
    by Jooooto
    6 Replies
    Last post by Jooooto
      • the subjected message: Connection:xFoxComm is busy. when running the Foxpro Application in SQL Server with WinXP workstation. pls help
  • 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
  • Uncommitted changes
    by AlexBB
    2 Replies
    Last post by AlexBB
      • Hi everyone. Long time no see. I've got a problem with a piece of code that I certainly debugged many months ago and thought that I would never have any trouble with it. It is just one block, but in fact I have many similar blocks. I am not sure if they are in trouble or not. This particular routine stopped working long ago and I decided to get by without finding out why and became preoccupied
  • Moving the record pointer
    by JCrum
    2 Replies
    Last post by JCrum
      • The docs say that when SEEK() does not find a match then the record pointer is moved to the end of the file. But if you are constantly changing what you are seeking then do you have to move the record pointer back to the top of the file manually For example: USE this.dbf IN 2 ALIAS this SELECT this INDEX ON name TAG name USE that.dbf IN 3 ALIAS that SELECT that SCAN FOR name = "MYNAME"
  • InstallShield vaporized project? (neophyte user)
    by lowellnelson
    11 Replies
    Last post by Rick Borup
      • I generated a VFP prg and build an exe version which run without errors. I then attempted to use InstallShield to prepare for distribution to another site (I am completely inexperienced with InstallShield), but the test installation halted before completion and provided an error code. NOW I FIND THAT MY PROJECT, WITH ALL TABLES, FORMS, AND REPORTS NO LONGER EXISTS. Have I so offended the InstallSh
  • Locate Command
    by Ahsan Amin
    5 Replies
    Last post by Fox Me Up
      • I am trying to compate a textbox value with field value and using found() function to check if found or not. I am entering the same value as it is in a table field but found() function returns false. I am using the following code: LOCATE FOR ALLTRIM(SubName) == 'thisform.txtSubName.Value' IF FOUND() MESSAGEBOX("This subject already exists") RETURN ENDIF
  • 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
  • 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
  • vfpoledb.dll access violation
    by abhinaw
    14 Replies
    Last post by CetinBasoz
      • We are using a COM+ VB component to access data. It uses Fox Pro DLL ( vfpoledb.dll dated april 2002 ). we are getting intermittent access violation errors in our application. I am posting event logs at the end. The interesting line is the last line ( vfpoledb!DllCanUnloadNow + 0x2144e ) . It shows that vfpoledb.dll thows error while trying to destroy a resource ( DllCanUnloadNow). It looks l
  • (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
  • VFP9 Distributable Requiring SOAP Toolkit ... vs InstallShield SOAP Options?
    by Docpro777
    1 Replies
    Last post by dni
      • I have a distributable, *My_HTML_Report_Distributable.Exe*, that seems to work only after I install SOAPsdk right onto the user's machine (... via the "MSSOAPSDK.msi" installer that ships with VFP-9 or the "SOAP Toolkit 3.0" thats downloadable from MicroSoft). This MSSOAPSDK prerequisite I had hoped could be installed by InstallShield LE "redistributable options&qu
  • How to remove redundant phrase in field?
    by Littletommy
    14 Replies
    Last post by Littletommy
      • Hi all........ I have a table field that contains things such as..... V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT -I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704 What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown abo
  • Qick Sql question
    by Brad McCormick
    4 Replies
    Last post by CetinBasoz
      • Good Morning Everyone, Quick question, how can i use a variable with a like statement as in select * from table where col1 like var
  • VFP Messagebox on top
    by Bit
    4 Replies
    Last post by Bit
      • Hi, Is there a way to display the messagebox on top of other window (Does it mean I need to use "Wait" or "do Form" ) Thanks, BIT
  • 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
  • GETDIR() in Windows Vista only displays Local Drives
    by JDM0759
    4 Replies
    Last post by PB_UK
      • Hi all, I've created a small application (EXE) using VFP9, SP1 and copied it to Windows Vista Business edition and a Windows Vista Ultimate edition machine. This application has a few command buttons to have the user select a mapped network drive path. I have tried GETDIR(), GETFILE(), and even stepped out of the normal VFP function realm and used BrowseForFolder method of the oShell object. No
  • Append General Image Problem
    by semperego
    1 Replies
    Last post by Naomi Nosonovsky
      • I have a re-occuring problem when attaching a bmp image into a general field. The image comes in with the image name showing at the bottom while the top is a very pixelated thumbnail. It only happens on some computers. Did anyone encounter such a problem and is there a solution for it
  • Calculated fields in grods.
    by Aleniko
    2 Replies
    Last post by Aleniko
      • Hi everyone; I've asked a similar question before, but I'm going crazy trying to set this up. In FP2.6 it was very easy in a browse command to add a calculated field. I'm trying to displacy some information depending on user's entry in the first column of a grid. I've setup the control source of the second column to ruginv.design+" "+ruginv.quality I've tested this with both sparse = .T.
  • File In Use
    by AlexBB
    14 Replies
    Last post by AlexBB
      • Trying to execute a delete command from .NET with OleDb driver I get an error: File in Use. It seems strange that a similar command appeared to have executed once before. That command is downstream of this one and that worked while the code around this one was not yet debugged and this ExecuteNonQuery was simply bypassed cmdm . CommandText = "execscript('USE crossRefTable in 0 EXCLUSI
  • Using SQL to create a multi-periods sum result.
    by Aleniko29139
    5 Replies
    Last post by AndyKr
      • Hi; I need to create a cursor with multiple columns listing sums of sales. For example: Product# 2006 Sales 2005 Sales 2004 sales 2003 sales 2002 sales Lets assume the table structure is simply ProductId, SoldDate and SoldAmount. This table obviously lists individual sales. Before I start xbasing my way into this, can I do this using a SQL select command Thanks
  • 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
  • do I have to close tables in DE?
    by Lightening
    9 Replies
    Last post by Naomi Nosonovsky
      • I have several tables in the DE of a form. When I close the form, do I have to Select myTable Use ..... to close these tables in the Destroy or Release event Or do they automatically close by themselves when the form is released
  • Problem indexing views
    by Hans L
    14 Replies
    Last post by Hans L
      • I am trying to index a view. After having created the view in a prg file, created with Gendbc, I add (in the prg file): USE vwMysoft INDEX ON cname TAG Namn OF vwMysoft USE In other words, I use the same commands I would use for a table. Okay Then, when I open a form where I need the indexed view open, I do: USE vwMysoft SET ORDER TO Namn Error message: Variable Namn is not found. Either I am m