-
- 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