Report data is wrong

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
    - Select INTO Cursor I have a form that calls other forms, and a combobox on the parent form created a cursor with the same name as a combobox on one of the child forms. In my Test environment on W2K Terminal Services, I received the error message "cannot access the selected table", but this never failed once in the development enviornment on XP. Why? Tag: Report data is wrong Tag: 222437
  - 2
    - Form redisplay issue - VFP9 I am having a problem with a form redisplaying all of the objects when it is done processing. These particular forms do some process intensive queries. When the user clicks the process button I set the mouse pointer to an hourglass. The form will then repaint (not done by me) and will sit there blank while the query thermometer bar gives progress. When the query is done the form will not redisplay the objects and sits there empty unless you hover the mouse over a button and then it magically reappears. If you move the mouse around the form the objects will appear. If I do a thisform.refresh in the code before returning from the click event of the process button it doesn't do any good. Anyone else experiencing this??? Have you found a way to prevent it??? Jim Tag: Report data is wrong Tag: 222428
  - 3
    - I think this is an SQL question... Hello and thanks in advance for the help... I have two cursors which are the result of two different queries. Each table has the following fields: Folio N (6,0) Code C(4) In a perfect world they are identical. When the are not I need the following two additional cursors: All records in the first cursor that are missing from the second All records from the second cursor that are missing from the first Right now I'm doing this using an index: STR(FOLIO,6,0)+CODE for both tables. Then I setup a relation from one to the other: SET RELATION TO STR(FOLIO,6,0)+CODE INTO TWO Finally I use a copy command: COPY TO NOTINONE FOR FOLIO <> TWO.FOLIO This works but copy will only create tables. There doesn't appear to be a "COPY TO CURSOR" I imagine that this could be done with another SQL query but I'm not sure how to setup that query. Thanks again. Jeff Tag: Report data is wrong Tag: 222422
  - 4
    - how to print different pages from different trays Hello, Anybody know how to switch the paper tray in report in order to print the first page from one tray and the following from another? I am using VFP9 but print engine of 8. Thanks, Vitas Tag: Report data is wrong Tag: 222419
  - 5
    - Chicago FUDG meeting 11 Apr 06 Chicago FoxPro Users and Developers Group - Tuesday 11 April 2006 You're invited to Chicago to hear Rick Borup present "Best Practices in Deploying Visual FoxPro Applications". He's an author of a book available at Hentzenwerke on the same subject. He is a consummate teacher, who brings to bear his many years of experience as an independent developer. He is giving us a Sneak Preview of his presentation for the upcoming Best Practice Conference in Milwaukee. http://www.hentzenwerke.com/conferences/glgdw2006.htm Rick has consistently brought the most useful techniques to our attention. He woke us up to Inno Setup, Beyond Compare, Cascading Style Sheets, and Tag Clouds. He'll be driving up from Champaign next week and will deliver a very polished talk. Let's return his respect for us with a great turnout. Attendance at our meetings has been up recently. Craig Boyd's March talk on Fox as it gears for the Future kept the group intrigued for 2 eighty minute sessions wrapped around a pizza break.Tom Corrigan's Dot Net Data Access talk in January was top notch and larger than average. Stoke the momentum. See you there? April 11th, Monadnock Building, 53 W. Jackson, Suite 826, Chicago Loop, doors open at 5:30 PM. http://www.ChicagoFUDG.com -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200604/1 Tag: Report data is wrong Tag: 222418
  - 6
    - Color in Hexadecimal Notation Q. How do you get color in hexadecimal notation? Respectfully, Jonathan Morningstar www.mstar.info ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Report data is wrong Tag: 222409
  - 7
    - Window on top erasing part of window on bottom When the main form of My application is displayed on the Windows desktop, the user will size it in order to see the desktop. Then he activates another window, for example Outlook. Now two windows are on the desktop. He drags the Outlook window across My window, and this "erases" part of My window, as if an eraser had been dragged across it. On my development machine, My window refreshes itself pretty fast, so it is "unerased". But on one of my users' machine, the erased part tends to stay erased. Is her machine slow? Is there a fix? Tag: Report data is wrong Tag: 222407
  - 8
    - VFP9 installation problems after motherboard replacement Hi -- - I just got my desktop computer back from the shop. The motherboard was replaced, but as far as I could determine, no other components, including software, were altered. - When I attempted to start VFP9, however, I got an error message that said something like "Memo file for foxuser.dbf is damaged or cannot be found. Do you want to overwrite with another memo file? Yes/No." I chose "No." - After repeatedly trying to restart VFP9 and still getting the same message, I relented and clicked "Yes." - VFP9 then started OK, but it would not retain the various IDE selections (fonts, etc.) upon the next restart. - Getting more frustrated, I uninstalled Foxpro, defragmented the hard drive, and reinstalled Foxpro from the original CD. - The same thing occurred. No error message, but the interface could not be modified. - I looked for and found the foxuser.dbf file and attempted to open it, but this is the error message I received: - "Memo file c:\...\temporary directory 4 for xsource.zip\vfpspace\addlabel\foxuser.fpt is missing or is invalid." - I uninstalled and reinstalled Foxpro once more. Same thing is happening. - Any help would be appreciated. - Thanks, David Tag: Report data is wrong Tag: 222406
  - 9
    - prob when I hit enter in editbox Hi, i'm experimenting some trouble with editbox control when i hit enter in editbox.. cursor goes up (to the previous line) ?! my setup: (very simple setup) CREATE CURSOR CurTest (Field1 M) && a simple cursor with memo field INSERT INTO CurTest (Field1) VALUES ("qwertyuiop") CREATE FORM add editbox object.. set property: .ControlSource = CurTest.Field1 ** no prob here ** in InterativeChange Method add: string1 = this.value ** now prob begin ** run this form move keyboard cursor .,. between 'y' and 'u' press enter cool, you got 2 lines.. "qwerty" and "uiop" but why cursor come back to the first line ?? idea ? Pat Tag: Report data is wrong Tag: 222402
  - 10
    - windows bindevent : file detect Hi, I'm trying to implement a version of the filedetect class used in the Solution project that ships with Foxpro9. It works fine except for this problem : I'm trying to detect new files being added to a directory. When I'm copying a file in Windows Explore, I get a 'New File' event, but when I create a file using VFP or VS.Net I just get an "directory updated" event without the exact filename. Does anybody know how to solve this problem ? I could query the files in the path ofcourse, but I like to keep it as simple (and fast) as possible. tia Xavier Tag: Report data is wrong Tag: 222395
  - 11
    - Input mask I'm trying to display data using mask that adds leading letter W (uppercase) In prior wersions it was simple ( value '11234121234' + mask W9.9999.99.9999 -> W1.1234.12.1234). In VFP9 W was included as lowercase indicator. Did anybody know how include it into mask as a letter? K.E. Tag: Report data is wrong Tag: 222394
  - 12
    - Deleted records in a report How do you stop deleted records from showing in a report? I tried the init method for the table in the data environment by putting the following code: set filter to !deleted() But that stopped the entire report from working. any ideas? Thank you. HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: Report data is wrong Tag: 222387
  - 13
    - Progress Bar Linked With Data From SQL Server Hi All I Try To link My Progress Bar With RemoteView Sql Table I Find Example In Local Table Which use UDF To Make Record Counter But doesn't Work With Remote Data Any id Please Thanks Tag: Report data is wrong Tag: 222377
  - 14
    - Hi ½Ð°Ý³o¸Ì¦³¨S¦³¥xÆWªB¤Í, thanks! Hi, ½Ð°Ý³o¸Ì¦³¨S¦³¥xÆWªB¤Í, ¦]¬°§Ú¦b»´ä, µ¥¤F«Ü¤[¤]¨S¦³¤¤¤å VFP9.0 ªº®Ñ, ½Ð°Ý§AÌ³o¸Ì¦³¨S¦³, ÁÂÁÂ! Thanks ! Tag: Report data is wrong Tag: 222376
  - 15
    - Drawing Add-In's for VFP 9.0 I am looking for a third party add-in that will allow me to add some type of drawing or paint module to VFP 9.0. Simple sketches and/or drawings are needed for the project that I am working on. Thanks in advance for any assistance..... Nick Tag: Report data is wrong Tag: 222367
  - 16
    - OT, a bit: SQL Server DSN I have an app that requires an ODBC source. The DSN cannot be accessed unless the Windows login is an Administrator. I know it's not a by-user problem, because the same user as Limited cannot read the data, but promoted to Administrator, it works fine. Any ideas why this might be happening? Tag: Report data is wrong Tag: 222364
  - 17
    - Report -- How to prevent blank page when no data encountered Occasionally when printing a series of reports, a "no data" situation occurs. This is OK, but what happens is that a single blank page is printed. - What is the simplest thing I can do to prevent a blank page from being issued when there is no information to print? - Thanks, David Tag: Report data is wrong Tag: 222361
  - 18
    - DataGrid Freeze the column i want to freeze 1st and 2th column in data grid when user scoll it . Can I do that ?? thanks Tag: Report data is wrong Tag: 222359
  - 19
    - Grid Column Sorting (another try) Hi all, I have a table "A" with a field booknumber that points to booknumber in another table "Books", the relationship is one to many. if I have the table "A" in a grid and point the ControlSource of the booknumber to the bookname in "Books", how can I sort the grid by the bookname and not the booknumber when I click on the column header. this is the code I use in the Click event of the column header oGrd = Thisform.pageframe1.page2.grdtableA SET ORDER to booknumber ascending GO top oGrd.refresh I want to be able to sort the grid using the bookname instead of booknumber from the books table. I know I can do that by using a view, but any other ideas? Thanks HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: Report data is wrong Tag: 222356
  - 20
    - Copy To and memo fields? Hi, I'm running VFP 9.0, making an application which collects data from a SQL 2000 Server and synchronizes it with a Palm Pilot. I'm making the application in the Palm with Satellite Forms and for the most part it's working well. However, I've just run into a road block and don't know how to solve it yet. When I query the SQL data for one table one of the fields is a memo type field. To sync. with the Palm I need to store the data in dbase format so I use the Copy To... command with the type set as FOX2X. Of course the Copy To... command doesn't copy the contents of a memo field so my application doesn't work. Is there a work around for this? Anyone know how I can create a dbase style table including a memo field? Thanks in advance, Linn Tag: Report data is wrong Tag: 222354
  - 21
    - shared connection What are the ramifications of using a shared connection in the creation of a remote view, compared to an "unshared" connection? FoxPro docs say this: "The SHARE keyword specifies that Visual FoxPro use a new statement handle for the shared connection, if available. If a shared connection is not available, Visual FoxPro creates a shared connection when the view opens, which you might be able to share with other views." But that really doesn't give much useful information. Under what circumstances would I want to share, or not share, a connection? Tag: Report data is wrong Tag: 222351
  - 22
    - stored procedure called from wrong database We are having an issue with a new application. It is using 2 FoxPro databases, which both contain a stored procedure called NewID(), and a table called ID_MASTER where the unique ID's are located at. We use the NewID() stored procedure as the default value for our primary keys, called as NewID('TableName'). But at other times, we need to find out what the ID is before our insert into the database, to link this ID in child tables for their inserts. Pretty straight forward so far. The problem is that sometimes the newid() stored procedure seems to be getting called from the wrong database, and it returns the wrong value. This occurs in both instances above. An example is: INSERT INTO MARKIII!demand_order (bin_id, dmd_time_low, dmd_ready, ord_id) ; VALUES (laAvailableBins(iCount,1), lnEmptyTime, lbReady, .NULL.) the primary key is dmd_id, and it has a default value of NewID('demand_order'),yet sometimes it access the wrong database. We have listed prior to this code SET DATABASE TO MARKIII, as well as SET DATABASE TO (this.database_location) this.database_location is the full path and database name to our location. Any help would be greatly appreciated. Tag: Report data is wrong Tag: 222337
  - 23
    - User's Desktop - VFP9 Does anyone know of an FLL that is already out there that implements the SHGetSpecialFolderLocation API function to get the user' desktop? I don't know much about using the windows API from c++ so, if there were one already made would be great. I do know about using windows scripting to get the users desktop, but I would like to use something a little more reliable. (windows scripting may be turned off) Any ideas, suggestions, leads to an fll..? Thanks! Tag: Report data is wrong Tag: 222335
  - 24
    - FoxPro Stack Overflow Hi all. I have a single-threaded FoxPro 8 DLL being instantiated and used in a IIS ASP application. At times, the DLL will stop responding and produce a stack overflow. I am able to catch the problem with WinDbg and it shows me the recurring frames but I do not understand how to proceed in order to find where in the FoxPro CODE itself the error is occurring. I need some assistance in translating the dump into areas in the actual code that are causing the loop. The results of !analyze -v are below. Thanks for any help! 0:025> !analyze -v ******************************************************************************* * * * Exception Analysis * * * ******************************************************************************* ************************************************************************* *** *** *** *** *** Your debugger is not using the correct symbols *** *** *** *** In order for this command to work properly, your symbol path *** *** must point to .pdb files that have full type information. *** *** *** *** Certain .pdb files (such as the public OS symbols) do not *** *** contain the required information. Contact the group that *** *** provided you with these symbols if you need this command to *** *** work. *** *** *** *** Type referenced: ntdll!_PEB *** *** *** ************************************************************************* *** WARNING: Unable to verify checksum for pdm.dll *** ERROR: Symbol file could not be found. Defaulted to export symbols for pdm.dll - *** ERROR: Symbol file could not be found. Defaulted to export symbols for oledb32.dll - FAULTING_IP: vfp8r!EXECloseDoHistory+5d 0c0615d5 a1f8d43a0c mov eax,[vfp8r!g_punt (0c3ad4f8)] EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff) ExceptionAddress: 0c0188cf (vfp8r!_chkstk+0x00000026) ExceptionCode: c00000fd (Stack overflow) ExceptionFlags: 00000000 NumberParameters: 2 Parameter[0]: 00000000 Parameter[1]: 02172ecc BUGCHECK_STR: c00000fd DEFAULT_BUCKET_ID: APPLICATION_FAULT PROCESS_NAME: DLLHOST.EXE ERROR_CODE: (NTSTATUS) 0xc00000fd - A new guard page for the stack cannot be created. RECURRING_STACK: From frames 0x4 to 0xc LAST_CONTROL_TRANSFER: from 0c2d6f38 to 0c0188cf STACK_TEXT: 021abee0 0c2d6f38 00000000 0000001e 00000000 vfp8r!_chkstk+0x26 021abef4 0c116276 20657355 525c3a58 4f534945 vfp8r!PCProgReset+0xc4 021adfa0 0c0c869f 00000001 00000000 898fdbe3 vfp8r!macro+0xff 021adfb4 0c0615d5 00000000 039d0270 021ae058 vfp8r!x_macro+0xc 021adfd4 0c061204 0c3ab4e0 0c061776 00000001 vfp8r!EXECloseDoHistory+0x5d 021adfdc 0c061776 00000001 00000000 0c3ad560 vfp8r!imode+0x96 021ae058 0c083b7a 00000000 00000000 00000000 vfp8r!xDoStmt+0x160 021ae318 0c0839ed 0000030c 039d17d5 0c018b3d vfp8r!arrayelement+0x3e1 021ae324 0c018b3d 0000020b 0c3ad560 0000002c vfp8r!esubscript+0x17 021ae398 0c06388b 00000008 021aea10 021aeb34 vfp8r!xxexpr+0xba 021ae3b0 0c0732e6 021ae3c8 00000008 00000004 vfp8r!xxgetname+0x33 021ae5e0 0c07543c 00000000 00000014 0c3b0aa0 vfp8r!DBMObj2SpecEx+0x11f 021aebec 0c0615d5 00000045 039d16f3 021aec90 vfp8r!x_use+0x1ba 021aec0c 0c061204 0c3ab4a0 0c061776 00000000 vfp8r!EXECloseDoHistory+0x5d 021aec14 0c061776 00000000 021aee0c 00000003 vfp8r!imode+0x96 021aec90 0c0a5811 00000045 00000045 00000040 vfp8r!xDoStmt+0x160 021aed10 0c0a57a9 021aee00 00000003 00000045 vfp8r!LDCIs25Form2+0xca 021aed34 0c069583 00000045 00000002 00000000 vfp8r!LDCInvokeUserMethod+0x8c 021aee58 0c0a5380 00000002 0394518c 00000003 vfp8r!omDoMethodOrEvent+0x6d1 021af030 0c2352e7 00000002 0394518c 00000003 vfp8r!omDoMethod+0x318 021af0b4 0c2362ca 021af0f0 00000045 000002ff vfp8r!CFoxOleObjIGetOleObject::GetOleObject+0x1a6 021af1b4 0c2364f1 03841b9c 00000001 00000000 vfp8r!CFoxOleObjIDispatchInvoke+0x2ad 021af1e8 6b614279 03841b9c 00000002 6b65c888 vfp8r!CFoxOleObjIDispatch::Invoke+0x48 021af240 0c1cc64f 0cff32e0 021af214 0c0f177a vbscript!DllUnregisterServer+0x43 021af24c 0c0f177a 021af9a8 6b6578ce 6b658e28 vfp8r!CstSrvComMapBlindFunc+0x46 021af264 6b61866f 052c0a78 03841b9c 00000002 vfp8r!ATL::AtlInternalQueryInterface+0x63 021af988 6b62e400 00000018 021afa7c 00000000 vbscript!GlobalBinder::EnsureBuiltin+0xf60 021afa38 6b62f166 021af9a8 00000000 56433230 vbscript!CScriptRuntime::SetVar+0x13a 021afab0 6b61a3d6 00000000 00000000 00000000 vbscript!CScriptRuntime::Run+0xc83 021afaf8 6b61a251 02563960 6b607b25 02579460 vbscript!GlobalBinder::EnsureBuiltin+0x5e00 00000000 00000000 00000000 00000000 00000000 vbscript!GlobalBinder::EnsureBuiltin+0x392e FOLLOWUP_IP: vfp8r!EXECloseDoHistory+5d 0c0615d5 a1f8d43a0c mov eax,[vfp8r!g_punt (0c3ad4f8)] SYMBOL_STACK_INDEX: 4 FOLLOWUP_NAME: MachineOwner SYMBOL_NAME: vfp8r!EXECloseDoHistory+5d MODULE_NAME: vfp8r IMAGE_NAME: vfp8r.dll DEBUG_FLR_IMAGE_TIMESTAMP: 3f73c232 STACK_COMMAND: .ecxr ; kb FAILURE_BUCKET_ID: c00000fd_vfp8r!EXECloseDoHistory+5d BUCKET_ID: c00000fd_vfp8r!EXECloseDoHistory+5d Followup: MachineOwner --------- Tag: Report data is wrong Tag: 222329
  - 25
    - VC++ ADO VFPOLEDB: DB locally works; DB on NT server does not I've written an application in VC++ in VS2005 that includes access to a VFP 9 database using ADO and the VFPOLEDB driver. I'm using ADO (msado15.dll). What is odd is that this application works fine when the VFP database is on my own computer, but when it is on the network server, and I attempt to open the RecordSet, I get an error saying "Feature is not available". To test this outside of my own program, I used Excel, Import External Data, and its Data Connection Wizard to create the connection to my database on the server. When I click Test Connection, I get a message saying connection succeeded. I then select Access permissions Read and Share Deny None. The window that would allow me to select the table to use is empty. If I repeat this using the VFP database on my own computer, the window lists all of the tables in the database. The database on my computer is a copy of the one on the network server. I am logged into the network using an administrative account. I can use VFP, and open the database on the server from my computer without a problem. I would appreciate your help. Thanks, Tag: Report data is wrong Tag: 222327
