Report Preview Questions

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - returning cursor form a com object I want to create a com object with a method which will return a cursor. Is it possible to return a cursor from a com object. Thanks in advance Dave Tag: Report Preview Questions Tag: 199808
  - 2
    - _SCREEN.Caption and API SetWindowText Hello ! The following code does not work in VFP6 and Win98 After SetWindowText function call the _screen.Caption does not change Any suggestions please. Kuido PROCEDURE sedt LOCAL hwnd, pol,t1,t2 DECLARE INTEGER GetActiveWindow IN Win32API DECLARE INTEGER GetWindowText IN Win32API INTEGER hwnd, STRING @lpString, INTEGER cch DECLARE INTEGER SetWindowText IN Win32API INTEGER hWnd, STRING lpString DECLARE INTEGER GetLastError IN Win32API hwnd = GetActiveWindow() t1=SPACE(40) t2=LEN(t1) t2=GetWindowText(hwnd,@t1,t2) ? "Window Text:", LEFT(t1,t2) ? _screen.Caption pol="Uus tekst" t2=SetWindowText(hwnd,pol) IF t2 > 0 t1=SPACE(40) t2=LEN(t1) t2=GetWindowText(hwnd,@t1,t2) ? "Window Text after: ", LEFT(t1,t2) ? _screen.Caption ELSE ? "ERROR", GetLastError() ENDIF RETURN Tag: Report Preview Questions Tag: 199806
  - 3
    - VFP Web Base Problem Hi All, I have a huge VFPv6 application (use VFP local database) and want 20 users can concurrently execute it through Internet Explorer. Since I have no time and money to modify this application again, I search a quick method to solve this problem but not very sure can it work. Run this VFPv6 application under Linux server with Win4lin or VMWARE (I am not sure which one is best for VFP applciaton using native table) etc... Then I install VNC Server in this Linux Server. So, other people can CONCURRENTLY access the VFPv6 application through Internet Explorer (I know VNC support client use IE). Does anyone succeed in such above case ? Please give me some advice... I will not try Window Terminal Server becuase users can not access my application through IE. Citrix is a best solution but it is very very expensive!! Also, Active Document is 100% not suitable for me. Thanks Tag: Report Preview Questions Tag: 199805
  - 4
    - How to list all table name in database HI, all I have a large number of tables in my database, could you tell me how to list out all table's name in database either to printer or to text file. thanks a lot Tag: Report Preview Questions Tag: 199803
  - 5
    - ftp - recovery from failed data transfer I am using the wrapper for the wininet.dll detailed below occasionally the net will bomb when transferring quite large files is there a way to set the the process to recover from a previous failure - and continue with the partially sent file - when trying to send the file a second time? Thanks John Davy ********************************************************** * FTP Services for Visual Foxpro 5.0+ * * Written by: Robert Abram * * Date: Sept 1998 * * * * Revision 1.1a * * * * wininet.dll needs to be in the windows/system * * directory. * * * * Updated 3/16/99 - Changed Date Usage to comply with * * Strict Date handling. * * * * Added 3/16/99 Functions - AutoDialInternet * * AutoDialHangUp * * DialInternet * * DialHangUp * * GetConnectedState * * GoOnline * ********************************************************** Tag: Report Preview Questions Tag: 199802
  - 6
    - XML Hi, I am trying some XML for 1st time a client wants me to connect to their site with XML I am using vfp8 sp1 When using their sample file, I get the following error XML Parse error: Invalid at the top level of the document. Line 1, Position 1. <file name> I get this using either XML adapter or XmlToCursor The 1st line of the document is: <katabat xmlns="http://katabat.com/webservices/pipeline/PipelineImport_v2.0.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> can anybody give me hints as to what I am doing wrong ? al Tag: Report Preview Questions Tag: 199781
  - 7
    - Printing compress Hello ! I have an old fox program running in DOS. By any chance any of you gentleman know the HP DeskJet code to send to the DeskJet printer so it will compress the font. The default font in the printer is too big for the reports and I need to reduce the size of it The app was always run inside of my office where I was able to adjust manually the laser printer font size but the DeskJet printer doesn't have any way to do it. Please help ! Tag: Report Preview Questions Tag: 199776
  - 8
    - Windows XP Logo Requirements Hello All: I am in the process of attempting to get an application certified. I have read over the Windows XP Logo Requirements and was wondering where a VFP database should be stored. Currently we are storing the database in "Program Files\[Company Name]\[Program Name]" Is this correct or should it be moved to the "All Users\Application Data\[Company Name]\[Program Name]" folder. From what I gather from reading the Requirements NOTHING DBF wise should be written to the Program Files folder. And EVERYTHING DBF wise should be written to the Application Data folder. Thanks for your time. Anthony Tag: Report Preview Questions Tag: 199775
  - 9
    - RUN MY FORM AS UNIQUE WINDOW I'm making one executable but my form is not running as a unique window, how can I make the window of my form unique, I mean, I don't want to run my form as a child window of the main window. below is the code of my main program that starts the application; set talk off SET SAFETY OFF set status bar off _Screen.Caption="ENERGETICOS AMBIENTALES" do form proy3form.scx SET SYSMENU off read events Tag: Report Preview Questions Tag: 199772
  - 10
    - FoxPro interpretation of SQL Statement Can someone help me translate the following query into something understood by FoxPro. This query runs successfully in Access and SQL Server but FoxPro does not seem to interpret it. I am trying to return a list of the all customers and their last order. SELECT Customers.CustomerID, (SELECT TOP 1 OrderID FROM Orders WHERE Orders.CustomerID=Customers.CustomerID ORDER BY DateOfOrder DESC) AS LastOrderID FROM Customers Thanks, Andrew. andrewhc@ihug.co.nz.NoSpam Tag: Report Preview Questions Tag: 199769
  - 11
    - How can I get VFP9 controls'hWnd? Hello,everyone! I have been troubled in getting the hWnd property of Visual Foxpro native visual controls by Windows APIs such as CommandButton,Listbox,Combobox,Shape ,etc. for several weeks,I can't get what I want ! And,it's sad for me thant I even can't spy the handle of Visula Foxpro controls by running Microsoft Spy++,the Visual Foxpro controls don't be spied,I wonder how they were created and how they were controled without handle. Who can save me? I'll be very appreciated for your answer! Tag: Report Preview Questions Tag: 199755
  - 12
    - Open database shared in VFP8/SP1 Hi all! I have two VFP-projects simultaneous runing. They both use the same databas baptized PU.DBC This has worked fine in VFP7 but problems occurs with the same code in VFP8. When programatically opening the database with OPEN SHARED for the second time in VFP-project#2 VFP complains "Fileaccess is denied" as if it was open exclusive in the VFP-project#1. * Testing in the command-window CLOSE TABLES ALL CLOSE DATABASES ALL wait 'Current database is' + DBC() window && returns an empty string ("") OPEN DATABASE PU SHARED wait 'Current database is' + DBC() window && returns a string ("C:\Esdab\Data\PU") llExcl = ISEXCLUSIVE('pu',2) && returns .T. why????????? What is the explanation for ISEXCLUSIVE() to return .T. in the code above? The answer can probably explain why it isn´t possible to reopen the database a second time in VFP-project#2. Any hint would be very appreciated. Regards Christina Tag: Report Preview Questions Tag: 199754
  - 13
    - Using 3rd party OCX containing various objects I am trying to use a 3rd party active component, called DICOMObjects made by http://www.medicalconnections.co.uk. The sad truth is that they don't provide sample codes or applications for VFP when other languages like VB, Delphi, VC are supported. Unlike ActiveX controls that can be dragged and dropped on the forms, these components consist of objects that can be included as a part of the programming codes. In Visual Basic, it had "Component" menu under "Project" tab where you can add ocx files to the project. Once added, all the objects defined by DICOMOBJECTS.OCX became available. Does Visual Foxpro allow me to do something like this as well? Thanks for your help in advance Jason Tag: Report Preview Questions Tag: 199752
  - 14
    - URGENT: FoxPro COM Object Please Please Please. I am in time crunch and need to have fast access to a FoxPro database (*.dbc file). Thru VB, I tried using both OLE-DB and ODBC drivers for fox pro to insert/update data in that database. However, there are certain code in the foxpro triggers and field validation rules that are not supported under ODBC or OLE-DB. So my app fails. Up until now I have been editing the stored procedures in foxpro to comment out the incompatible code that causes the problem. But I can no longer do that. The 3rd party app which has the foxpro DB has been updated in such a way that changing the stored procedures codes will break the 3rd party app, which is not an option anymore. Someone suggested creating a very simple 1 method COM object using foxpro. Thet single method will take a string as input and return a ADO25.Recordset object. The method will exeucte ANY sql passed to it after connecting to the DBC file. Since the method is written in foxpro it should have no problems with the stored procedures within the DBC. Is this possible?? Please help me write this COM object. I have no idea what to do or how to begin. Please keep in mind that this COM object must not have any GUI, since its has to run in ASP, ASP.NET as well as VB.NET console app as a batch. Tag: Report Preview Questions Tag: 199746
  - 15
    - HOW TO CHANGE THE TITLE BAR AND THE ICON IN THE MAIN WINDOW? I would like to change the title bar and the icon of the main window of my application I'm using VFP 6.0 Tag: Report Preview Questions Tag: 199739
  - 16
    - How to make an application to be minimized in taskbar tray? I have checked the Help, but I can't find any information about how to write the code, or make any property settings that can make the application that can be minimized to the taskbar tray. Does anyone know how to achieve it? Tag: Report Preview Questions Tag: 199738
  - 17
    - HOW TO HIDE THE SYSTEM TOOLBAR It's lloks like the system toolbar is always on, is there any way to hide it? Tag: Report Preview Questions Tag: 199737
  - 18
    - Index problems I have one customer that is getting the following error Index does not match the table. Delete the index file and re-create the index She has gotten it 3 times in the past 2 days, each time I have deleted the index and re-created. Each time after that the program runs fine, (for a while). The line of code that it errors on is an UPDATE SQL statement. This is run on a table with buffering set to 5. I only have one site with this problem and I cannot reproduce it. What could be causing this????? HELP!!!!!! -- Altman VFP8 SP1 Forward this to everyone on your email list and Bill Gates will Magically Pop Out of your computer and hand you a check for $500 per person you sent it to, and he will also mail a check to a starving Ethiopian in China with Brain Cancer. Tag: Report Preview Questions Tag: 199715
  - 19
    - save report into word doc or excel xls and send with outlook express as attachment Hi, I wish to : - save REPORT FORM output to word doc or Excel xls file - send to Outlook Express as attachment plz advise. TQ Regards Hoe Tag: Report Preview Questions Tag: 199714
  - 20
    - Report forms in a compiled .exe Can someone tell me exactly how a report form acts when in a compiled exe? When I change the actual form and resend it to the user, I also have to send a recompiled .exe to them for the changes to take affect. Can I have it so it is only one or the other? Thanks, Scott Tag: Report Preview Questions Tag: 199712
  - 21
    - Tool tip text Hello, I don't use tool tip text very often and now I have to use it on a textbox but I'd like to show the tooltiptext under certain condition. Is there a way to implement the following conditino to the tooltiptext? iif(this_condition, " display this ", "display that") Thanks for any direction. I am using VFP8 SP1. P.S. I read from previous threads there's a free tool "FancyToolTip" available on UT, can someone kindly tell me how to locate it? (Instead of providing me a link to the tool, I would appreciate it if someone could explain me the usual way to search for a certain tool). Thanks again. -- jw Tag: Report Preview Questions Tag: 199704
  - 22
    - XBRL and Foxpro How can I use the XBRL format to import data into Foxpro (8.0/9.0)? Tag: Report Preview Questions Tag: 199699
  - 23
    - Any VFP ActiveX that looks like icon bar in Outlook Express? Hello, Is there any Icon Bar Activex for VFP that looks like the Icon bar in Outlook Express or Explorer? Thanks Zoom Tag: Report Preview Questions Tag: 199674
  - 24
    - A 800 * 550 report doesn't work under Win 2000 Hi VFP Gurus: What Should I do in order to get to work my older reports which I designed with VFP 6 under Win 98, I use to set custom size paper to 800 * 550, and the job wad done fine. Now I use VFP 8 under WinXP or W2K and suddenly, all my reports eject the entire page so the cashier has to form feed the paper and get it back on line When using Win98 and custom size paper, this did not happen, the receipt stopped after the print, the cashier just cut it off and all fine, no eject, no form feeds, no pressing any buttons on the printer now, they do.. What should I consider regarding custom size receipt under Windows 2000? Please Help me. Yeah, I have poor English; this is not my native language. Greeting from Nicaragua. Tag: Report Preview Questions Tag: 199653
  - 25
    - How to calculate balance in the query (like the one in the bank account statement)? Hello all, I am creating a form that shows the debt, credit, and balance column (similar to that of appear in the bank account statement). While I can easily retrieve the debt and credit column, I don't have any choice but to SCAN-ENDSCAN the cursor to calculate the balance column. The code is something like this: lnBalance = 0 SELECT tmpCurAccount SCAN lnBalance = lnBalance + debt - credit REPLACE balance WITH lnBalance ENDSCAN Actually, I don't mind do that. The cursor is relatively small, and the no performance hits at all, but since the cursor tmpCurAccount was send from MS SQL Server thru an SPT, I wonder if there is any way that I could include the balance calculation in the query (or is it better/faster to let VFP do this by herself instead of ask MSSQL Server to do that)? Looking forward to hearing from you! :) TIA, Willianto Tag: Report Preview Questions Tag: 199641
