Answer Questions

• AndrejJ foxpro dos to visual foxpro 9 conversion

  I am trying to convert an existing application I created many years ago in foxpro 2.5 for dos, but when I try to run my programs I get this error: File 'get_last_key.prg' does not exist. Can anyone help me. I'm completely new to visual foxpro any help will be greatly appreciated. Thanks, bertle The sample code you showed basically sets the function keys to run a program called Get_Last_Key which seems to be missing. This could be either a separate program: Get_Last_Key.prg that you should look for in the project or disk or could also be a function/procedure inside a procedure file. This would be a prg (e.g. MyProcedures.prg) containing several functions or procedures. You "show" the ...Show All

• awj100 Cursor adapter problem

  I create cursor adapter with data source type = native, set path to database, in data acces tab I select all fields in table and set buffer mode override = optimistic table buffering, in tab auto-update i set: auto update and update all fields. After that i drag and drop cursor in form and make grid. In properties on cursor i set: AllowDelete = .T., AllowUpdate = .T., AllowInsert = .T. but when i run form i can update only grid, table in database isnt updated . When i mystake Are you calling tableupdate() I put TABLEUPDATE( 1, .F., This.RecordSource ) in AfterRowColChange I solve it! Thx to everyone to help! ...Show All

• Deanrm Syntax Difference

  can some one please tell me the difference between accessing a tables info by using these two different approaches Table.Field or Table->Field thanks in advance Actually, Cetin, Table->Field comes to us all the way from dBase. The -> actually works pretty much anywhere we're using a . these days: _screen->Caption = "Hello" and you can mix an match. (Useless trivia, I know. :-)) They're same. Table->field style is less known (maybe only by those who are coming from foxbase days) and not used. It is dereferencing pointer coming from C (old fox was using Watcom C as I remember.) ...Show All

• Best Ordinary Man Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help I guess you are still using DOS to print. @x, y say........ command should be changed. Use this command to create your report file modify report Your_Report_File and this ...Show All

• knuckle05 Sending Email through Visual Foxpro

  Dear Sir, I want to send email through visual foxpro. please write me code to help me. Thanks & regards, - Ravi Awasthi You have many options.  Look at http://fox.wikis.com/wc.dll Wiki~AutomatedEmail http://fox.wikis.com/wc.dll Wiki~CdoEmail http://fox.wikis.com/wc.dll Wiki~SendMapiEmail for choices and sample code. Samples courtesy of Craig S. Boyd [MVP]: MAPI MS Outlook CDOSYS CDO NTS Windows Shell WinExec W3JMAIL BLAT ESSMTP   You can get the code and links to Craig Boyd's functions in this post  Connect to Outlook Express and Microsoft Outlook You can use  West Wind Intern ...Show All