- Next
  - 1
    - Iniread section? (VFP7) Hi. I use the function below to read keys from ini files, and it works fine. Sometimes I want to read an entire section into a string variable. How could that be accomplished? ***************************************************************** *!* Function IniRead ***************************************************************** Lparameters cSection, cKey, nLen, cInifile Local cRetval, cPath cRetval = Space(nLen) + Chr(0) Declare Integer GetPrivateProfileString In Win32API As GetPrivStr ; STRING cSection, String cKey, String cDefault, String @cBuffer, ; INTEGER nBufferSize, String cIniFile If GetPrivStr(cSection, cKey, "", @cRetval, Len(cRetval),cInifile) == 0 Messagebox('Ini file error', 16, program()) Endif Do While Not Empty(At(Chr(0),cRetval)) cRetval = Alltrim(cRetval) cRetval = Left(cRetval,Len(cRetval)-1) Enddo Return(cRetval) ***************************************************************** *!* End of function IniRead ***************************************************************** Tag: Report data is wrong Tag: 222326
  - 2
    - PDFcreator Com Interface Has anyone got an example of how to use the com interface of pdfcreator? Still pretty new to windows programming and I haven't got a clue (even after reading some of the sample scripts - where i could). What I want to do is print a report to a pdf file then email using blat (that bit I can do!) thanks Steve Tag: Report data is wrong Tag: 222322
  - 3
    - HYPERLINK LABEL Hi all I looking For Something Like HyperlinkLabel Not To Used With URL But To Run Procedure From My Form Thanks Tag: Report data is wrong Tag: 222319
  - 4
    - Not a character expression (Error 45) Thanks for help. I create a query in visual foxpro 9!The sql is: select a.num,b.doctor; from (select count(id) as num,cl group by cl) a; (select count(id) as doctor,cl where dt="doctor" group by cl); where a.cl=b.cl It can get the correct data from the table,but it could not be readable by the query designer. Whenevery i quit/open the query view there is a messagebox say "Not a character expression (Error 45)" and there is nothing in query designer. I wander how to edit/run the sql without the warning. Or without the designer tool edit the sql in the sql view directly! Thanks anyway! Tag: Report data is wrong Tag: 222316
  - 5
    - Illegal Immigration, the Non-Issue of the Week........................ Our politicians loved talking about it this week, but they won't do anything about it. Get the details from The Expert: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Report data is wrong Tag: 222315
  - 6
    - dataenvironment class code Hello All, I have the following code for an dataenvironment for a report. The last line("this.cursor1.filter...) in the IF statement doesn't work unless I have the variables as PUBLIC. The variables contain valid dates. Could I do this any other way? Thanks Dave DEFINE CLASS dteInspectionHoursReport as dteDataEnvironment initialselectedalias = "vr0002" ADD OBJECT cursor1 as cursor WITH ; alias = "vr0002", ; cursorsource = "vr0002", ; database = "main.dbc" PROCEDURE Init() DODEFAULT() LOCAL loDateRange as Object, ldStartDate as Date, ; ldEndDate as Date LOCAL ARRAY laDate[2] laDate[1] = DATE() - 30 laDate[2] = DATE() loDateRange = CREATEOBJECT("_daterange",@laDate) loDateRange.Show(1) IF TYPE("loDateRange") = "O" AND !ISNULL(loDateRange) ldStartDate = loDateRange.dStartDate ldEndDate = loDateRange.dEndDate this.cursor1.filter = "BETWEEN(dinspectionact,ldStartDate,ldEndDate)" ENDIF ENDPROC ENDDEFINE Tag: Report data is wrong Tag: 222312
  - 7
    - DropDown List Display Ok maybe I am brain dead right now. I have a dropdown list. It contains 6 fields from a table. It must be a table and NOT an array because there are too many elements (records x fields - about 14,000 records x 6 elements and growing) for an array. The control is bound to column 6 (numeric). The control displays the first 5 columns (text) when it is in dropdown mode. When I select a row from the dropdown, it displays ONLY the data in column 6. I want to display the data in the other 5 columns, not column 6 I have tried to play with the displayvalue but for the life of me, i cannot figure it out. Thanks in advance. Tag: Report data is wrong Tag: 222309
  - 8
    - Suggestion for INPUTMASK I would like to suggest an enhancement to 'INPUTMASK' and 'DYNAMICINPUTMASK' - to add an option to 'prevent any data entry'. Reason - there are several ways to simulate 'dynamicReadonly' but this option to INPUTMASK would facilitate this easily. Mike Farnesi San Diego Tag: Report data is wrong Tag: 222306
  - 9
    - Detecting Mouse Clicks in Grid Column Headings Hello, Thanks in advance for the help. How do you detect mouse events in column headings in a grid control? Suppose you wanted to make clicking in a column heading perform a select/deselect all toggle. How would you know that the column heading has been clicked? Thanks, Jeff Tag: Report data is wrong Tag: 222303
  - 10
    - last record per id view I have an Oracle table with assets, periods and various other fields. Can a create a view to show me the records for the last period per asset? The 2 stage SQL all processed at the client end would be something like SELECT asset, MAX(period) AS maxper ; FROM table ; GROUP BY asset ; INTO CURSOR foo SELECT table.* ; FROM table, foo ; WHERE table.asset=foo.asset ; AND table.period=foo.maxper but I don't want to drag a gazillion records into Fox to do that if I can avoid it by making the server process it before sending. -- TIA Andrew Howell Tag: Report data is wrong Tag: 222298
  - 11
    - spiradoc record delete Strange happening here. I have an app that continually runs which uses a table "config" that contains 100 paramters in a single record to control it's operation. Every once in a while the program bombs and I find the config table either with an extra blank record or the single record is marked for deletion. There is no code to append or delete that file. The only thing I can come up with is possibly a routine in my program that selects another table and deletes/appends records is failing on the open and because the config table is always open it reverts to that. Any other idea how this could happen? And/or suggestions to prevent? TYIA - Ben Tag: Report data is wrong Tag: 222296
  - 12
    - blatmailen doesnt work hello,. i trying to send email with blat and smtp thats my configuration: blat -install servername sendername -1 -5022 telnetconnection to the exchangeserver with port 5022 works and here are the syntax blat test.txt -to meineadresse@firma.de Blat v2.5.0 w/GSS encryption (build : Sep 14 2005 22:46:29) Sending test.txt to meineadresse@firma.de Login name is testtd Error: Not a socket. Error: Not a socket. sorry for the bad english ;-) i hope you can help me Tag: Report data is wrong Tag: 222292
  - 13
    - Strange table behavior I am using VFP 7.0 and have table that I open, zap and then append new datafrom a delimited text file. When I do it manually from the development environment it works ok. When it runs in my program from the IDE or stand alone it has the old data in the table. How can that be from a zapped table? I've put browse windows between the lines and it is empty and them appends old data. I don't know where it is getting it. That file name does not exist anywhere else on my system. Please help! USE rmsmove IN 3 EXCLUSIVE SELECT rmsmove browse && old data ZAP browse && empty table APPEND FROM .\updates\rms.full.txt DELIMITED WITH CHARACTER | browse && old data again??? *REINDEX Cory Tag: Report data is wrong Tag: 222279
  - 14
    - Inet control StillExecuting not being set to False I have a control that is based on the Inet control it has a httppost method which is below. During development everything works fine but after I build an exe the StillExecting property is not being reset to .F. and the exe is using 95% of my processor. The "After THIS.StillExecuting " test is not being written out to the file. I use this same control on other forms with no problem in development or in an exe. Anyone have any ideas as to what could be causing this. I am using VFP 7 SP1 on XP Pro. The httppost method: STRTOFILE("HTTPControl.Execute"+CR_LF,"c:\temp\auth.txt",1) THIS.Execute(tcURL, "POST", tcSource, lcHeaders) STRTOFILE("After HTTPControl.Execute"+CR_LF,"c:\temp\auth.txt",1) DO WHILE THIS.StillExecuting * Wait for the end of the request DOEVENTS ENDDO STRTOFILE("After THIS.StillExecuting"+CR_LF,"c:\temp\auth.txt",1) Tag: Report data is wrong Tag: 222277
  - 15
    - Moving from VFP 6 to VFP 9 We currently support Visual AccountMate for a client of ours, which is accounting software written in VFP. We do a lot of reading from and writing to VAM data structures from outside VAM itself. The VAM version our client has been using, LAN 5, was written in VFP 6 and that's what we've used to talk to its data structures and for our own custom development work for this client as well. We are planning to install a newer version of VAM, also LAN (VAM also has a SQL Server-based product but we are not doing that upgrade now although we will in the future, I'm sure) that was written in VFP 9, and would like to know if we should expect changes in data structure significant enough to cause our VFP 6 programs to be unable to read from and write to VFP 9 tables. Obviously we are planning to upgrade our own VFP to 9 but we're trying to figure out if we can get away with doing the VAM upgrade before doing the VFP upgrade for ourselves and for our client. Thanks in advance - detailed replies, e.g, "this will work, but that won't" are most welcomed. -S- Tag: Report data is wrong Tag: 222268
  - 16
    - VFP 9: Report label orientation and preprocessed totals This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C65308.53710F40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Some of the features touted for VFP9 report writer were preprocessed = totals and the ability to rotate labels. I've checked documentation and found no references to these two = features. Were they ever implemented? Thanks for the response. John. ------=_NextPart_000_000A_01C65308.53710F40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD><FONT face=3DArial><FONT size=3D2> <BODY> <DIV>Hello,</DIV> <DIV> </DIV> <DIV>Some of the features touted for VFP9 report writer were = preprocessed totals=20 and the ability to rotate labels.</DIV> <DIV>I've checked documentation and found no references to these two=20 features.  Were they ever implemented?</DIV> <DIV> </DIV> <DIV>Thanks for the response.</DIV> <DIV>John.</DIV></BODY></HTML></FONT></FONT> ------=_NextPart_000_000A_01C65308.53710F40-- Tag: Report data is wrong Tag: 222265
  - 17
    - OT: Help Desk software recomendation Have received much help here for my VFP app but now I need help keeping the support end organized. Can anyone recommend a good help-desk ticketing software program? Don't want to re-invent the wheel here. Looking for something web-based, Google search returned too many results. I'd like to know if anyone here can make a recommendation. TYIA - Ben Tag: Report data is wrong Tag: 222263
  - 18
    - decompiling VFP 5.0 I understand there's a program called Refox that will do this, i'm wondering if there is anyone out there who'd be willing to do this for less than the $400 cost of their program? I've lost everything (computers and backups) in a fire, but can get customer .exe files. If anyone can help please let me know,thanks. -- jamesrav ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Report data is wrong Tag: 222260
  - 19
    - Network slows down SELECT-SQL I am having a DBF named MJOB.dbf with 20000 records. The table has indexes on the following fields:- JOBNO JOBDATE JOBSERIES I have also indexed on Deleted() as set deleted in on. However, the following select-sql takes around 6-8 seconds when executed from a workstation. ***Code*** Select max(JOBNO) from MJOB ; where SERIES='A' and Between(JOBDATE,mFDate,mTdate) ; into array mARray Return mArray I tried out several things and later the following proved to be more quicker. (It takes less than 1 sec) **Code** Select JOBNO from MJOB ; where MJOB.SERIES='A' and Between(MJOB.JOBDATE,mFDate,mTdate) ; order by 1 ; into cursor c1 Select C1 Go Bottom Return C1.Code Is MAX() function not optimized by RUSHMORE or is there any other mistake in my 1st code. Kindly guide. Rajeev Tag: Report data is wrong Tag: 222258
  - 20
    - DWG viewer activeX Does someon know where i can download a dwg viewer activeX for foxpro Thanks Tag: Report data is wrong Tag: 222256
  - 21
    - OLEDragdrop question hi, I've got an application which uses the MS listview activex control. I want to be able to drag an item from that listview control and drop it onto the windows desktop and have it create a textfile with the name of the listview item I just dragged. Does anybody have any code that demonstrates how to do this? Thanks Tristan Tag: Report data is wrong Tag: 222253
  - 22
    - SQL group by error the following command works fine in VFP 6, but won't work with VFP 9. I get a "1807: SQL: group by clause is missing or invalid". What is wrong with it?! (something silly I've missed I bet) select Creditor.CreditorCd, Creditor.AddrRecID, ; GetDisc(Creditor.PromptTerm) as Discount, ; CredTran.CrTranID, TranDate, PayBy, Reference, CredTran.Amount, ; CredTran.Outstandng, TotAuthAmt, PromptTerm, CredTran.Paid, CredTran.TaxAmount, ; 00000.00 as DisAmount, 000000000.00 as AmtToPay, ; 00000000.00 as Pay, "Chq" as cPayType, ; count(1) as LineCount ; from CredTran inner join Creditor ; on CredTran.AddrRecID = Creditor.AddrRecID ; inner join TranLine ; on TranLine.CrTranID = CredTran.CrTranID ; where PayBy <= pdPayToDate .and. CredTran.Outstandng > 0 ; and TotAuthAmt > 0 and TotAuthAmt <> CredTran.Paid ; and OK2Alloc({}, CredTran.Outstandng, .T., CredTran.TranType, CredTran.Status, .T.) ; group by CredTran.CrTranID ; order by PayBy ; into table (lcFileName) Grant Tag: Report data is wrong Tag: 222251
  - 23
    - Grid column sorting Hi all, I have a table "A" with a field booknumber that points to booknumber in another table "Books", the relationship is one to many. if I have the table "A" in a grid and point the ControlSource of the booknumber to the bookname in "Books", how can I sort the grid by the bookname and not the booknumber when I click on the column header. this is the code I use in the Click event of the column header oGrd = Thisform.pageframe1.page2.grdtableA oGrd.SetAll("Picture","","Header") SET ORDER to booknumber ascending GO top oGrd.refresh I want to be able to sort the grid using the bookname from the books table. I know I can do that by using a view, but any other ideas? Thanks HME -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com Tag: Report data is wrong Tag: 222250
  - 24
    - In order to calculate the check number Hello there! I would like to ask for you help. In order to calculate the check number, I have to determine the division of a 21 digits number by 97 and for that I use the MOD () command. The problem is that Fox only uses 15 digits for numeric values, and I would need to get the result more then only 15 digits. The command is mod(2500003842908003100,97) Do you know how I can solve this problem? Thanks in advance, Pedro PS - sorry for the bad English Tag: Report data is wrong Tag: 222245
  - 25
    - Changing a report after the exe is made Is there a way to make changes to a report in the manner below after the executable is made? I'd like to parse the report according to the user's selections. Thanks ***********code - not mine LOCAL ARRAY laForms[1], laLinesToWipe[1], laSettings[1] LOCAL lnCurForm, lnFormCount, llNeedsCompiling, lcOldDir, lnNamesOnLine, ; lcOldFont, lnNumSettings, lcTargSetting, lnLoop, lcNewExpr *----------------------------- Program Code Begin ------------------------- - #define MAX_LINE_NAMES 4 #define NAME_WIDTH 28 lcOldDir = ALLTRIM(SET("DEFAULT")+ALLTRIM(CURDIR())) IF !EMPTY(tcWhere) AND TYPE("tcWhere") = 'C' set default to (tcWhere) ENDIF CLEAR CLOSE TABLES ALL IF MessageBox("About to clear printer info from all reports in"+CHR(13)+CHR(13)+ ; ALLTRIM(CURDIR())+CHR(13)+CHR(13)+ ; "Go for it?",36,"Mass Report Update!") != 6 WAIT "Aborted." WINDOW TIMEOUT 1 set default to (lcOldDir) RETURN .F. ENDIF lcOldFont = _SCREEN.FontName _SCREEN.FontName = "Courier New" lnNamesOnLine = 0 * * Identify lines in FRX expr field to wipe out: * DIMENSION laLinesToWipe[3] laLinesToWipe[1] = "DRIVER=" laLinesToWipe[2] = "DEVICE=" laLinesToWipe[3] = "OUTPUT=" * * For each FRX file in the current directory: * lnFormCount = ADIR(laForms,"*.FRX") ASORT(laForms,1) FOR lnCurForm = 1 TO lnFormCount llNeedToCompile = .F. * * Open the form as a table: * USE (laForms[lnCurForm,1]) IN 77 SELECT 77 * * The first record has the printer info: * LOCATE IF !EMPTY(tag) OR !EMPTY(tag2) llNeedToCompile = .T. ENDIF * * Clear the tag fields: * REPLACE tag WITH "", ; tag2 WITH "" * * Remove the printer info from the expr field: * lnNumSettings = ALINES(laSettings,expr,.T.) lnLoop = 1 DO WHILE lnLoop <= lnNumSettings lnInc = 1 FOR EACH lcTargSetting IN laLinesToWipe IF lcTargSetting $ laSettings[lnLoop] llNeedToComile = .T. ADEL(laSettings,lnLoop) lnNumSettings = lnNumSettings - 1 lnInc = 0 ENDIF ENDFOR lnLoop = lnLoop + lnInc ENDDO lcNewExpr = "" FOR lnLoop = 1 TO lnNumSettings lcNewExpr = lcNewExpr+ALLTRIM(laSettings[lnLoop])+CHR(13)+CHR(10) ENDFOR REPLACE expr WITH lcNewExpr *MessageBox("Before: "+chr(13)+expr+chr(13)+chr(13)+"After: "+chr(13)+lcNewExpr) IF lnNamesOnLine < MAX_LINE_NAMES ?? PADR(ALLTRIM(laForms[lnCurForm,1])+IIF(llNeedToCompile,'*',''),NAME_WIDTH) ELSE ? PADR(ALLTRIM(laForms[lnCurForm,1])+IIF(llNeedToCompile,'*',''),NAME_WIDTH) lnNamesOnLine = 0 ENDIF lnNamesOnLine = lnNamesOnLine + 1 SELECT 77 USE * * Compile the FRX: * IF llNeedToCompile COMPILE REPORT (laForms[lnCurForm,1]) ENDIF ENDFOR set default to (lcOldDir) Marcel Jalbert seemed to utter in news:22Wi7.289588$v5.29128506@news1.rdc1.ct.home.com: - Hide quoted text - - Show quoted text - > I been working around a problem for years where a FoxPro report form > fails to print to the selected printer or to the Windows default > printer. Anyway to make a long story short, when I compose a report > form for a printer that exists on the Desktop or Server the application > always prints to that printer. I'm use VFP 6.0 sp4 and have seen this > problem on Windows 95 and NT desktops and VFP 5.0. By compose I mean; > Modify the Report, go to "Page Setup" select a printer, click OK and > save the report form. There appears to be some hard coding in the > report form that identifies the printer name the report form was > designed for. If this printer name exists this hard coding seems to > override the destination printer settings your application would > normally print to. There are a couple of ways I get around this > problem. > 1) Temporarily change the name of the printer you want to compose the > report form for, select the printer while editing the report from and > save it. Recompile your code and rename the printer back to it usually > name. You can't rename a printer with Windows NT. > 2) Variations on the same theme that works with Windows NT would be to > temporarily install a printer on the PC that the application will never > printer to. Compose the report form for that printer, save it, > recompile and delete the installed printer. > 3) Have multiple copies of your report forms. Each composed for the > printers you want the reports to go to. (Not a desirable solution) > Has anyone else seen this problem? Is it on a FoxPro bug list? Am I > doing somethink I shouldn't or is there a better work around? > Thanks! > Marcel -- Tag: Report data is wrong Tag: 222241