- Next
  - 1
    - FileSystemObject Why can't I create it using Createobject() in a XP machine? (429 ActiveX component can't create object) How do I install the filesystemobject? In what versions of windows does it come by default? is there a MSI to install it? Tag: Report Preview Questions Tag: 199640
  - 2
    - minimum config for run exe application built by visual foxpro0.8 hi sir, please i want to know the minimum configuration for run exe application on pc dosen't setup on it visual foxpro0.8. just setup by installshield and run exe file Tag: Report Preview Questions Tag: 199631
  - 3
    - Handling more than 2 GB in a table. Hi all, I want to download a table from the SQL Server to VFP 8 using SQLEXEC(). when I download some tabels I'm getting the error "File C:\Document and setting\Admin~1\Locals~1\temp\f0W4002v.tmp is too large. " This is because the file I'm downloading is greater then 2 GB in size. As I got to know VFP can handle tables only upto 2 GB. Is there a way I can overcome this. Nadee. Tag: Report Preview Questions Tag: 199610
  - 4
    - How to set EXCEL HPageBreaks from VFP I am moving some codes from VB to VFP. I have few problems. in VB these codes worked. ZxlRange = Chr(ZxlCol + 64 + 4) & LTrim(Str(ZxlRow + j)) xlSheet.HPageBreaks.Add(xlSheet.Range(ZxlRange)) but in VFP ZxlRange = Chr(ZxlCol + 64 + 4) + Ltrim(Str(ZxlRow + j)) xlApp.HPageBreaks.Add(xlApp.Range(ZxlRange)) It shows HPageBreaks is not an object. any one knows how to midify this line in VFP? THANKS Another problem in VB this works xlBook.ActiveSheet.PageSetup.CenterHeader = "&""Times New Roman,Standart""&16&ETHIS IS PAGE TITLE" But in VFP shown "syntext error", I have to cut some code out and it works. xlApp.ActiveSheet.PageSetup.CenterHeader = "&16&ETHIS IS PAGE TITLE" Thanks for the help! Tag: Report Preview Questions Tag: 199607
  - 5
    - Is there a way to automate the Windows fax printer? Or do I have to buy Winfax? Tag: Report Preview Questions Tag: 199595
  - 6
    - Project manager doesn't keep track of changed files I upgraded an FPW project to VFP8. I have to manually delete the fxp's when changing the prg's, because the project manager isn't paying attention to the fact that I changed them. I completely threw away the project file and built a new one from scratch, yet the problem persists. I opened the project as a dbf and cleared all the time stamps and object code. The problem persists. Code pages have been assigned, the project has been packed and rebuilt, yet whenever I change a prg (opening it from the project manager), the old fpx still gets called. The fxp's are in the same directory as the prg's. If I choose Compile from the Program menu, it works properly, but I shouldn't have to do that. Something needs to get set somewhere, but I don't know what. Any help? Tag: Report Preview Questions Tag: 199588
  - 7
    - putting SQL results in an array I'm doing an SQL select statement to an array from within a program. If I dimension the array before the select statement, then the statement only fills up the array to the size that the array was dimensioned. If I don't dimension the array, then the compiler gives me a warning. Is there any way I can either dimension the array first and have all results put in, or not get a compiler warning? Kevin Clark Seton Home Study School Tag: Report Preview Questions Tag: 199577
  - 8
    - ADO error I am trying to use ADO in foxpro to pass parameters to sql server and I keep getting following error: OLE IDispatch exception code 0 from ADODB.Parameter: Application uses a value of the wrong type for the current operation... I am passing in characters and the stored procedure is suppose to be accepting characters. I do I debug this? thanks Nick Tag: Report Preview Questions Tag: 199573
  - 9
    - GPS Q. If I know the LAT./LONG., how in VFP can I see where that is or a site that has this kind of interface? N 34º 46.118' W 82º 18.399'' J Morningstar Tag: Report Preview Questions Tag: 199572
  - 10
    - disable appear path of load tables at status bar hello sir, i want to disable charachter appear the path of loaded tables in form at status bar as \\cairo\app\fox_app\drdbf\paymst.dbf that appear at status bar when load form Tag: Report Preview Questions Tag: 199560
  - 11
    - inconsistant grid behavour Hi, I have a grid with 3 columns (code,description,group) and a producttable with 3 ordertags (code,description,group). when the user clicks on one of the headers the similar named order is selected. So when the user clicks on the first header (code) the order is changed to the code. when the user press the tabkey the same behaviour is performed. the weird thing is that the activerow and the current recordno. somehow doesn't behave the same when the activerow is 1 and when the activerow is somewhere below row 1. When the activerow is 1, the grid behaves like it should be : the currentrecord and the activerow stays the same and the order is altered upon the usersactions and the grid refresh well : I mean the record and the activerow stay the same and the rest changes upon the order that is selected. So it's very easy for the user to look up some code. but when the activerow is somewhere else, the records moves around whitout any clue. the record in the activerow changes when the order is changed ! and this is very confusing for the user. for example when he search in the table a portion of a produktkode, and then changes the order to description to go on search in this order, the record in the activerow changes to something he wasn't looking for. So my question is does somebody know how to get a fixed recordno in the activerow even when the tableorder is changed. Thanks in advance christophe Tag: Report Preview Questions Tag: 199559
  - 12
    - [ot] Aesop Fables it had a lot of stories about foxes.. :) -- .~. Might, Courage, Vision. / v \ /( _ )\ Linux 2.4.27 ^ ^ 7:26pm up 3 days 13:17 load average: 1.00 1.00 1.04 Tag: Report Preview Questions Tag: 199558
  - 13
    - VFP 6 App listening for messages Any ideas of how to go about getting a VFP 6 app listening for (and sending) messages from/to network machines in some way? Ie, how to have a separate thread of some description running in the app listening on Port XXXX for a message, that sort of thing. Pointers to any VFP friendly components (preferably with .net equivalents) to do this appreciated! Tag: Report Preview Questions Tag: 199549
  - 14
    - Sending e-mail Hi All, I have submitted a "wish" to Microsoft regarding an upgrade to MAPI or the ability to incorporate e-mail into our (developers) products. Below is a copy of my submission. Please add weight to this by making your own submissions at http://register.microsoft.com/mswish/suggestion.asp. Judging by the comments "out there" this has been a problem area for many developers. Rgds Jan __________ Comments submitted to wish list It has been some six years since the last update to the MAPI activex controls. Since then e-mail has become a major part of business. Many developers provide some means of automation to lodge business documents (quotes, orders, statements, purchase orders, job authorisations and so on). The tools available to developers have progressed over time in a disparate fashion, with little or no coherence across platforms. These tools include:- MAPI, SIMPLE MAPI, CDO 1.0 though 1.21, CDO for windows 2000, CDO for exchange server .... Whilst there are many third party solutions available, these solutions, in the main, tend to be "tunnelled" to the product developers needs. What is needed is a coherent mechanism with intelligible documentation that does not require excessive effort to implement and provides the following basic features:- - allow e-mail to be sent on any platform without specific coding for any particular platform ie it should work the same on exchange server as outlook express - cater for all aspects of e-mail from simple text messages to html documents to documents with embedded attachments such a logo graphics. - It should also accommodate e-mail enabled programs through the implementation of technologies such as XML The documentation should at a minimum include a functional overview of each feature and all its properties, events and methods that is not specific to any development language, accompanied by walk throughs for all developer tools (including VFP) that demonstrate the full use of this facility. The documentation should also fully cover the implementation of this facility such that developers can cater for aspects of the various platforms easily eg new security features that may prevent their applications from malfunctioning. Tag: Report Preview Questions Tag: 199540
  - 15
    - Grid colour problem Hello, i've tried everything before putting this question here: I have form, and grid with some data on it. now, i would like to browse through the data on grid but with curent line in the grid of different colour than the others.. (to be more precise background colour and font colur of line) my english sux i know.. thanx in advance.. Tag: Report Preview Questions Tag: 199533
  - 16
    - function to detect that app is running Is there a function to detect that app is running? Or not running? Thanks, Josh Tag: Report Preview Questions Tag: 199528
  - 17
    - Debugging .app file I have created two application (.exe) and (.app). 1. I want to call one of the form in .app from the exe? 2. How to debug the application file(.app) from the executable file(.exe). Tag: Report Preview Questions Tag: 199524
  - 18
    - Excluding a FXP file from build I have a program where I want to make some custom code but only in small parts so I created a FoxPro compiled program and excluded it from the build. Then I will send this file with the executable and it will be different for every person. I am having the problem though, that foxpro is trying to include it in the build. I have a line in one of my forms to say SET PROCEDURE TO '.\progs\Custom.fxp' And this causes FoxPro to include it into the exe even though I have it marked as excluded. This has worked before but it all of a sudden started including the file, how can I get it to not include it??? -- Altman VFP8 SP1 Forward this to everyone on your email list and Bill Gates will Magically Pop Out of your computer and hand you a check for $500 per person you sent it to, and he will also mail a check to a starving Ethiopian in China with Brain Cancer. Tag: Report Preview Questions Tag: 199519
  - 19
    - US National, Federal and/or State holidays Anyone know a source for this data? -Lew Tag: Report Preview Questions Tag: 199509
  - 20
    - VFP Command Window The only way I can get the command window to be usable after SET STEP ON is to close it, then re-open it from the menu or Ctrl+F2 Tag: Report Preview Questions Tag: 199502
  - 21
    - VFP 6 and Multi Language Support I tried, as was suggested earlier, starting VFP 6 with the "-a" commandline option. I still regularly get no visible text when I type in the command window. Any other suggestions? The problems started when I added support for a second language, in this case Hebrew, to my XP/Pro machine. -S- Tag: Report Preview Questions Tag: 199497
  - 22
    - Textbox covered by label caption I've inherited a project that was developed with a combination of font sizes, screen resolutions and windows settings that throws everything off in my dev environ. EG labels & captions are either cut off by textboxes and other controls so that I can't read them, or partially block them out. How do I discover what these settings were so I can duplicate them in order to tame this beast and make them more flexible? -Lew Tag: Report Preview Questions Tag: 199496
  - 23
    - [ot] is copyright democratic? -- .~. Might, Courage, Vision. / v \ /( _ )\ Linux 2.4.27 ^ ^ 7:15pm up 2 days 13:06 load average: 1.02 1.01 1.00 Tag: Report Preview Questions Tag: 199492
  - 24
    - INSERT...UPDATE.. (variable) handling Hi, I always wanted to know why in the case of INSERT the folowing example works and in the case of UPDATE it does not. Suppose you have a table called Names having columns Name, LastName, Code In my form: ThisForm.AddProperty("oRecord", "") Scatter Name oRecord The folowing works ThisForm.oRecord.Name="Demetrios" ThisForm.oRecord.LastName="Panayotakopoulos" INSERT works: Insert Into Names (Name, LastName) values (ThisForm.oRecord.Name, ThisForm.oRecord.LastName) UPDATE does not work: Assume ThisForm.oRecord.Code=1 Update Names Set Name=ThisForm.oRecord.Name, LastName=ThisForm.oRecord.LastName where Code=ThisForm.oRecord.Code but the folowing does, though it uses ThisForm.oRecord.Code m.Name=ThisForm.oRecord.Name m.LastName=ThisForm.oRecord.LastName Update Names Set Name=m.Name, LastName=m.LastName where Code=ThisForm.oRecord.Code Why in the case of INSERT ThisForm.oRecord is recognized and in the cas of UPDATE is not fully recognized? Demetrios, Greece Tag: Report Preview Questions Tag: 199479
  - 25
    - Need help with Regular expressions Hi, I'm looking for a way to use regular expressions in a .prg to match and then extract a portion of a field. I've been through the docs and have a rough idea how to construct a pattern (emphasis on rough), but do not know how to invoke regular expressions from within a program nor return a match - I can only test and get back a T/F response. For my pattern I got as far as the following: loRegExp.pattern = "# ?(/?\D|[0-9]{0,3})" The pattern I am looking for: - Begins with # - May or may not follow with a space - Followed by at least 1 digit - Contains either a / followed by one digit _OR_ up to 3 more digits Some things I'd like to add to the pattern, but can't figure out how to, are: - Exclude strings that contain a digit(s) followed by a dash followed by another digit(s) i.e. #2-4 or #50-100 etc. - Include decimal values like #1.5, #22.8, #500.5 (up to 3 digits, a decimal, and followed by only a single digit) This may be best illustrated with sample data: Acceptable (and returning .T. with current pattern): #1 (Optional space after the # is ok) #12 (Optional space after the # is ok) #123 (Optional space after the # is ok) #1234 (Optional space after the # is ok) #1/2 (Optional space after the # is ok) # 1/2 ...etc #2.5 (Would like this to pass, but don't know how - xxx.x) Unacceptable (but still returning .T. with my current pattern) #1/345 #45/1 #22.44 #11-12 I only want to accept fractions when both the numerator and denominator are single digits i.e. 1/2, 1/4, 3/4 etc. Not sure where I went wrong, but hey, I'm a newbie at regex. Lastly, once I match a portion of a string, how can I return the matched part? Is there a way to use RegEx patterns in a SubStr() function? Thanks! Jim Tag: Report Preview Questions Tag: 199469

