VFP9 Multiple table Report Question

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
    - Ole error code 0x80020006 - Unknown Name Hi All, I seem to be getting an OLE error, the error code is 0x80020006 and the error message is "Unknown name". I have added an Activex Control (of type "Shockwave Flash Object") to one of the pages in the pageframe control of my form The error ocuurs when the url property of the ole control is set. dirname = "C:\Proj\" filepath = dirname + "Showtime\Demo.swf" this.oleAlAreen.url=filepath If anybody knows how to fix this error, please reply ASAP. Thanks. kd Tag: VFP9 Multiple table Report Question Tag: 211236
  - 2
    - Cursor Adaptor and Stored Procedures with Output parameters I want to call a SQLserver SP that has both input and output parameters with a cursor adaptor, how do I write the selectCmd? VFP8 thanks LH Tag: VFP9 Multiple table Report Question Tag: 211231
  - 3
    - Locating "My Documents" folder Hi to all, I'm trying to locate the current "My Documents" folder programmatically to point the default directory when I call PUTFILE() function. How can I do this? I've tried GETENV() but it doesn't give me the "My Documents" folder... Any help would be much appreciated... Thanks. Allan Tag: VFP9 Multiple table Report Question Tag: 211222
  - 4
    - dumb question I have a form that I add a slider to through form designer (VFP 9). For some reason the activex control will not become visible until I click on it. If I put the activex control on a blank form I don't have any problems with it. I've tried hardcoding the activex object in the load of the event, creating it with the drag and drop feature in form designer. The property visible is set to .t. and it is the topmost control of the form. Once the control is clicked on it stays visible and works properly but I am stumped on this one. Thanks for any help Tag: VFP9 Multiple table Report Question Tag: 211221
  - 5
    - Automating Excel Chart Creation from Microsoft FoxPro In an Excel workbook, I have a long macro in VBE that creates a chart and sets properties of axes, series collections, etc. I want to automate the process from within FoxPro. I copied the VBE code into FoxPro and much of it works but not all. What do I need to know about getting the VBE code to work from within FoxPro? Any help will be gratefully received. Thanks. Peter Tag: VFP9 Multiple table Report Question Tag: 211218
  - 6
    - Excel and Word as attachments hello, i have built an app to create word and excel file after user intervention. if i just print these doc's all is fine. once i select them to e-mail, the excel sheets seem to loose formatting of Font size and merged cells go away. with word, the reciever of the Mail will see the icon of the attachment with titla and all, double click and nothing appears, however if they print it, its all there. very strange things are going on. it varies from computer to computer. is there any way to set formatting of this so they wont get crushed or any other ideas? TOm Tag: VFP9 Multiple table Report Question Tag: 211217
  - 7
    - Doug Hennig at LA Fox May 10 -- Mine for Code in XSource Mine for Code in XSource Visual FoxPro comes with source code for most of the "Xbase" tools that ship with the product, including the Class Browser, Code References, Toolbox, and Task Pane. Looking at source code written by top VFP gurus often gives insight into new, powerful coding techniques. This session looks at various files in XSource to show you cool ideas you can incorporate and even better, code you can directly use in your applications today. Jump Start Topic: Update your application over the Internet using Inno Setup -- Michael Cummings Inno Setup compiler is a FREE setup creation utility. It is actually easy to use and powerful too. We will look at a few lines of FoxPro code that will make your application do a version check on startup, and prompt the users to install a new version. We will then look at even *fewer* lines of code that will download and install the latest version of your application using Inno Setup. The really cool part is that you can launch your Setup program from within your application, so the upgrade is seamless to your users. This is not only cool, it is very easy to do. See you at LA Fox!! http://www.lafox.org Tag: VFP9 Multiple table Report Question Tag: 211212
  - 8
    - How to get VFP 9.0 in french from Canada Could somebody tell me if there is a way to get VFP in french from Canada? Also, could somebody tell me if i will be able to develop complete french version with the VFP english version? Daniel Massé Tag: VFP9 Multiple table Report Question Tag: 211208
  - 9
    - vfp8 parameters and variable question hi all. i am new to foxpro programming. I am not sure that this is the best place for my question but i am not able to find "working" newsgroup and/or forum about foxpro (btw, any hint appreciated) . my problem: I have a form defined procedure and would like to call it and receive 2 parameters back. i tried with: thisform.myproc(parm1,parm2) but it does not work (i read that in this way the parameter are passed by value and not by ref...) so i tried with DO thisform.myproc WITH (parm1),(parm2) ... but it does not work...myproc is not recognised (even without thisform.) so what can i do??? i tried with global variables and it worked but i do not want to use global variable for this kind of stuff...but...it is not possible to define the variable scope for the form? only for the procedure itself or global seem to be the possibilities... if somebody knows other resources for my problem, plese let me know. thanks and ciao. Tag: VFP9 Multiple table Report Question Tag: 211195
  - 10
    - - How do I make shape object semitransparent? Is there a way to make Shape object semitransparent (transparency factor)? If not, could someone suggest an alternative. Tag: VFP9 Multiple table Report Question Tag: 211194
  - 11
    - Formsets in Foxpro I am using Formset in an application .. but every form I open sets its size to the Form open previously .. How can I Stop this to happen. Tag: VFP9 Multiple table Report Question Tag: 211193
  - 12
    - check if drive exist Hi, I have this little code to check if a drive exist yes or no, but it fails on a pentablet. I get an error specifying "Drives does not exist". This pentablet has a drive (the server) only when it is docked (and connected to a lan). And this is just exactly what I want to prevent and checked if it is docked or not to perform some syncronisation with tables on the server. function checkdrive lparameters chkdrive_ o = Create('Scripting.FileSystemObject') lreturnvalue = o.Drives(chkdrive_).IsReady release o return lreturnvalue Anybody a workaround to check when a drive exist (and is ready) ? thanks in advance regards christophe -- Tag: VFP9 Multiple table Report Question Tag: 211184
  - 13
    - VFP 9 Installshield question Hi, I am using VFP9. Which minimum Objects/Merge Modules do I need to include in my application distribution? Is it OK if I use the VFP8 Installshield wizard? Thanks in advance. Regards, Derek Tag: VFP9 Multiple table Report Question Tag: 211183
  - 14
    - VFP 9 Have a grid with a check box on a logical field. How can I update the grid programatically to clear the check box. i.e. check ten items perform something on just these ten items and then clear the checkbox I have tried thisform.grid1.column1.checkbox.value=0 it does update the underlying cursor if i interupt the program at this line the records referenced have had the logical field set to false. But as soon as my grid displays again, the check boxes are checked and the underlying cursor once again have the logical field set to true. Thanks for any assistance. Tag: VFP9 Multiple table Report Question Tag: 211180
  - 15
    - Displaying Two Browse Windows on Same Screen in Foxpro 2.6 Dos ? How can I show Two browse windows of different tables at the same time, I tried following. Define window win1 from 1,1 to 20,39 Define window win2 from 1,40 to 20,70 Activate window win1 Use Rent brow in Window win1 Activate window win2 Use Contract brow in Window win2 But I only see one brow window at a time, where am I mistaken, please help ? Best Regards, Luqman Tag: VFP9 Multiple table Report Question Tag: 211175
  - 16
    - Treeview and System ImageList Is it posible to associate the system image list with a treeview control? I've been playing with Shell_GetImageLists but no luck so far. Tag: VFP9 Multiple table Report Question Tag: 211165
  - 17
    - Treeview and System ImageList Is it posible to associate the system image list with a treeview control? I've been playing with Shell_GetImageLists but no luck so far. Tag: VFP9 Multiple table Report Question Tag: 211164
  - 18
    - System Image List Is it possible to associate the System Image list with a Treview Control in VFP? I've been playing around with Shell_GetImageLists, but no luck so far. Tag: VFP9 Multiple table Report Question Tag: 211163
  - 19
    - Events at Run time Dear sirs I've created in my Form some objects (Buttons) at run time, the question is: how can I handle their events (Like: Click Event) at run time best regards thanks Mohammed Abdel-Razzak Tag: VFP9 Multiple table Report Question Tag: 211161
  - 20
    - Problem with ADO.Net Using VB.net with .Net Framework 1.1 and using Fox Pro OLEDB to connect to a fox pro database. When I try to load a dataset from a FoxPro database on the network running this line of code for path (\\servername\share\data\abc.dbc) dbAdapter.Fill(dbDs) I get: "The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value." This code works perfectly on the local copy of the FoxPro Database (example c:\data\abc.dbc) any idea why? The people in dotnet.framework.adonet suggested I post here. Tag: VFP9 Multiple table Report Question Tag: 211159
  - 21
    - More VFP7 to VFP9 woes I use the below code to create a background image on a Foxpro app. This image is always visible in my test environment, but when I run it on Terminal Services (W2K) in Production, several of my forms clear this image. What Commands/Functions could possibly clear this image?? This never happened with the app when it was compiled with VFP7. Thanks for your help *! Example Code ------- _SCREEN.addobject('logo','image') WITH _SCREEN.logo .picture = 'BackGroundImage.jpg' .width = 220 .height = 160 .backstyle = 1 ENDWITH = updscreen() _SCREEN.logo.Visible = .T. *------------------ PROCEDURE updscreen *------------------ WITH _SCREEN.logo .left = (_SCREEN.width-220)/2 .top = (_SCREEN.height-160)/2 ENDWITH ENDPROC Tag: VFP9 Multiple table Report Question Tag: 211155
  - 22
    - VFP Based PM (preventative MTC) program for oilfield industry Does anyone have any first hand experience or recommendation for a program that would be used in the oilfield or gas industry for tracking and managing maintenance on field equipment? Dan Tag: VFP9 Multiple table Report Question Tag: 211152
  - 23
    - Strange issue importing text file I am a SQL Server DBA that has a client using FoxPro v8. When the client imports CSV text with character fields delimited with double-quotes, they have random records shift from time to time for no apparent reason. The source records are clean meaning they do not contain commas or double-quotes. Ironically, the same CSV text file imports into SQL Server, ACCESS and other databases without any issues. Has anyone else run into this type of strangeness? How did you resolve it? Thanks! Tag: VFP9 Multiple table Report Question Tag: 211150
  - 24
    - SQL SELECT is not executing VFP 8 SP1 on XP Pro SP1 This is the most bizarre thing I've seen in a long time. I had some code in a form that constructed a SQL SELECT statement as a string, then runs the command via macro substituion (&). This was working fine. I decided to move this code into a class. Now, when the macro substitution line is executed, nothing happens. Here is the string that is supposed to be executed: SELECT Employee_name AS fld1, UPPER(Employee_name), Ssn AS fld2, UPPER(Ssn), Employee_id AS fld3, UPPER(Employee_id), Dob AS fld4, UPPER(Dob) INTO CURSOR rptCurs FROM empGrpCurs ORDER BY 2, 4, 6, 8 The source cursor (empGrpCurs) exists and contains data. After this instruction is executed (or not executed in this case), the destination cursor (rptCurs) does not exist and _TALLY has not been updated from the prior value. No error is raised. It's like this instruction never happened. I then placed the actual SQL SELECT statement (rather than the macro version) in this same method a few lines lower and the result was exactly the same - no error, no cursor created, _TALLY unchanged. I'm convinced I'm just missing something very obvious, but lack of sleep must be blinding me. Any ideas? -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: VFP9 Multiple table Report Question Tag: 211128
  - 25
    - VFP 9, Class definition is cyclical error Have a container-class which contains two custom-class pageframes, one is placed on the others page. inputctrl1 <or one of its members>. Parent : Error loading file - record number 1976. FWPAGEFRAME_B1 <or one of its members>. Parent : Cannot add FWPAGEFRAME_B1. Class definition is cyclical This error occurs when running the application, not during class editing. With only one instance of the pageframe class in the container-class the application runs fine. It also works if the second pageframe is not placed on the other pageframe's page. As far as I can tell this does not match: "You have attempted to specify a class in an ADD OBJECT statement whose class definition is the same as the class being defined. " Any idea's ? TIA Michael S. J. Tag: VFP9 Multiple table Report Question Tag: 211100
