-
- How to select a record from a Grid and open a form
by msw
- 14 Replies
- Last post
by msw
- Hello, I'm new to VFP 9, but I'm working at it..
I have a simple form that displays a Grid with my customer records. I would like to double click and or press the enter key on a given record on the grid and open a form to make editing earier and then return to the grid when I'm done.
Can anyone give me some help with this...
Thanks...Scott
-
- Problems with FSEEK()
by Ken Reeder
- 1 Replies
- Last post
by CetinBasoz
- I have encountered two problems using FSEEK(handle, 0, 2) to find the end of a file: In both VFP 8 and VFP 9, it is possible that the function FOPEN(filename, 1) will return handle number zero. When this happens, the function FSEEK(handle, 0, 2) appears to not work -- it always returns zero. Secondly, in VFP 8, if you FSEEK to the end of the file, then write to the file using FPUTS(), then do anot
-
- Upgrading to Foxpro 9 SP2 causes Interop errors
by Atish R Chandra
- 10 Replies
- Last post
by Atish R Chandra
- I've been working on some custom software which uses a multi-threaded COM server which is called through VB.net. Before upgrading to SP2 I have had no issues, however now that I have upgraded my system to SP2 I can't get the VB.net code to create the foxpro COM object correctly. I keep getting the following error System.Runtime.InteropServices.COMException 0x80010105 I haven't been able to isolate
-
- How to calculate the data connection time?
by Lightening
- 10 Replies
- Last post
by Lightening
- I tried to add 2 fields, time_on, datetime, time_off, datetime
to calculate user's log on time in the Users.dbf.
How do I calculate the total time between the 2 value
Any better way to capture users' activity
-
- vfp 6 forms
by jmom
- 2 Replies
- Last post
by jmom
- Here is my situation. I am filtering in a combo box in reference to some info entered in a previous textbox. My problem that I am having is when you navigate records using the wizstyle textbuttons the info displayed disappears. I have tried set filter to in this.comboname.valid and lost focus events, but it still does not display info. I noticed that it seems to still go by the last combo box got
-
- What fires first Init() or Load()
by rpp
- 8 Replies
- Last post
by MarciaAkins
- Does the Init() procedure of a form, fire before the Load() procedure of the form.
I am trying to use a SQL Select in the Load() of a form with a passed form property from a ComboList box [a value set within it's Init()]. I had hoped to initialize the passed property before the Forms Load() event and its SELECT-SQL ran, then optionally let the user select different values in the ComboList b
-
- Not Enough Memory o Complete the Operation.
by AlexBB
- 14 Replies
- Last post
by AlexBB
- There is a chance that this is not the forum where I will ultimately get an answer since I do not know where the root of the problem is but still I am asking for everyone's attempt to brainstorm.
It is actually a continuation of the previous notorious PACK <tableName> thread. Since I felt that I ran into a stonewall I devised a DEVIOUS (!) plan to crack the problem. It appears to ha
-
- Visual foxpro 9 watch hang
by cristi_bd
- 11 Replies
- Last post
by cristi_bd
- I was testing a program with debug and watch window . I enter a function in the watch windw than a window like passward with no title apears and evry think is bloked. I have to end forcely by task manager. Since than evry time I start watch window I get the same window and bloking situation.I uninstald Visual fox pro and I reinstald it. The same think. I uninsald Visual FoxPro and&n
-
- New Grid Columns
by dni
- 9 Replies
- Last post
by dni
- I am running a form with a grid with 12 columns. It is working fine. At one moment in a click method I am adding more 8 columns . How can I do that new columns to have the same settings with old columns (header and textbox (font size,font,color,allignment...) I don't like to write 8 times settings for each properties ...
-
- Microsoft is going open-source the core portions of the Visual FoxPro DBMS!
by Fernando D. Bozzo
- 12 Replies
- Last post
by Fernando D. Bozzo
- I want to be between the first ones to bring this news:
http://www.eweek.com/article2/0,1759,2105307,00.asp
!Can't believe that!
Best regards,
Fernando D. Bozzo
-
- Updating DBF from SQL server
by tazvier
- 6 Replies
- Last post
by tazvier
- Hi to everyone. I have the following issue; I need to update some information in DBF files but with a SP from SQL server. I have a linked server in my SQL server pointing to DBF directory. When I execute the following commands, I get everything ok:
Select * from LinkedServer...mytable
Insert into LinkedServer...mytable values('fiel1',¡¯field2','')
But when I execute Update and
-
- Report pulling incorrect data
by MauriceHErbst
- 5 Replies
- Last post
by Rick Borup
- I am modifying an existing report and program and have attempted to add the new fields to the cursor the report runs but instead of the actual last labor date I am getting whatever is in the first record in that corresponding field in that table. I believe it is in the SQL statements but cannot get it to pull correctly no matter how I modify it. I have ran this query as a view in SQL 2005 and i ge
-
- Query result on textbox
by Victor BA
- 5 Replies
- Last post
by CetinBasoz
- I'm trying to return a value from a query and show it in a textbox, like this:
use table1
private x;
select count(*);
from table1;
into x;
thisform.textbox.text=Str(x)
&& I also tried ..... x=select count(*) from table1;
but doesn't work, what am i doing wrong
thanks
-
- form
by NILKAMAL
- 1 Replies
- Last post
by Craig Berntson
- hi!
thanks for your help
i create two table one is customer and second customer detail and both related with field ( cust_id) now i create a form where i can put cust info and grid where i can see a customer detail if has any in customer detail form now i am trying to create one command button in form so i open a customer detail form with same cust_id in my main form and rest of field refres
-
- MD5 File Checksum
by UHTMilk
- 5 Replies
- Last post
by Naomi Nosonovsky
- Hiya, I would be very grateful for any advice anyone could lend on obtaining a file checksum in VFP. At the moment I'm trying to find it by calling the fciv utility with the run command.
Like this: -
Code Snippet
doscmd = "fciv -md5 C:\t.prg" DECLARE INTEGER WinExec IN win32api STRING command, INTEGER param retval = WinExec(SYS(2004) + "FOXRUN.PIF /C " + doscmd,
-
- Printing to a Triumph-Adler
by DaCosta11
- 1 Replies
- Last post
by dni
- One of my customers recently, bought a new printer, a Triumph-Adler DC2310, the printer runs fine with many applications, except with visual foxpro. It crashs VFP when I try to print. Anyone has a solution DaCosta.
-
- 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.
-
- go to googleearth
by bijansaba
- 9 Replies
- Last post
by Naomi Nosonovsky
- Hi
i Hi
i want tape name of one city as TEhran in a textbox and click on one boutton
and automatic go to show this city in googleearth what must i do
thank you
-
- Backup index files and .DBC
by Victor BA
- 4 Replies
- Last post
by AndyKr
- I've used this code to backup the tables (.DBF files):
gndbcnumber = ADIR (gabasedatos, '*.dbf')
FOR ncount = 1 TO gndbcnumber
WAIT WINDOWS "Respaldando la tabla: " + ALLTRIM (gabasedatos(ncount,1)) NOWAIT
USE ALLTRIM (gabasedatos(ncount,1)) IN 0 EXCLUSIVE
COPY ALL TO ub + ALLTRIM (gabasedatos(ncount,1))
USE
ENDFOR
but how can i backup the .
-
- Web page scrapping form Visual FoxPro
by Jim Holloway
- 2 Replies
- Last post
by Jim Holloway
- I am not sure if this is even possible so i will just say what i am hoping to accomplish and let you all tell me how crazy it is. i want to have a foxpro application on my computer that opens a set of webpages i want to knoe if it is possable to look for a set of numbers on the page once it is opened. the numbers will probly never be the same. is this possible in FoxPro 8.0
-
- Run VFP app in the background on Win Server 2003
by Aleniko
- 3 Replies
- Last post
by Claude Fox
- Hello again... I need to run a vfp app in the 'background' to do some maintenance stuff. I was wondering what is the way to have an app run without an actual interface. Do I build a com server Any publications on the subject Thanks.
-
- printing report in vfp as excel grid lines
by vineet4001616
- 3 Replies
- Last post
by Naomi Nosonovsky
- How i print report as excel grid lines in vfp
can you give a source code to generate report as excel report printing with gride lines
vineet
-
- VFP Fax Integration
by emery
- 10 Replies
- Last post
by emery
- Hi,
I tried #2 method and stuck. Then I tried #1 method, it works for report with graphic. However, I need a way to pass parameters to Send Fax Wizard.
Thanks for your help.
Emery
------------------------------------------------------------------------------------------------------------------------------
Method #1:
When I used the following code to fax
-
- uniqueness
by honey1016
- 1 Replies
- Last post
by CetinBasoz
- what's wrong with my program because i dont want to duplicate the tin records. The error is "Uniqueness of index TIN is violated". Where can i put this progam Because i put this to my validation method. Please help me...
if !empty(thisformset.form1.pageframe1.page1.txtTin.Value) set exact off select pds_data set order to tag tin go top seek allt(thisformset.form
-
- Can vFox9 printing using Excell worksheet layout!
by johan2000
- 6 Replies
- Last post
by Naomi Nosonovsky
- Dear sir,... One of the nice things about Excell is user can adjust font size, position, etc easily without the help of programmer!... (specially for printing TAX form, etc) If I have a record of data to be printed, and I wanted to print according the layout in the Excell worksheet, How can I do it Such that the vFox9 will print according to the layout/font size/style in the Excell form. Inside t