1) I have a client who would like to right click on the report preview and
send output as an attachment in email. They have this functionality in an
Access program. Ideas/suggestions??

2) Also in the print preview is it possible to print just one page (current
page)?

Thank you much for your input
Gar

Re: Report Preview Questions by Hans

Hans
Mon Sep 13 09:09:46 CDT 2004

- You can print the report to a PDF file, using a PDF printer (Try Google:
PDF printer). You can send the PDF along with the e-mail.

- Try the command: REPORT FORM MyReport.frx TO PRINTER PROMPT. The PROMPT
clause adds a print button to the toolbar, through wchich you get access to
the printer dialog where you can specify a range to print.

Hans

"Gar" <Gar@discussions.microsoft.com> schreef in bericht
news:D4F0A2B8-C78C-4BB8-9431-2AEA171BB56E@microsoft.com...
> 1) I have a client who would like to right click on the report preview and
> send output as an attachment in email. They have this functionality in an
> Access program. Ideas/suggestions??
>
> 2) Also in the print preview is it possible to print just one page
(current
> page)?
>
> Thank you much for your input
> Gar

Re: Report Preview Questions by Eric

Eric
Mon Sep 13 09:23:28 CDT 2004

Hello, Gar!

The VFP9 report engine allows us to do many cool things that can't be done
easily in earlier versions. You can download a beta release from the vfp web
site at http://msdn.microsoft.com/vfoxpro.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

RE: Report Preview Questions by MTchary

MTchary
Wed Dec 22 12:47:03 CST 2004

Gar
FRX2Any ( www.frx2any.com ) has Advanced Report Viewer that does everything
you are asking for and even more.

"Gar" wrote:

> 1) I have a client who would like to right click on the report preview and
> send output as an attachment in email. They have this functionality in an
> Access program. Ideas/suggestions??
>
> 2) Also in the print preview is it possible to print just one page (current
> page)?
>
> Thank you much for your input
> Gar