Answer Questions

• Rob Ainscough Form Calling Report - Can Form Variables print on report?

  I have a form where users input a due date and comments into two fields. The users then click on a "Run Report" button that issues "REPORT FORM REPORTS/PD_LETTER TO PRINTER for next_due < THISFORM.p_date.value" command to print the report. Is there any way I can use the values the user entered in the form fields in the report that is generated. The form is a past due letter and I want to print Due Date and comment field from the form on it. On the report I created Variables that have the same names as the fields on the form, but this did not help. I suspect that I'm making this much more difficult then needed... Any ideas Derek Interesting point, I did not know that. You don't need any variables for that. You can dir ...Show All

• ToddOs autoincrement problem foxpro ADO and Visual C++.net

  Hi I am trying to enter a record into a table that has only two fields (for simplicity) the first (fielda) is of type auto increment and the other(second) is char 100. I can not insert data with the command INSERT INTO table (second) VALUES ("firstrecord") When i do this process driectly from an sql interface in VISUAL C++ IDE it runs ok. Looks like you are using the VFP ODBC Driver. The problem with that is that it was superceded in Version 7.0 by the OLEDB Provider and has not been updated to handle versions of FoxPro later than 6.0. This is not really a major issue UNLESS you have auto-incrementing columns in the data - they were introduced in Version 8.0 and ch ...Show All

• ssharma crosstab wizard

  hello everybody I use vfp 6.0. Can i select fields from multiple tables in crosstab wizard's  Step No. 1 We can select fields from multiple tables in query wizard. thanx' I don't know what crosstab wizard does (I don't use wizards). But thinking it asks for an alias as you describe answer is yes. Create your cursor before wizard using an SQL querying multiple tables if it doesn't let you do that in wizard. ...Show All

• Dobriendob Trouble using <> operator

  I'm comparing two character fields using the "<>" operator and I'm getting incorrect results if one of the fields happens to be empty. Here is some code: x = "abc" y= " " If alltrim(x) <> alltrim(y) n = n + 1 endif Since the IF statement evaluates to FALSE, n does not get incremented. However, if I rewrite the IF statement as: if not (alltrim(x) == alltrim(y)) n = n + 1 endif the statement evaluates to TRUE, and n is incremented. Anyone have any ideas why RIC VER: VFP 9.0 SP1 This was "Exactly" the right answer. Many thanks! Try the first if statement with SET EXACT ON and SET EXACT OFF, you will see the difference. ...Show All

• chris441962 About imgscan.ocx

  Hi, I had a prgram in Windows 2000 using imgsan.ocx that registered in window 2000. It was running good. But When I change the platform in Window xp. It occurs an error that It doesn't locacate the class. Even though I copy this class imgscan.ocx into the current dir. It still doesn't work. Can anybuddy help me Thx a lot. Hi, Could you please give the download from where you got the file Thanks If the file is in c:\mydir\ and if the file is ok(not corrupt) it should work. I download a new imgscan.ocx. Now it is working. Thanks a lot! You may try to register with (at start>run command): regsvr32 imgscan.ocx I try to use: regsvr32 c:\mydir\imgscan.ocx. It dis ...Show All

• Andrew Buyan the no server server?

  ok my client now wants the application i made to run on multiple computers. i am not a network wiz but i know a few things. will this work: 1. right click mynetwork places and do map network drive. ill make drive Z:\ and find a folder.... ok now i have drive Z:\.... now i do the same thing with the 2 other computers. So i now have 3 computers with drive z:\. on drive z:\ im going to have all the files. my questions are is this a good setup will it work out Yes it is very good if you can keep drivers mapping after computers restart(letter "z"), if not you can create a small setup application in you program to fix the default driver.You will also need to share t ...Show All

• SanjeewaM Grid and textbox Refresh issue.

  I'm having this problem with an application I’m writing. I have a Grid with a couple of text boxes next to it. When you select a record it updates the values in the textboxes with the values from that record. I also have a few command buttons that switch the tables viewed in the grid. Now here’s my problem... The text boxes stop updating after I change the tables a few times. Not sure what I am missing because I don't get any error messages and it does work for a little while. If you need more information let me know. In the AfterRowColChange I have: _mainform .refresh When you click on a command buttons to change tables i have: _mainform.grid1.recordsource = ("data\dvd.dbf") _MainForm.CATEGORYID1 ...Show All