- Next
  - 1
    - Printing a BMP bitmap Hello all and thanks in advance for the help. How do you print a bitmap where the bitmap that you will be printing is to be decided at runtime? Can you use the VFP report writer? Is there another way? Thanks. Jeff Tag: VFP9 Multiple table Report Question Tag: 211093
  - 2
    - Convert 3.0 resource file format to 6.0 I have a VFP8 exe file which runs every night on two separeted Win2003 servers. One of them is OK. The other sometimes /not every time/ stops and there is the following question on the screen: Convert 3.0 resource file format to 6.0? /YES or NO/ Could anyone explain me why do I have this message? Many thanks -- Sandor Tag: VFP9 Multiple table Report Question Tag: 211090
  - 3
    - Frontpage Automation - Help I need to automate FrontPage to update a website i.e. to publish it. How does on do this from within VFP? Some Code Samples would be help Thanks in Advance Regards Mahmud Abdulla Tag: VFP9 Multiple table Report Question Tag: 211087
  - 4
    - dbf to excell Can I export a large dbf to excell to use multiple worksheets in excell. The file is to large for only 1 worksheet. thanks sherry Tag: VFP9 Multiple table Report Question Tag: 211085
  - 5
    - Consuming a dataset in a web service I have successfully consumed an XML from a web service from VFP8. Now I need to consume a dataset in a web service. Can someone point me in the right direction? I've been searching Microsoft site but nothing pops up. Thanks, Tag: VFP9 Multiple table Report Question Tag: 211079
  - 6
    - accessing VFP data for ASP.net pages We had (gone now) a developer who wanted to have access to our VFP tables (several hundred mb worth) for "live" queries on a low-traffic web site. His solution, doing all his development in ASP.net, was to create duplicate tables on an SQL server and import the VFP data on a schedule which allowed as up-to-date data for the queries as was possible (perhaps every 15 minutes, but no less than once an hour). I objected to this scheme as being inefficient in that it moved many thousands of times the amount of needed data across our various links (a shared 10 mb pipe to the web server was the bottleneck), when he could have accessed the data directly from ASP.net using OLEDB. His only point was that this allowed him to use SQL stored procedures. Can anyone give opinions on the pros and cons of these 2 approaches? Thanks. Tag: VFP9 Multiple table Report Question Tag: 211077
  - 7
    - How to dial a phone number from VFP? Hi All, Does anybody have a sample code for using a telephiony API from VFP? Where can I find the examples on how to implement auto-dialing from VFP application? Thanks, Andy Tag: VFP9 Multiple table Report Question Tag: 211073
  - 8
    - using controls in grid causes problem i am using combo1 that contain faculty,student,staff as combo1 items.... according to i choose the item in combo1 the grid is displayed..... i have insert checkbox1 and combo2 in the grid also...... the combo1 and the grid is in the same form.......initials the grid is set as visible false.... now when i run the form it shows the controls (checkbox1 and combo2) in the grid for frist selection but when i switch the selection in combo1 it does not shows the controls in the grid.......... i have tried thisform.grid.refresh thisform.grid.column1.refresh thisfrom.grid.column2.refresh thisform.grid.column1.checkbox1.refresh thisform.grid.column2.combo2.refresh can anybody help me...... -- Message posted via http://www.dbmonster.com Tag: VFP9 Multiple table Report Question Tag: 211069
  - 9
    - more on DIBAPI32 and Window Printing Hello and thanks for the response. I copied both the DLL and the LIB file into my development folder. It is now starting to work but... When I execute the code provided earlier the following happens: I am prompted for a printer. I then get a window which says "Printing..." and the window title "to" and the printer name "Sending bitmap to printer..." And there it sits with nothing actually getting sent to the printer The printer works fine. I printed a test page and a document but the bitmap never prints. The code I used is: !/N REGSVR32 /S DibApi32.Dll #DEFINE PW_WINDOW 1 #DEFINE PW_CLIENT 2 #DEFINE PW_BESTFIT 1 #DEFINE PW_STRETCHTOPAGE 2 #DEFINE PW_SCALE 3 DECLARE INTEGER PrintWindow IN DibApi32 AS PrintWin ; INTEGER HWnd, ; INTEGER fPrintArea, ; INTEGER fPrintOpt, ; INTEGER wxScale, ; INTEGER wyScale, ; STRING @ szJobName PrintWin(thisform.hwnd,1,1,0,0,ALLTRIM(thisform.caption)) Does anyone know what the problem is? Thanks, Jeff Tag: VFP9 Multiple table Report Question Tag: 211068
  - 10
    - gendbc, views and rounding problems... My question is really two part: First why when running gendbc against SQL data are the views created with data type of B(2) when the data structure in SQL is Numeric 12.2? In VFP data this would have been N(12,2) - correct? What is the type of "B"? Then, the second equally as confusing part of this problem is that we have a field which in the debugger, the tables and the views shows a value of 37.63 and we subtract a payment of 37.63 yet the result is not 0.00 as you would expect it is -0.01 unless we include the round function on the first part of the equation [round(finalcost,2)]. We do not see the rounding problem so where is it or is this just an anomaly that has always been part of the views that we have been unaware of. Thank you! Tag: VFP9 Multiple table Report Question Tag: 211066
  - 11
    - Error reading file... This is a question that I'm sure has an answer of "no". If you have a table open, and the network connection is severed, you get "Error reading file....". OK and Help are your only options. Pressing OK brings back the message, and it's a never ending cycle. Even if the network connection is restored, you will probably not be able to escape. Alt-Ctl-Del is your only way out. Is there any other way to get out of this loop short of hard terminating the app? To duplicate this, I plugged in my USB drive, copied some tables to it, opened the table, and pulled the stick out of the USB slot. Wham, "Error reading file...". Bye bye VFP and any unsaved work. Fortunately, this doesn't happen much in production, and when it does it's usually a network glitch (or in our case Windows server 2003 flakiness that we have not yet resolved). I am tempted to classify this as a bug because it's been around for so long. I would think that Micorosoft would change this to allow you escape from this condition without having to hard terminate the app. Tag: VFP9 Multiple table Report Question Tag: 211054
  - 12
    - SET CLASSLIB when using SET CLASSLIB, if a library has already been added, will using this call create another instance of that class? Is it necessary to use the RELEASE CLASS statement? I know it is good practice to use it but is it necessary? Thank you Tag: VFP9 Multiple table Report Question Tag: 211049
  - 13
    - foxpro security question I have 1 FoxPro client that I service once a year for a few weeks. I'm not remotely a FoxPro expert. The app is still in VFP6 and that's fine for now. I may end up converting the whole thing to Access since it's pretty small and low usage. It'd be easier for me to maintain that way. Anyway, I'm trying to find out about the security available in Fox. Their company has come up with a new policy that's going to require that the database be secured to some degree. Right now it's not in a container. It was originally a Fox 2.6 for DOS app that we just grungily moved over to VFP a few year ago. So the tables are all free. Other than doing things like securing folders on the network and such, is there any way within VFP6 (or even later versions maybe) of securing the tables so they cannot be tampered with? Obviously right now anyone can get into them even if they just have odbc on their system and they have access to the folder the files are in. Anyone with MS Access can get at them. We'd like to tighten it up a bit if possible. Thanks in advance, Keith Tag: VFP9 Multiple table Report Question Tag: 211048
  - 14
    - trouble with converting a string. i know this is a real basic question, please bear with me, i am still learning. i am placing a Name from a file onto a Word Doc. in some cases its a normal name. Jane Doe, other times it could be Jane Doe-Deer. thats the one i am having trouble with. i am using proper(from) to make it look nice. but the Hypen is giving me fits. it will print like this Jane Doe-deer not very nice. any ideas? Please. thank you in advance. Tag: VFP9 Multiple table Report Question Tag: 211043
  - 15
    - Outlook is killing my Excel workbook Hello, i am using Excel and Outlook Automation to respectivley create a Workbook and email it. all that is going well. once the workbook is attached to the mail and sent, the user then will open the workbook up, add to or make changes and send it back to the sender. prior to sending it gets the workbook is printed out. and it fine. however after recieving the edited workbook back, it adds a column to the book with the same data in the previous column. EX Date Cost Total cost 2/1/05 5.00 2/2/05 5.44 10.44 this in the Send email attachment i get back date cost totalcost 2/1/05 5.00 5. 2/2/05 5.44 5.44 10.44 it adds a row of the same as Cost but removes the .oo's so 10.01 is fine but 10.10 looks like 10.1 and i dont even know why it adds that row in the first place. its wrong. Tag: VFP9 Multiple table Report Question Tag: 211036
  - 16
    - DIBAPI32.DLL Hello all and thanks for the help. There was an earlier thread that talked about how to write a "Print Screen" for a form and referred to DIBAPI32.DLL which is available here: DIBAPI32.dll comes with Palfade.exe which is on the September 1999 Technet Library Archive It's also available at http://download.microsoft.com/download/platformsdk/sample42/1/W97/EN-US/PALFADE.EXE The problem I'm having is that this DLL seems to be quite old and doesn't work with (my) Win XP. Does anyone know of a modern replacement? Thanks, Jeff Tag: VFP9 Multiple table Report Question Tag: 211034
  - 17
    - VFP8 getnextid using cursoradapter views We are having some multi-user issues having changed our system over to use cursoradapters (native and SQL). The file which controls the next id for each table is accessed via a cursoradapter. Unfortunately requery on this file fails if someone else has updated that file and hasn't yet committed their change i.e. they are in the middle of a BEGIN/END TRANSACTION. Other than avoiding getting the next id inside a transaction and requerying inside an endless loop until successful, I can't think of a way round this. I toyed with autoincrement fields but we have a lot of parent/child tables where we need to know the parent id for the child records, so I've abandoned that idea. We also access the data via ODBC in Crystal so again I think there is a problem with autoincrement fields. Has anyone got any other suggestions? Thanks, Bernie Tag: VFP9 Multiple table Report Question Tag: 211031
  - 18
    - [SingFox] VFP UserGroup Meeting Time : 6 - 9 PM Date: 4 May 2005 Place: MS Office @ Marina Bay . For More info and directions - please see http://groups.yahoo.com/group/SingFox . If You wish to attend please SMS your name to me at 9004 1089 - I have to put your name on the Roster List for MS Security Desk. warmest regards / xie xie [Bill] Tag: VFP9 Multiple table Report Question Tag: 211026
  - 19
    - How to prevent DBC trigger from firing I have to write a utility that will update production tables. The tables have triggers to update a datetime changed field when the record is updated. The nature of the change I'm making is such that this trigger absolutely cannnot fire. Is there any quick and easy way to prevent record validation rules from firing? This is a production system and I can't change the DBC just for this update. The update is an automatic process, no human intervention. Tag: VFP9 Multiple table Report Question Tag: 211020
  - 20
    - May letter on Visual FoxPro web site This month's letter contains a summary of some recent Visual FoxPro news as the Visual FoxPro team is busy working on future plans for Visual FoxPro to be announced next month. http://msdn.microsoft.com/vfoxpro/letters/ Ken Levy VS Data Product Manager Microsoft http://blogs.msdn.com/klevy http://msdn.microsoft.com/vfoxpro -- Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP cindy_winegarden@msn.com www.cindywinegarden.com Blog: http://spaces.msn.com/members/cindywinegarden Tag: VFP9 Multiple table Report Question Tag: 211019
  - 21
    - create a help file i will appreciate if can help me, i develop visualfox 7.0 application, but i need to create a help file i dont know how. Tanks Tag: VFP9 Multiple table Report Question Tag: 211018
  - 22
    - Method code swapping in VFP8 SP1 VFP8 SP1 on XP Pro SP1 I've seen this reported in other versions of VFP, but not in VFP8. After editing a form and running it, I got some odd errors. I went back into the form and found that several methods had their code swapped. The code from the Load and Init methods had been swapped, the code from the Show and Unload methods had been swapped. How's that for scary? This form has about 40 custom methods added to it and only the native methods that had code in them got swapped. The custom methods were all fine. In VFP's defense, at the time this happened, (but after the form had been saved, compiled, and run) VFP crashed due to another issue. I suspect these events are related since I've never seen this code swap problem before this. -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: VFP9 Multiple table Report Question Tag: 211014
  - 23
    - RDP, Memory and VFP Hello, At a customers place, I have to develop foxpro (8.0) in a Remote Desktop session on a heavy machine, lots of memory, 2 cpu's etc.. When I' m running large queries I frequently get an error: "Not enough memory for map file", or when I look at the rushmore optimization it says; "Not enough memory to rushmore optimize table x". I tried SYS(1104) or/and sys(3050,1,large) / SYS(3050,1,small). But nothing seems to help. Sometimes it helps to log off the rdp session and start a new session. Because off security reasons it's not easy to try the query on a local machine (without RDP)... Is there anyone who knows how to solve this? TIA Gerben Kessen Tag: VFP9 Multiple table Report Question Tag: 211012
  - 24
    - Multiple Detail bands in Report Writer? Not sure if that's what I need to do or not, but here's the gist... We do testing services here, using vehicles. The data is compiled at certain mileage intervals. The report goes like this... Header Detail lines showing data at each mileage interval More lines showing data another way at each mileage interval. Same as above, data another way. Same as above, data still another way. Same again, data still another way. Each of these "bands" show the mileage intervals and dates that the data was compiled. But each of these show the data in a different manner. Initially, raw data, next band a sort of summary type data, the next band a projection data, but still based at the individual mileage increments when the data was compiled, next band is a series of comments compiled at each measurement interval and finally a set of physical properties taken at each mileage interval. Right now this is done as a "manual" report in FPD2.6. I have no idea how to get this into the report writer. Can someone please help? Point me in the right direction? Thanks! Shawn Tag: VFP9 Multiple table Report Question Tag: 211002
  - 25
    - shellexecute I need to display .pdf' files from within a Foxpro program. I thought that a shellexecute command was the way to go, but I can't seem to get it to work. Any help and/or sample code will be great. -- Lost in Tampa Tag: VFP9 Multiple table Report Question Tag: 211000