I am maintaining an older visual foxpro program that produces a report
that was working before I "fixed it". It now either prints a blank
page, a page with repeating first records or just the first record. I
have used reports with data environments, without and have changed it
sideways to Sunday, but when I preview the report, I see the correct
data and click the button to print and something happens to the data
and when the report appears it is wrong. Any suggestions would be
greatly apprieciated.

--
hondo
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Top

Re: Report data is wrong by Leonid

Leonid
Wed Apr 05 02:38:28 CDT 2006

This behaviour commonly occurs when focus stays in grid while previewing
report. If so, put

Thisform.AnyControlThatIsNotGrid.setfocus

before report command

Leonid

"hondo" <hondo.25rktw@mail.codecomments.com> wrote in message
news:hondo.25rktw@mail.codecomments.com...
>
> I am maintaining an older visual foxpro program that produces a report
> that was working before I "fixed it". It now either prints a blank
> page, a page with repeating first records or just the first record. I
> have used reports with data environments, without and have changed it
> sideways to Sunday, but when I preview the report, I see the correct
> data and click the button to print and something happens to the data
> and when the report appears it is wrong. Any suggestions would be
> greatly apprieciated.
>
>
>
> --
> hondo
> ------------------------------------------------------------------------
> Posted via http://www.codecomments.com
> ------------------------------------------------------------------------
>

Top