• upgraders How to save the last used URL in VFP?

  Hi, I have this functionality in which the user is able to selct a webpage in my form, oBrowser = CREATEOBJECT("Internetexplorer.application") oBrowser.navigate(tcURL) now I would like to save the last used URL when user 'returns' to the (VFP9.0SP1) application. lcNewURL=oBrowser.LocationURL returns "" How to proceed to save this Thanks, When are you trying to access the LocationURL property After navigation to the page is complete the property is filled in correctly for me in my testing. You can also look at the BeforeNavigate2() event to trap/save the URL. Koen, I'm pretty sure (I don't have time to test this right now) the LocationURL doesn't populate until navigation i ...Show All

• JIM.H. Dynamic object creation

  Hi! Is it possible to create an image object at runtime in vfp 8. If yes then can any one tell me how to do it. Regards, >> Is it possible to create an image object at runtime in vfp 8 Of course. If you want it on a form just do this: ThisForm.AddObject( 'oImage', 'image' ) If it is an independent object, then use oImageRef = CREATEOBJECT( "image" ) Once you have created the object, just set its properties directly: WITH ThisForm.oImage .Top = 25 .Left = 50 .Picture = "C:\Graphics\myimage.jpg" [whatever else you need to set] .Visible = .T. ENDWITH The important one to note is VISIBLE - when you create a new object at run time it is always instantiated with Visible = .F. ...Show All

• SteveJB Purging data from Visual Foxpro using oledb in .Net

  Hi, Can any one help me on the below.... I am using Visual Foxpro as backed an Vb.Net as the front end... I am using the oleddb connection..... the following is the parameter.... "Provider=vfpoledb.1;Data Source= \\Data; Collating Sequence=general" I have a Visual Foxpro open table dabase which contains nearly a million record.... When I give select * from transcation where id='001' and cust='03' the time taken to purge this record is very high (nearly 5 min).... I have indexed the table on the basis of the above too (id, cust) feild. The purging of record is done thru front end vb.Net OleDB adapter Can any one tell me how to use the indexes which is creted in foxpro to return th ...Show All

• Peter Gloor Foxpro7 crashing with "fatal error exception code=c0000005 ..."

  Hi I have a tricky issue in my VFP7 application. At least tricky for me.  The application is crashing with fatal error C0000005. Sometimes I see a message like this one in the eventlog: "Faulting application <appname>.exe, version 1.4.82.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29.". Sometimes the application just hangs. I also see the Windows error "The instruction at "0x...." referenced memory at "0x.....". The memory could not be "read"", and then the application is closed, of cource. The error does only appear in situations where I print, but it does not occur in an exact pattern, or when I pass a particular code line. I use a third party dll called foxpp.dll ( ...Show All

• Petknep Using SQL to create a multi-periods sum result.

  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. sorry, but this is not what I asked... I need a cursor which each row has multiple years. Try again :-) Use GENXTAB.PRG that ships with ForxPro 2.6. Create a cursor that contains your data in three columns like this: ITEM MONTH SALE And then run the program to ge ...Show All

• Uturn ADO Performance Problem with FoxPro 6.0 & AS/400 use

  Hi all, I used ADO to connect AS/400 machine from foxpro 6.0 and i get data through processing SQL on it.The performance is very low when we try to connect to a AS/400 machine in a far place. Here is my code : * Procedure to get connection from AS/400 procedure GET_SERVER_CONN local Err, cOldErr, cn cOldErr = On("error") On Error Err = .T. cn = createobject('adodb.connection') rs = createobject('adodb.recordset') * MERKEZ10 - Name of server in network cn.open("Provider=IBMDA400;Data Source=MERKEZ10", "", "") if Err wait window "No connection with server!!!" nowait else return cn endif endproc Here is the procedure which gets customer list ...Show All

• Toon Nijland Grid class

  I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column heading centered vertically/horizontally and bold. With column # = -1, this cannot be done, as far as I understand (no columns in Propoerties). In "1001 Things You Wanted to Know About Visual FoxPro", c2000, page 163 ("How do I highlight the current grid row"), it says: "Fortunately, it ...Show All

• markovuksanovic buffering, Rlock() and FLOCK()

  Hi; I think I don't understand the concept of buffering. Can someone explain the following behavior I have a form which uses opt. table buffering. While that form is open by a user, I manually rlock() one of the records. Then, I ask the user to change the same record. The change, including the =tableupdate() goes through fine. I try the same with FLOCK(), and the change still goes through fine. Shouldn't FLOCK prevent the user from comiting a change thanks. OK - let me explain again: User A opens up an application and goes into a form. The form has a table that is open in an optimistic table buffering. At the same time, user B (Which happens to be me) opens up VFP, and issues the following commands: us ...Show All