Hi,

I am using VFP9. I have two tables, both are unrelated. Table1 with 3
records & TABLE2 with 3 records. I need to print in my report:

TABLE1 TITLE
Table1 Record1
Table1 Record2
Table1 Record3

TABLE2 TITLE
Table2 Record1
Table2 Record2
Table2 Record3

How can I print the records of two tables in a single VFP9 Report?

Thanks in advance.

Regards,
Derek

Re: VFP9 Multiple table Report Question by Anders

Anders
Tue May 10 13:13:47 CDT 2005

SELECT * FROM Table1 UNION ALL SELECT * FROM Table2 INYO CURSOR Query1
REPORT FORM xxx

"julyderek@hotmail.com" <burzinb@gmail.com> wrote in message
news:1115728694.703997.315480@o13g2000cwo.googlegroups.com...
> Hi,
>
> I am using VFP9. I have two tables, both are unrelated. Table1 with 3
> records & TABLE2 with 3 records. I need to print in my report:
>
> TABLE1 TITLE
> Table1 Record1
> Table1 Record2
> Table1 Record3
>
> TABLE2 TITLE
> Table2 Record1
> Table2 Record2
> Table2 Record3
>
> How can I print the records of two tables in a single VFP9 Report?
>
> Thanks in advance.
>
> Regards,
> Derek
>

Re: VFP9 Multiple table Report Question by Paul

Paul
Tue May 10 13:58:10 CDT 2005

I hear that VFP9 an support multiple detail bands in reports. I haven't had
occasion to try it yet, but you should be able to find info in Help.

"julyderek@hotmail.com" <burzinb@gmail.com> wrote in message
news:1115728694.703997.315480@o13g2000cwo.googlegroups.com...
> Hi,
>
> I am using VFP9. I have two tables, both are unrelated. Table1 with 3
> records & TABLE2 with 3 records. I need to print in my report:
>
> TABLE1 TITLE
> Table1 Record1
> Table1 Record2
> Table1 Record3
>
> TABLE2 TITLE
> Table2 Record1
> Table2 Record2
> Table2 Record3
>
> How can I print the records of two tables in a single VFP9 Report?
>
> Thanks in advance.
>
> Regards,
> Derek
>