• Chien Lim how can connect from asp.net to FoxPro Database

  hi I have asp.net (with C# ) program and i want connect to FoxPro Database but i dont know how can i do that . maybe Visual studio 2005 have Provider for it but can't find it . please help me thank you . Hi dear alex thank you , it works . dear CetinBasoz thank you for your help First download VFPOLEDB driver from http://msdn.microsoft.com/vfoxpro/ Then all you need is to use OleDb with VisualFoxpro driver. Here is a very simple sample that I posted before (assuming you have the sample data): <%@ Page Language="C#" AutoEventWireup="True" EnableViewState="False"%> <%@ Import N ...Show All

• Rickyman45 export file question

  Hi, I don't know how to export a dbf file to a text file with character fields without quotes. For example, I need that in the text file, fields appear like this: simon 150 manager robert 300 sales representative Thanks, COPY TO YourFile.TXT TYPE SDF Tamar There are 2 ways (at least). If you mean fixed format then as Tamar suggested: copy to filename.txt type sdf Second one is (only remove quotes but keep field delimiter): copy to filename.txt type delimited with "" or: copy to filename.txt type delimited with "" with tab && blank, character   ...Show All

• zennway Performance Issue with Rendering Method of VFP 9.0

  Hi All, I am using the reportlistener to preview my reports, this renders all the pages when the report is called and done once. this is taking lot of time if there are no of controls in it and pulling down the performance. is there any way to stop this rendering done in the beginning and customizing the rendering based on the customs events we have. i want to do this rendering page by page only when it is traversed and not at once. Kindly advice me. Thanks in Advance -Venkatram You do have the source for reportouput.app so if you need a different behavior you can certainly bring it about. My understanding is that the entire report is rendered up front so that "page next" in preview wil ...Show All

• S.T.A.R.S. Copying from one sheet to another within the same book

  I am creating a workbook for a local company using excel. I've got most of the book worked out except that when information is input into the "main" sheet I need the same information - the entire row - copied over to another sheet within the same book depending on certain criteria. In other words, if the value in a column is 2 then copy the entire row to sheet 2, if it's 3 then copy to sheet 3, and so on. Is there a way I can accomplish this kind of automation I agree that recording a macro is a way to find out code to write. Unfotunately generally the macro Excel creates is ineffective and doesn't really reflect what you would do programmatically. Worse in cases like you describe it's even tri ...Show All

• Thomas S. Andersen Adding two reports togather

  Dear friends, I am having two reports how can I print them togather i:e print report 1 at the end of this report 1, continuing in the same page the next report report 2. thanks for ur help satish thanks Dannible, I have already tried "Nopageeject" this will only give us one spool output for the multiple reports but getting togather two reports in the same page otherwise we will say that just after the end of the first report it should continue the next in the same page. Anyhow thanks for ur help, incase if there is a solution please help me regards satish Hi Satish33 Try this: Scan Report Form report1 Next 1 ...Show All

• insaneolly Preventing key strokes to be passed to control

  Hi, I have a form that needs to read data from a bar code reader. The bar code reader connects to the keyboard plug and functions like a keyboard. So what I would like to do is to have the user click a "Barcode Read" button and then scan all the bar codes he needs to scan and then click a "Done" Button. I was going to intercept the barcode data in the forms "Keypress" event and store it in a table. Problem is that I have so far found no way to stop the keypress data to be passed to the current control. As each set of data is terminated by a CR each time a barcode is read you jump to the next control and when you get to one of the buttons <CR> just clicks that button. So what I need is to intercept the ...Show All

• bmaggi VFP9 ToolBox Behavior: 'oApp.oToolBar.myTextBox.Setfocus' and pMyVariable Issues ?

  (Dear Experts: Thanks in advance for any complete or partial responses) 1) oApp.oToolBar.myTextBox.Setfocus: ... I'm trying to .HideSelection of .Parent.cboMyDropList in the toolbar: i.e., hide the typing cursor (blinker): The HideSelection property doesn't seem to work in toolbar mode. 2) When "pMyVariable" is declared PUBLIC by oApp.oToolBar.myTextBox.doMyprg.prg, it doesn't seem to be read by myOtherForm.Activate: E.g. If type("pMyVariable")<>'L' myOtherForm.myOtherTextBox.setfocus Endif Number 1 and 2 (above) are self-resolved (I'll spare the details). Sorry for the confusion. ...Show All

• Will_M Rotation vfp helpfiles not working

  this code is copied straight from vfp 9.0 help files. i just added the two paramateres this code works in vfp and when i run just the application on the computer that has vfp installed. however it is not working on non vfp computers. on a non vfp computer all i see is a wait window that says rendering and its tallying up the pages. PARAMETERS REPNAME,ANGLE_OF_TILT LOCAL oListener oListener = CREATEOBJECT("rotateText") oListener.ListenerType = 1 REPORT FORM &REPNAME OBJECT oListener #define FRX_OBJCOD_PAGEHEADER 1 DEFINE CLASS rotateText AS ReportListener IsInPageHeader = .F. PROCEDURE Init() DECLARE integer GdipRotateWorldTransform In GDIPlus.Dll ; integer graphics,single angle,integer e ...Show All

• UmairKhan The publisher could not be verified. Are you sure you want to run this software?

  Everytime I start one of our customized apps. (written in Visual foxpro 5.0 and compiled as an .exe). I get the Open file - Security Warning. Thanks that did it I added my network path ( \\server\share ) to my trusted sites and set my security for intranet sites to low. IE7 and running from a UNC path http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=972945&SiteID=1&mode=1 Sounds like you started IE-7 with its curiosities; if so, google "IE-7 EXE Errors" for internet options" about your necessary MANUAL security settings (etc.) (under IE-7) (I reverted back to IE-6 on most of my computers and await the SP-1 due to this and other problems I've encountered ...Show All

• Luke Breuer Report listener, HTML output on a Win98 machine.

  Hi All; I've been using a report listener to produce an html file. On win98 machines the detail band of the erport it empty. On XP all is Okay. Anyone experienced this and knows if there is a solution (Aside from upgrading to XP) Thanks. Dan; Win98 SE it is. The actual HTML contains no data for the DETAIL BAND ONLY. The rest of the report is both generated AND rendered fine. Thanks. fn = "C:\krcuser\po"+ALLTRIM(po.pono) GO top loListener = .NULL. DO (_reportoutput) WITH 5, loListener lolistener.targetfilename = fn loListener.quietmode = .T. REPORT FORM po1 OBJECT loListener The result is an html file which has blank ...Show All