Report data environment affecting form data environment

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
    - After closing a form, a connection doesn't disconnect thoroughly I just found out that whenever I closed any forms (in which I use remote views), than the connection doesn't disconnect automatically. Is this a normal behavior or do I miss something? I could not literally put SQLDISCONNECT because there might be other forms use the connections. I checked the connection using SQL Spy as I stated in my previous post. On my forms, I use Private Data Session, connect to the SQL Server via ODBC. Please advice. TIA, Willianto Tag: Report data environment affecting form data environment Tag: 205459
  - 2
    - Color Change of 'WAIT WINDOW' Does somebody have an idea on how to change the default grey color of the WAIT WINDOW to any other color ? I am working on VFP 8.0 Thanks, Ted Tag: Report data environment affecting form data environment Tag: 205444
  - 3
    - Help with FoxPro and DirectX 9 Hi, every time i try to use the video control from MS TV Video Control (MSVidCtl.dll - DirectX 9), FoxPro always Crash. Does anyone knows what is hapening? Any work arround? Thx -- Livrinho Tag: Report data environment affecting form data environment Tag: 205436
  - 4
    - Report Page Number Hi, Is this possible in a single report? I want to be able to group my invoice report and somehow reset page numbering. I tried counting the lines and using variables but had problem when data overflows. Page 1 of 1 Page 1 of 2 Page 2 of 2 Page 1 of 3 Etc. -- Thanks, Karma Tag: Report data environment affecting form data environment Tag: 205430
  - 5
    - World Country & Cities Codes Is there anywhere I can download a complete list of world's country code and it's respective cities code ? Thanks in advance! Tag: Report data environment affecting form data environment Tag: 205427
  - 6
    - Link VFP char/varchar data in ESRI ArcView 8+ Does anyone in this group have experience with ArcView 8 or 9? I am having no luck getting ArcView 8 or 9 to link spatial attribute data to my foxpro table. The field type I am trying to link with is a VFP char or varchar. The resulting link returns NULL in ArcView. This problem did not occur in ArcView 3. Hope someone out there can help... Thanks! Tag: Report data environment affecting form data environment Tag: 205415
  - 7
    - Messagebox-like .bmp's I've written my own messagebox-like dialog class and I'd like to display the standard messagebox graphics. The only complete set I can find is a bunch of icons which display with white backgrounds in the image control. Is there any (easy) way to make the backgrounds transparent so I can have a more professional look? -Lew Tag: Report data environment affecting form data environment Tag: 205407
  - 8
    - Conversion of Foxpro 2 Source to Latest Version of Foxpro or VB.Ne I have a client that wants a Foxpro 2 application updated to the latest version of the language or VB.Net. They have the source code. Any suggestions on how best to proceed? Tag: Report data environment affecting form data environment Tag: 205406
  - 9
    - Empty Objects This function can be useful for handling lightweight objects: *--------------------------------------------------------------------- * EmptyObject(fieldsList) * Receives a list of fields separated by comma * Returns an empty object with empty properties *--------------------------------------------------------------------- * Test: Customer = EmptyObject("Name,Address,Phone,Contacts[5]") Customer.Address = EmptyObject("Street,City,State,Zip,Country") Customer.Name = "John Doe" Customer.Phone = "555-1234" Customer.Address.City = "Sunny Beach" Customer.Address.State = "FL" Customer.Address.Zip = "12345" Customer.Contacts[1] = "Jane Doe" Customer.Contacts[2] = "Jim Doe" Set Step On && Check out Customer object Return Customer *--------------------------------------------------------------------- Function EmptyObject LParameters fieldsList As String If Empty(fieldsList) Then Return Null Endif Local Array fieldsArray[1] Alines(fieldsArray,fieldsList,.T.,",") Local oEmpty oEmpty = NewObject("Empty") Try For Each item In fieldsArray AddProperty(oEmpty,item,"") Endfor Catch oEmpty = Null Endtry Return oEmpty EndFunc *--------------------------------------------------------------------- Tag: Report data environment affecting form data environment Tag: 205402
  - 10
    - How to allow the user only to select a drives? Hi everyone, I need to allow the user only to select a drive from the machine. I need to create a predefind path in a drive. For this I need the user to select the drive where to create it. Is there a way where I can prompt the user to select the drive like in GETDIR()? Thanking in advance. Nadee. Tag: Report data environment affecting form data environment Tag: 205389
  - 11
    - Urgent! Can you help? I need someone to help me to work out the VFP solutions for the following within the next 4 hours. Who can help? Many thanks!!! 1) N!*M!(N-M)! 2) the square measure of a triangle 3) the summation of the even numbers from 1 to 200 Tag: Report data environment affecting form data environment Tag: 205387
  - 12
    - How Do I Ask VFP8 if a Folder Exists? In VFP6, ? FILE('MyFolder\NUL') returned .T. if MyFolder existed. VFP8 returns .F. even if MyFolder exists. I used MD with an error trap as a kludgy workaround. Is there an easier way (or function) in VFP8 to determine if a folder exists? TIA Steve Meyerson Tag: Report data environment affecting form data environment Tag: 205382
  - 13
    - Corrupted method code It's time for my semi-annual rant on this subject. I had hoped that Microsoft had fixed this, but it appears to still be there. Today I'm working on a form, and out of the blue, I open the form and find this in a dozen different methods: http://zootal.no-ip.info/stuff/evilvfp.jpg At this point the code that was there is irretreivably lost. Gone. Permanantly corrupted. This represents the loss of two days work, since that is how long since my last backup. This is something I have observed since VFP6. It happens with VFP6,7, and 8, Win98/2000/XP, fat32 and ntfs, and doesn't matter what machine I work on or where <sigh>.......and now I get to redo what I've spent the last two days doing....<sob>... Tag: Report data environment affecting form data environment Tag: 205379
  - 14
    - return value Dear sirs In my program I've a form which should return more than one value I use DO Form frm TO var but this method only returns one value which is (var) How can I return more than one value or an array of elements??? thanks Mohammed Tag: Report data environment affecting form data environment Tag: 205375
  - 15
    - How to Put a Array in a Report ? Dear Foxer There is a Array in a Report. After Build a .Exe file, has the following errors: Unknown xxxxx - Undefined How to do ? Thanks. - Tuberose Tag: Report data environment affecting form data environment Tag: 205366
  - 16
    - can save report as image file hello sir, can i save the spool of print report to printer as physical file print it any time later or can i save the report as image physical file attache in mail the problem i want to attache the receipt (payroll system) of every employee to him email and send it to see as image file or print it thanks mohamed nour Tag: Report data environment affecting form data environment Tag: 205359
  - 17
    - Intellisense - Webservice I have a web service and I am trying to register it in the intellisense manager. Based on the documentation and other readings I have found, it indicates that after I click on Tools-Intellisense Manager-Type-Webservices, I should be prompted to enter a name for the service and the WSDL url location. I am using VFP8 and I am only prompted to enter the WSDL location. Where do I enter a name for the service so that I can use the methods and properties in my code using intellisense? Many thanks and happy new year to all. Regards Shahriar Tag: Report data environment affecting form data environment Tag: 205358
  - 18
    - A lot of lockings and connections to SQL Server. Is it normal or bad? Hi all, First of all: *** HAPPY NEW YEAR TO YOU ALL!!! :) *** then, here it goes; I've downloaded SQL Spy 6.0 from Hybridx (got it from http://files.webattack.com/localdl834/sql_spy_setup.zip). It's a freeware tools to monitor SQL Server activity. I use this tool to watch how my apps (created with VFP8SP1, ODBC, RVs and SPTs) interact with SQL Server. I found out that on some parts of my apps (where there are lots of traverse and calculation), the number of locks on the SQL Server could go up to 700 and the external connection could go up to 15 or 20. And I tested that on my box (that means; I run my apps on the server and no workstation connect to the server). Whilst the apps so far running fine, it's never been really tested to the max. The traffic are quite low and the concurrent user has never exceed eight users. Yet, looking at the numbers, I'm afraid that there something that I don't do effectively. Anybody here can give me advices on C/S programming, I mean just a quick thumb rules what should and what shouldn't. Thanks in advance Willianto Tag: Report data environment affecting form data environment Tag: 205357
  - 19
    - MSMQ in VFP I am wanting to implement MSMQ in my VFP app. I found Randy Brown article on MSMQ from VFP 6.0. There is so much to read and I know so little. I do not want to reinvent the wheel and Mr. Brown's article is dated 1999 so some of it may be out of date. Where should I start? I do not mind reading or even purchasing 3rd party products to aid im implementation but I really do not know where to start. I found a link to documentation for version 2.0 but nothing to 3.0. Do I need the SDK? Thanks for any guidance. John Tag: Report data environment affecting form data environment Tag: 205353
  - 20
    - WTB DBFtrieve or other Btrieve access Anyone have a copy of DBFtrieve they want to sell? Or some other access to Btrieve data that's programmable and preferably has a small footprint? Please contact me at the address below or in the ng. -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - n g at y a h 00 Tag: Report data environment affecting form data environment Tag: 205352
  - 21
    - store tables to server while installing app, how Hi, This is probably easy to most of you but is my first trial. I have an app that utilitize free tables stored in the server under a directroy "app_data" To access the data I have this set path command hard coded in my main.prg: SET PATH TO "F:\APP_DATA" This is working fine except now I would like my program to be installable on any workstation on which the server is mapped to some other drive letters instead of F:. What changes would my program need in order to allow the user to store the tables in any directory he desires while running setup of the app, and the app still knows where to find these tables? How exactly is it done? Thanks for all help. -- jw Tag: Report data environment affecting form data environment Tag: 205343
  - 22
    - Runtime reports I have generated an insurance claim form using the GDI+ and the render method of the report listener. The form prints and previews perfectly when I run it as an .APP from within VFP9, but will not generate any print or preview output when I run it as an .EXE outside VFP9. The report is rendering, there is just no output. What am I forgetting to compile into my .EXE to get the output? -- Marina Nelson Tag: Report data environment affecting form data environment Tag: 205337
  - 23
    - calling a Webservice from VFP I am trying to test calling a webservice created in VS.net. I can access the webservice from ASP itself. When I try to access it via VFP, i get the following error message. OLE error code 0x8002801d: library not registered. My vfp code is o=CREATEOBJECT("MsSoap.SoapClient30") ?o.MSSoapInit("http://localhost/WebService4/Service1.asmx?wsdl") Is there something else that need to be registered? I am using VFP8. Many thanks Shahriar Tag: Report data environment affecting form data environment Tag: 205331
  - 24
    - Shortcut menu on a toolbar I want a menu to show up on a toolbar that I have when the user right clicks. The problem I am having is that the menu shows up on the currently active form and not right under the mouse pointer. All I am doing is on the right click calling "DO toolbarmain.mpr." How can I get this to function right? -- Altman VFP8 SP1 Tag: Report data environment affecting form data environment Tag: 205329
  - 25
    - ALTER question I have found when a table column width is enlarged using the ALTER command, the index file (CDX) may grow greatly in size. If I reindex the file and then issue a USE statement again, the index file returns to the original size. Does anyone have an explanation for this anomoly (I'm looking for a knowlegeable answer, not a guess.) TIA. --E. Myron -- To reply, change "invalid" to "net" Tag: Report data environment affecting form data environment Tag: 205324
- Next
  - 1
    - Codepage problem with DLL on vfp6 We have a Visual Fox Pro dll that is inserting information into a Visual Fox Pro database This dll is called via a Visual Basic COM object or an ASP page. VFP6 When we pass greek characters strings to the dll then the majority of times garbage data are insterted in the Visual Fox Pro database We tried several tests 1) While in the Visual Fox Pro dll we write the greek strings out to a text file. The greek data are written out correctly to the text file 2) Calling CPCURRENT() from the dll and writing it out to a file returns 1252 (This is the codpage for Windows ANSI) 3) Calling CPCURRENT(1) from the dll and writing it out to a file returns 1253 (This is the codepage for Greek Windows) 4) Calling cpdbf() from the dll and writing it out to a file returns 1253 5) We tried setting CODEPAGE = 1253 in a function that is called first whenever the dll is called but the CPCURRENT() value remains the same 6) We tried cpconvert(1252,1253,alltrim(cCustomerName)) but it does not work Thanks in advance George Malekkos Tag: Report data environment affecting form data environment Tag: 205320
  - 2
    - Check if process is running Is there a way to find out if a process is already running in windows. I would like to get a list of processes running, like that of what is in the task manager. (note: I want processes, not applications) Tag: Report data environment affecting form data environment Tag: 205319
  - 3
    - Help, how to download VFP5 SP? last version thanks -- Thanks ! Tag: Report data environment affecting form data environment Tag: 205313
  - 4
    - Problems wih compiled application I select main program, Buil and win32 executable. When i run the program, it opens first form and closes it right away. If i build application everything is ok but i'd rather have win32 app. Thx. Tag: Report data environment affecting form data environment Tag: 205312
  - 5
    - [trouble of fox9 ]Can quit app Hello My old exe work well with fox 6,7,8 and fox9 beta. But they now got trouble with fox 9. Command QUIT and the close box can not quit the exe . Any idea ? Max. Tag: Report data environment affecting form data environment Tag: 205309
  - 6
    - Buffering - Update conflict VFP8-SP1 Happy new year to all! I´m new to build a shared environment. I want to make adjustments for an VFP-app based on views for the shared data and some tables as well for mostly nonshared data. Purpose to obtain a wellworking multiuser environment. An example, code in a forms destroy; CURSORGETPROP('Buffering','vwComp1') && returns 3 for the view vwComp1 SET MULTILOCKS ON CURSORSETPROP('Buffering',3,'tblLastUsr') Replace tblLastUsr.lastc1to234 with pcvwcomp1c1to234 && works just fine Requery('vwComp1') && my errorroutine traps "Update conflict - error 1585" As far as I know the view vwComp1 is not locked from another computer in the LAN. The parameterized view vwComp1 is based on one table only. It works just fine in a singeluser environment. Is there somebody who can give me a hint? Best regards Christina Tag: Report data environment affecting form data environment Tag: 205303
  - 7
    - VFP 9 dll's needed for redistributed app All: I am trying to test one of my applications in VFP 9 and I am getting this error "Visual FoxPro cannot start. Could not load resources." I have VFP9r.dll, msvcr71.dll, gdiplus.dll in the application root. I know from VFP8 and earlier you needed to have VFP8/7/RENU.DLL in the application root. Does VFP 9 have this and if so where is the file located? I checked Common Files\MS Shared\VFP and I cannot find it as well as checking the VFP install folder. Are their any other new dll's you have to use that I might not know of? Any help is appreciated. Thanks - Art Tag: Report data environment affecting form data environment Tag: 205298
  - 8
    - Using legacy forms in FOxPro 8 We are upgrading from Fox 5 to Fox 8. In the Fox 5 application there are about 40 legacy forms left over from an earlier DOS FoxPro version of the app. These forms use a "READ MODAL" command. The help files don't explain anything more than to say that it is included for compatibility with older versions. But it worked in Fox 5 but now it doesn't work in Fox 8. Can these old forms be made to work without re-writing them? The app is being upgraded to 8 so that we have the ability to re-write in VB.NET in a piece by piece methodology where old fundtionality and new co-exist. So I would prefer to not re-write them at this time. -- T Ralya, FoxPro & .NET developer, HMSA Tag: Report data environment affecting form data environment Tag: 205291
  - 9
    - DEALING_WITH_OBJECT Hi all i want to send object containing controls as (form & container) to methode to chang in the controls and determine there kind as sending form to program to chang bach color of the buttons to red and labels to yellow [changecolor(this)] in the methode or program dealing with intire controls determin kind . how can i know the kind and deal with intire controls of form or container controls?? Tag: Report data environment affecting form data environment Tag: 205282
  - 10
    - swapping columns in a grid Hello all, Happy New Year and thanks in advance for the help. Is there a simple way to move or swap columns in a grid control? Currently I have a grid with 8 columns each of which has is own distinct properties and methods. The user has asked me to swap column 2 and 3. Is there an easy way to do this? Thanks, Jeff Tag: Report data environment affecting form data environment Tag: 205271
  - 11
    - vfp9 VS VFP6 does it worth it to move from 6.0 to 9.0 and if yes what are the problems i will face do you think is better to move to 8.0 first? Thanks George Malekkos Tag: Report data environment affecting form data environment Tag: 205269
  - 12
    - Managing period accounts I'm designing a simple accounting system for our company, an Advertising company. We have nearly 500 clients and about 200 suppliers. I'v designed all the tables needed for A/c payable(Purchase orders, Supplier invoices, Payment vouchers), A/c Receivable (Sales invoices, sales receipts) and GL(petty-cash vouchers, bank payments, journal vouchers). Now I'v come to the most difficult stage where I'v to redesign my tables, so that 'period accounts' can be maintained (eg. monthly & yearly accounts). I'v a native VFP Database on a WIN2K server(with 20 users). Basically I want to know what are the typical tables that will be used in a simple accounting system like ours and their links and structures. And the typical method of maintaining period accounts. Your help is highly appreciated. Thanks, Don Tag: Report data environment affecting form data environment Tag: 205264
  - 13
    - hard to track update error This problem has bedeviled me for weeks. I hope someone can shed some light on it. At issue is an inventory tracking system. Changes are made to current inventory, and entered into a log. In the code synopsis below, parts contains part numbers and onhand quantities (among other stuff) and invlog contains a log of inventory changes. Both tables are contained in the same database. Additions to inventory involve subtractions of certain quantities of component parts; as a result, increasing inventory of any part involves from one to as many as ten changes and log entries. This is a file server system. Up to three workstations may be adjusting inventory at once. For historic reasons, it is desired to keep all related inventory transactions together (physical order) in the log. I know that's not ideal, but there's no changing it at this point, and in any case, that's not part of the problem. But to implement this, I accumulate related log entries in the cursor invlcur, then enter them into the log all at once. The parts table is table buffered optimistic. I make the necessary changes (it goes pretty quickly), then call TABLEUPDATE. Invlog is not buffered. Here's the code: LOCAL errMsg, oExc BEGIN TRANSACTION TRY INSERT INTO invlog SELECT * FROM invlcur CATCH TO oExc errMsg = m.oExc.MESSAGE ENDTRY DO CASE CASE NOT EMPTY(m.errMsg) && not likely, since invlog is never locked ROLLBACK CASE NOT TABLEUPDATE(1, .F., "parts") LOCAL ARRAY earr(1) AERROR(earr) ROLLBACK TABLEREVERT(.T., "parts") * error handling and notification in here OTHERWISE END TRANSACTION ENDCASE The problem is, occasionally - maybe one time out of a thousand - log entries will get made, but the inventory changes do not get entered. The users report no error messages. It's as if TABLEUPDATE() failed, but returned .T. anyway. Either that or ROLLBACK failed. I could try putting the log update after the part update, but even if that seemed to work, I wouldn't have confidence in it because I don't know what's wrong. And if it doesn't work, the error occurs so rarely that it would be a while before it was discovered. I see now that I should have a TABLEREVERT(.T., "parts") after that first ROLLBACK. Yet I do not see how that could cause this problem. Can anyone help? Tag: Report data environment affecting form data environment Tag: 205262
  - 14
    - Import text to DBF in SDF format - Decimal alignment I have used 'append from' to import an SDF file into a DBF. There are 125 fields containing char, date and numeric data. Everything appears to import correctly except in 5 numeric fields defined at numeric (7,2). The decimals are either missing, 1 position or 2 positions. An example of the imported data is 0001230. The decimal should appear between the 2 and 3. The decimal appears between the 2 and 3 or the 3 and 0 or not at all. Why would the decimal alignment not work? -- Robert Neal West Palm Beach, FL USA Tag: Report data environment affecting form data environment Tag: 205260
  - 15
    - getfile() problem, please help I have these line in my application. w=GETFILE("dbf","Input file name","Sure") copy stru to w however the command "copy stru to w" not work. it did not copy the file to the specify path,the file will be copy to the foxpro directory. there is a example below w=GETFILE("dbf","Input file name","Sure") now "w" contain "c:/copy.dbf" when I add this "copy stru to w" in the program, the "copy stru to" command did not copy the specify file to "c:/". but the "copy stru to" command copy the specify file to e:/foxpro -- foxpro directory. how can I use the "copy stru to" command to copy to the file to the specify dirve and path I want . thank you for you help Ming Tag: Report data environment affecting form data environment Tag: 205253
  - 16
    - adding properties to com object at run-time I seem to having a problem adding properties to COM objects at runtime. I have a OLEPUBLIC Class (TClass1) that instantiates another class (TClass2). It then adds a new property to this object. However this new property is not visible to the calling program. I have enclosed some sample code below. Could you enlighten me please? To run the samples code you will have to add the COM Object code to a project names proj1 and build it into a COM DLL. Calling program code: loClass1 = CreateObject("proj1.TClass1") loClass2 = loClass1.Function1() If PemStatus(loClass2,"Prop1",5) ? "Property 1 exists" Else ? "Property 1 does NOT exist" EndIf Release loClass2, loClass1 COM Object Code: Define Class TClass1 As Session OLEPublic oCallback = .Null. Function Error(tnError, tcMethod, tnLine) Local lcMessage As String, lnObjectName As String lcObjectName = This.Name lcMessage = "ERROR: "+lcObjectName+"."+tcMethod+" "+"Line: "+AllTrim(Str(tnLine))+" "+Message() This.WriteLog(lcMessage) EndFunc Function Function1 *-- Do some pre callback code... *-- Issue the callback *!* This.oCallback.Event1() *-- Do some post callback code... *-- Add a property at run-time loObject = CreateObject("TClass2") If AddProperty(loObject,"Prop1","Test") This.WriteLog("Prop1 added to loObject") Else This.WriteLog("Prop1 could NOT be added to loObject") EndIf Return loObject EndFunc Function Init This.WriteLog("Starting...") *-- Initialise Callback Object This.WriteLog("Initialise callback object") This.SetCallback(.Null.) This.WriteLog("Callback object has been initialised") EndFunc Function SetCallback(toCallback As Object) Local lcType As Character If IsNull(toCallback) *-- dummy instance that does nothing This.oCallback = NewObject("ApplicationEvents") Else *-- Check callback variable is an object lcType = Vartype(toCallBack) If lcType != 'O' This.WriteLog(PROGRAM()+": callback must be object. Parameter passed is "+lcType) EndIf This.oCallback = GetInterface(toCallback, "IApplicationEvents", "proj1.class1") EndIf EndFunc Function WriteLog(tcString) *-- Write expression to default log file *-- Prefix with date and time *-- Suffix with file name *-- Always append to file StrToFile(Dtoc(Date())+" "+Time()+" - "+tcString+Chr(13)+Chr(10),"c:\app.log",1) EndFunc EndDefine Define Class TClass2 AS Custom OLEPUBLIC EndDefine Define Class ApplicationEvents As Session OLEPublic *-- Template for Callback Interface --* Function Event1() EndDefine Tag: Report data environment affecting form data environment Tag: 205249
  - 17
    - B-Trieve I need to access B-Trieve data. I've been told that ODBC works but is painfully slow. There's a product called DBFtrieve (Hallogram), but that is out of stock and will be for an unknown period of time. Does anyone have a DBFTrieve they'd like to sell? Or any other suggestions? Tag: Report data environment affecting form data environment Tag: 205247
  - 18
    - Newsgroup tool I think in last year someone has posted a newsgroup tool, which analyses the content of a newsgroup and gives various statistics and also enables anyone to look at the postings of a particular author. Has anyone got the link? I am desperately looking for an information... Thanks in advance, sp Tag: Report data environment affecting form data environment Tag: 205244
  - 19
    - Where to report minor bugs? Where does one report minor bugs in VFP9? I've found a couple. Nothing worth making a big deal over, but that should be fixed when the developers' time permits. Tag: Report data environment affecting form data environment Tag: 205243
  - 20
    - can't install VFP 9.0 I am having difficulty installing VFP 9.0 it keeps popping up a messagebox telling me to go to control panel and install and configure windows components. it doesn't however tell me which components to install. i am running XP PRO with SP2. everything is up to date, IIS is in and running. Anti-Virus autoprotect is off. Tag: Report data environment affecting form data environment Tag: 205230
  - 21
    - VFP 9 Beta Help file I installed VFP 9 Beta on my computer, but the help screens are blank. I can see the outline of everything that is SUPPOSED to be there, but the actual help screens are all missing. Can anyone give me a steer as to how to make them show? Thanks, Tim Tag: Report data environment affecting form data environment Tag: 205220
  - 22
    - Can vfp make option checked menu? Tag: Report data environment affecting form data environment Tag: 205219
  - 23
    - Database security I did some work with Foxpro 2.5 VFP 5 and 6 but I gave up on VFP because VFP did not have a security utility as in MS Access. Did I miss it or does it exist? Tag: Report data environment affecting form data environment Tag: 205217
  - 24
    - it's almost New Year ?! Hi, In case you can't stop working, or just simply forgot it .... Happy New Year. and probably for some also a Merry Christmas. and that this NG may last for ever ! regards Christophe Belgium and for the rest, I'm afraid you will have to buy it yourself... Tag: Report data environment affecting form data environment Tag: 205213
  - 25
    - FoxPro 8 Sequence of events in a Form I'm converting a form from Fox 5 to Fox 8. Most of it works, but..... The program executes code in a program module when a particular text box looses focus. Tha code modifies a table that will cause the next refresh of the form to rebuild the set of controls in the Form. Before exiting it fires the Form.refresh event. The "lost focus" event handler seems to freeze right there and it goes off to handle the refresh. the refresh executes and deletes some controls (including the one that lost the focus earlier). When the refresh event handler exits, the "lost focus" event handler resumes and tries to exit, but it errors telling me that the control is not contained in a form. Of course it isn't, I've removed it. In Fox 5 the "lost focus" event would finish exiting before the refresh event would be handled. Is there any way I can get this operation to complete correctly? -- T Ralya, FoxPro & .NET developer, HMSA Tag: Report data environment affecting form data environment Tag: 205209

Hello,

I've embedded a report within a form. Running the report moves the
record pointer of the forms data environment. Setting AutoOpen and
AutoClose of the report data environment had no effect. How can I
prevent the report data environment from affecting the forms data
environment?

BTW: Both report and form data environments are the same, even table
relations.

Top

RE: Report data environment affecting form data environment by Leemi

Leemi
Tue Jan 04 14:08:57 CST 2005

Hi Mattheson:

I think the workarounds in this article may help you:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;185628

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Hello,

>I've embedded a report within a form. Running the report moves the
>record pointer of the forms data environment. Setting AutoOpen and
>AutoClose of the report data environment had no effect. How can I
>prevent the report data environment from affecting the forms data
>environment?

>BTW: Both report and form data environments are the same, even table
>relations.

Top