Microsoft Listview SP6 Slow

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
    - VFP9 release date Anyone know yet (for MSDN subscribers)? Tag: Microsoft Listview SP6 Slow Tag: 203480
  - 2
    - VFP developer needed for Cyprus if you need a JOB in a lovely sunny Island and you have a Visual Foxpro experience of at least 2 years pls apply We offer good salary for a contract of 18months email to info@powersoft.com.cy George Malekkos Managing Director __________________________________ www.powersoft.com.cy eXPerience the POWER of real SOFTware ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- Tag: Microsoft Listview SP6 Slow Tag: 203473
  - 3
    - Adding a sum of column on previous page in the first row of current page Hello guys: Now, this should be easy: I created an apps that already run for years in my client site. This morning he just called and asked me to add a sum of previous page in the top of each report. What he mean is something like this: suppose that the total_sales column for page 1 is US$ 540.50, then this amount must show up in the first line of page 2. The same goes in page 3 in which the first line is fill with the sum value of page1 and page2. Question: Is there any way that I could accomplish this in the report writer alone (by adding variable or whatever) without 'touching' the code that create the cursor (the cursor is used as a data source for the report). I want the upgrade to be as easy as possible. TIA, Willianto Tag: Microsoft Listview SP6 Slow Tag: 203457
  - 4
    - textbox and numbers Hi, I have an annoying default-textbox-behaviour when entering numbers in combination with clicking on the textbox before starting entering numbers. When "tabbing" into the textbox there are no problems because I set the textbox.format = "K" (=select whole) So the whole text is selected and when entering one or more number the selection gets "replaced" with the new values so far so good with the default behaviour. But when I enter into the textbox with a mouseclick then "problems" occurs. For example when the default value = 0 and the users clicks in the left side of the textbox. the textbox doesn't get selected and the 0 stays in the textbox ! when typing only one number (eg 2) the value becomes 20 ! when typing two number (eg 21) the value becomes ok = 21. when the default value is 123 and the user enter 21 the result becomes 211 ! (so while typing the default values moves to the right) when the users clicks in the right side of the textbox it is even worse ! Then the user can't even enter values in the textbox. it jumps right away to the next control. I've placed this (as a trial) in the textbox.click to be sure the textbox get selected : this.Selstart = 0 this.SelLength = LEN(TRANSFORM(this.Value)) but this start selecting from left to right ! so this is not a solution. and textbox.alignment = 2 (left) is also not a solution. So my question is how can I safely enter numbers into a textbox combined with first clicking on the textbox. (because it's a touchscreen) or without fooling around the cursor with the controlkeys. kind regards and thanks in advance christophe Tag: Microsoft Listview SP6 Slow Tag: 203455
  - 5
    - SQL, which items have certain refs and don't have certain other refs? Hello, I have a table storing bills of materials. I want to select all the products that contain certain items and don't contain certain other items. What is the best way? I tentatively guessed at using a HAVING clause but I was wrong. I think this leaves me with a nasty set of self joins or a less nasty set of sequential queries: CREATE CURSOR bom (item C(10), comp C(10)) INSERT INTO bom VALUES ("item1", "comp1") INSERT INTO bom VALUES ("item1", "comp2") INSERT INTO bom VALUES ("item1", "comp3") INSERT INTO bom VALUES ("item1", "comp4") INSERT INTO bom VALUES ("item1", "comp5") INSERT INTO bom VALUES ("item2", "comp1") INSERT INTO bom VALUES ("item2", "comp3") INSERT INTO bom VALUES ("item2", "comp4") INSERT INTO bom VALUES ("item2", "comp5") INSERT INTO bom VALUES ("item3", "comp1") INSERT INTO bom VALUES ("item3", "comp7") INSERT INTO bom VALUES ("item3", "comp8") INSERT INTO bom VALUES ("item3", "comp9") INSERT INTO bom VALUES ("item3", "comp10") INSERT INTO bom VALUES ("item3", "comp11") INSERT INTO bom VALUES ("item3", "comp15") I want all the items that contain, say, a ("comp1" or a "comp3") not a ("comp6" or a "comp7") and a "comp2" Any ideas? [it should just be "item1" in the above data] * this is the kind of thing I'd hoped would work but wasn't too surprised when it didn't: SELECT item FROM bom ; HAVING (comp="comp1" OR comp="comp3") ; AND !(comp="comp6" OR comp="comp7") ; AND comp="comp2" ; GROUP BY item In my actual data I have to test many more components present / not present than that example. I'm thinking a series of EXISTS and NOT EXISTS queries is going to be easiest at the moment. -- TIA Andrew Howell Tag: Microsoft Listview SP6 Slow Tag: 203446
  - 6
    - Pageframe Memory Variable I have designed a pageframe which has 3 pages. I am using the memvar for textbox,combox grid data on all the pages. I scatter the memvar & getting the pages refreshed as follows. thisform.pageframe1.page1.refresh thisform.pageframe1.page2.refresh thisform.pageframe1.page3.refresh. Upto this everthing is fine. But, I have written the routine in the cmdbutton 'SAVE' for saving the record in click procedure. Here i am checking some validations for the memvar which are checked. Only for page1 the check procedure are ok. But when trying to check the memvar of the second page it gives the error as 'Variable not foun'. I checked that field name exist & value is also shown, but m.filedname values are not found for complete 2nd page. If pageorder is 2 then memvar vvalues of the 1st pages are not found. I can not understand what is wrong. Thank u. Tag: Microsoft Listview SP6 Slow Tag: 203438
  - 7
    - vfp8 xml interface Where do we start with the VFP to XML and vice-versa issue. When I do an "xmltocursor" of a client Purchase Order it gives me some of the fields seperately and some grouped all together, requiring further parsing. Does anyone have a good reference site for this ? -- george markhauser Tag: Microsoft Listview SP6 Slow Tag: 203433
  - 8
    - Determining what causes a c5? C0000005 Does anyone know how to pinpoint what is causing a c5 (C0000005) error? We connect via ODBC to a Microsoft SQL Server database and approximately once out of a 300 queries produces a C0000005 The SQL Server is on a Windows 2003 Server, and the requesting application is running under a user account with Administrator rights in a Terminal Services setting. -- Thank You, Tag: Microsoft Listview SP6 Slow Tag: 203429
  - 9
    - =tableupdate(.F.) error I'm getting the following error on the =tableupdate(.F.) statement "Function requires row or table buffering mode" I checked in Help and it says that Version 8 will accomadate previous versions using (.F.) and (.T.). I'm converting from version 5 to version 8. Can anyone help? Thanks, Jim. Tag: Microsoft Listview SP6 Slow Tag: 203405
  - 10
    - FPW2.6, source not available I keep getting "source not available" in the trace window on a new project I'm working on. It is driving me nuts, I can't quite understand it but it seems to be affected by my default directory...... I have a directory: U:\foxpro\devlog This is where my tables are. I have another directory: U:\foxpro\projects\devlog This is where my source is. If I do this: SET DEFAULT TO u:\foxpro\devlog [open trace window, open program "u:\foxpro\projects\devlog\devlog.exe"] then any program I pick from the list of programs in the project tells me "source not available"] If I do this: SET DEFAULT TO u:\foxpro\projects\devlog then I can see the source in the trace window OK but of course it won't run because the tables aren't there. I've used this method in other directories for years. All of a sudden it's not working, any ideas why? -- TIA Andrew Howell Tag: Microsoft Listview SP6 Slow Tag: 203404
  - 11
    - Varchars rephrased I have more than 200 remote views that have varchar fields and have always dealt with the pain of padding the fields in order to get the right queries. Now, VFP9 supports varchars but unfortunately the view designer does not do the right conversion, it converts the varchars to char type not helping at all. If I use the SQL editor I can change the type from C to V but that would be a pain. DBSETPROP or coding some hack would help but that is not the question here. Is this a beta issue and will it be fixed in the final release? Tag: Microsoft Listview SP6 Slow Tag: 203389
  - 12
    - VFP7 weird error after ROLLBACK We have been getting error 1884 Uniqueness of index primarykey is violated in a very strange situation which we can't explain. Basically on saving a record we have code similar to this: ************************************************* BEGIN TRANSACTION IF thisform.beforesave() m.lSuccess = TableUpdate(.F.,.F.) &&successful update IF m.lSuccess m.lAfterSaveSuccess = thisform.aftersave() ENDIF ELSE m.lBeforeSaveSuccess = .f. ENDIF IF !m.lSuccess * Handle errors here endif IF !(m.lSuccess AND m.lAfterSaveSuccess AND m.lBeforeSaveSuccess) ROLLBACK ELSE END TRANSACTION ENDIF ***************************************************** Our beforesave method sometimes includes code that defaults some fields, asks the user some pre-save questions if necessary etc. Occasionally what happens is, if you answer No to a question in the beforesave method and then resave the record, we get this really odd Index violation error. I have discovered that removing the ROLLBACK if beforesave fails seems to stop this error happening. There is nothing to rollback after all, as the tableupdate has not yet been issued. But what I can't explain is why the error 1885 appears in this situation?????? I would have thought issuing a ROLLBACK when there is nothing to rollback would have just been ignored by VFP but it seems to be causing problems. Any ideas anyone? Thanks, Bernie Tag: Microsoft Listview SP6 Slow Tag: 203387
  - 13
    - Reference to table ALIAS gives error Hi All, Here is a piece of code that gives error: STORE path1 to srcpath STORE path2 to destpath USE (destpath) ALIAS destpathalias USE (srcpath) ALIAS srcpathalias GOTO top SCAN SELECT destpathalias INSERT INTO destpathalias (fld1,fld2,fld3) VALUES(1,345, srcpathalias.fld1) ENDSCAN The error occurs when the following statement is executed SELECT destpathalias The error description says that 'alias destpathalias is not found' Help is appreciated. Thanks. Tag: Microsoft Listview SP6 Slow Tag: 203386
  - 14
    - VFP8-SQL Baltic-Cyrillic Hi all, need advice how to put into one table two columns with Baltic and Cyrillic charset and print them in one report. MS SQL2000, VFP8, WinXP, Region-Lithuania I found how to enter russian text into VFP forms textbox. Changed textbox fontcharset property to 204-Cyrillic. But when browsing or printing i can't see correct characters. (Report font script properties are diabled) On SQL backend i see only abrakadabra text, but can manually enter right cyrillic text. Then on VFP backend i see only ??????????. Tag: Microsoft Listview SP6 Slow Tag: 203385
  - 15
    - Saving a file to a users desktop. Hi Guys, How do I export a file to a user's desktop, given I don't want to hardcode the path into my program. I can do this on Win98 easily: EXPORT TO c:\windows\desktop\aodbal.xls TYPE xls But I have a mixed network of unix, 98, XP and 2003 server machines, so how do I do this on a variety of platforms? (ignore unix <g>) I think I spent to long working on Unix and have definitely got left behind a bit!! Steve Tag: Microsoft Listview SP6 Slow Tag: 203383
  - 16
    - Problem with ImageList Hi everyone, I have a visual class with an ImageList on it. This class is further subclassed. When I use the subclass on a form and place images in the imagelist, the images do not get saved. The next time I MODI FORM..., the images are not set. Abhay Tag: Microsoft Listview SP6 Slow Tag: 203382
  - 17
    - VFP9 and docking forms Hi All, There is a nice feature in VFP9 that allows dock user-defined forms in main FoxPro window. The question is: is it possible to dock forms in user-defined top-level form? Janusz Czudek WORD Software www.wordsoft.com.pl Tag: Microsoft Listview SP6 Slow Tag: 203380
  - 18
    - view record no's can i see the record numbers of records which are currently in use. pls help me out i need the solution plslssssssssssssssssss rajesh Tag: Microsoft Listview SP6 Slow Tag: 203374
  - 19
    - mmc class I've got this far (which isn't very far at all) ox = createobject("MMC20.Application") ox.Document.SnapIns.Add("Computer Management") This unsurprisingly loads up the "Computer Management" MMC snap-in, but it's as far as I've got. What I want to do is check for certain open files at a set time before a backup (no problem), but also shut down any session which is holding the files open, which is where I can see some mileage in the MMC class. I only just found this, but was wondering if anyone else uses it, and where the docs are? Thanks, Neil Tag: Microsoft Listview SP6 Slow Tag: 203366
  - 20
    - Windows API Function Needed I am in need of a way to create several user accounts on a windows 2000 server using VFP and attach them to pre existing usergroups. This is for a terminal server where we have been doing the bad thing of having multiple users using the same logon to the server and have been having printing problems because of it. Ideal would be able to scan through our user table and create a logon for each one, attach it to a pre-determined group and set the password to blank and require that it be changed on first logon. Is it possible to do this from VFP on a server that we completely control (we have the admin password in other words and we own the server). Any help anyone can give us would be appreciated. -- Cy Welch Senior Programmer MetSYS Inc http://www.metsysinc.com Tag: Microsoft Listview SP6 Slow Tag: 203359
  - 21
    - any ideas on shell object Hi friends I am using shell object to run an application (which accepts 3 parameters).my code is ***** lc_runcmd = "vipeasyclaim.exe " + lc_runtype + " " + lc_key + " " + lc_woption lo_Shell = createobject("wscript.shell") if type("lo_Shell") = "O" * ---Object was created - Run the command--- QQwState = 4 &&7 && Run the Dos Command in a Minimised Window QQwait = 0 && 0 = NoWait, 1 = Wait lo_Shell.Run(lc_runCmd,QQwState,QQwait) wait clear else * Problem creating the object =messagebox("ERROR: Could not create an object to run the executable ") ENDIF ***** its works fine.sometimes one of these parameters can be empty.in this example say lckey is empty and when i run above code its taking only 1st parameters ignoring 2nd(which is empty) and 3rd param which has value. Any ideas on this please. Thanks -- cheers Tag: Microsoft Listview SP6 Slow Tag: 203355
  - 22
    - variable changes Hi Friends We've a public variable being used & updated different parts of the our app. i am wondering is there any comman place where wait window displaying varible whnever the value changes ?? I know i can insert watch (in Debug) on this variable which will open debug whenever value changes but wondering abv is possible. Thanks -- cheers Tag: Microsoft Listview SP6 Slow Tag: 203351
  - 23
    - getfile() Is there a way to start getfile() in a specific directory? I have users that have keep their data in different locations and I would like to start all of their getfile()'s in the directory that they choose. Thanks, Scott Tag: Microsoft Listview SP6 Slow Tag: 203340
  - 24
    - What column I have set up a popup menu when a user right-clicks a column header. Is there a way to trap which column was right-clicked? Thanks, Scott Tag: Microsoft Listview SP6 Slow Tag: 203338
  - 25
    - Report from a query Thank you for your responses about the date query.. it worked. New question: On the Query destination it says report. but when creating a report.. it only allows option to choose from a field. I want the report to run automatically from a query so the user can run their own reports. How can this be done? Thanks Tag: Microsoft Listview SP6 Slow Tag: 203330
- Next
  - 1
    - Varchars and VFP9 Even if we can define fields as varchars in our backends, VFP9 doesn't recognize (or at least doesn't convert them to varchar) in the view designer. You can do it manually in the SQL editor of the view designer changing the type C to V. Is this an ODBC problem more than a VFP9 issue? Are we getting new ODBC or OLEDB drivers with VFP9? Or is this just a beta issue and we should relax and wait for the final release? *using MS ODBC for Oracle driver* Tag: Microsoft Listview SP6 Slow Tag: 203325
  - 2
    - Office integration I've used the code [ol = CREATEOBJECT("OutLook.Application")] in several apps with no problem. However, one users machine gives me an error while other machines run the same code with no problem. All are XP and Office 2003. Understand that Office was reinstalled but gettitn same result. Outlook is selected in Explorer. Any idea where to look next? Tag: Microsoft Listview SP6 Slow Tag: 203323
  - 3
    - Memo Field Garbage Q. I have table that has garbage in some of the memo fields. I am trying to get rid of the messed up records. My problem is how do you scan through a memo field to find text like this?: ¶·ONXÄuuÿsú@¤3BÕØO>³2(Xl^X ä8I¡ (\iA¾Þ`!tðõÔ¦ø-º>I Your knowledge and kindness is greatly appreciated. Jonathan Morningstar Tag: Microsoft Listview SP6 Slow Tag: 203319
  - 4
    - How to convert this XML Hi everyone, Take a look at the following XML. This is a XML data retrieved from a web-site and requires a reader to parse. Is it not possible to convert this into a cursor in Foxpro? Abhay <?xml version="1.0" ?> - <rss version="0.91"> - <channel> <title>rediff.com</title> <link>http://www.rediff.com/</link> <description>India's largest news and entertainment service online.</description> <language>en-us</language> <pubDate>Tue, 23 Nov 2004 13:03:39 GMT</pubDate> <copyright>Copyright: (C) 2004 Rediff.com India Limited. All Rights Reserved.</copyright> + <image> <title>rediff.com</title> <url>http://www.rediff.com/uim/red_log.gif</url> <link>http://rediff.com/</link> <width>144</width> <height>28</height> <description>Visit rediff.com</description> </image> - <item> <title>I am the final authority: Mukesh Ambani</title> <link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/money /2004/nov/23ril1.htm</link> <description>'There is no ambiguity in Dhirubhai's legacy that the chairman and managing director is the final authority on all matters concerning Reliance," he said in an e-mail to RIL employees.</description> </item> + <item> <title>How to qualify for home loan</title> <link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/getah ead/2004/nov/23home.htm</link> <description>They know what they want. Do you know what they want? Read on to figure that out.</description> </item> + <item> <title>Bomb scare at Patna airport</title> <link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/ 2004/nov/23patna.htm</link> <description>When reports last came in, the passengers had been offloaded and the plane was being searched.</description> </item> + <item> <title>Test heads for a tame draw</title> <link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/crick et/2004/nov/23india.htm</link> <description>Virender Sehwag's 164 was the high point on a dull fourth day in the first Test against South Africa.</description> </item> + <item> <title>India 401-4</title> <link>http://www.rediff.com/rss/redirect.php?url=http://livechat.rediff.com/ score/in_match990.html</link> <description /> </item> + <item> <title>Maria: Life is about changing diapers</title> <link>http://www.rediff.com/rss/redirect.php?url=http://specials.rediff.com/ getahead/2004/nov/23sld.htm</link> <description /> </item> + <item> <title>Pak PM in Delhi</title> <link>http://www.rediff.com/rss/redirect.php?url=http://www.rediff.com/news/ 2004/nov/23aziz.htm</link> <description>Earlier, the Pakistan Premier told reporters in Colombo that he expected substantive dialogue on all bilateral relations, including the issue of Jammu and Kashmir, in his talks with Prime Minister Manmohan Singh Wednesday.</description> </item> </channel> </rss> Tag: Microsoft Listview SP6 Slow Tag: 203312
  - 5
    - Purchase 8.0 or want for 9.0? Hi, I am wanting to start developing in Visual FoxPro. If I buy version 8.0 now do I get a discount on 9.0? Is version 9 coming out like real soon? I don't want to purchase 8.0 for $649 and in 1 month have to shell out another $349 to get 9.0. Tag: Microsoft Listview SP6 Slow Tag: 203295
  - 6
    - FP views vs. SQL views When accessing SQL Server data, is it better to create a view in the sql database and access it from FoxPro, or to use a FoxPro (remote) view (or perhaps sql passthrough) to access the sql tables directly? And why? What are advantages and disadvantages of each method? -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - 2 0 0 4 at y a h 00 Tag: Microsoft Listview SP6 Slow Tag: 203280
  - 7
    - SQL datetime to VFP Date Hi All, I am trying first time to connect SQL server database with VFP application through SQLCONNECT,SQLEXEC and etc... One of my table on SQL server has datetime fields and I want only date part from datetime value. I know I can use TTOD function of VFP after getting result from SQLEXEC(). But is there anyway I can directly get only date part? Thanks. Tag: Microsoft Listview SP6 Slow Tag: 203275
  - 8
    - Query with dates I am trying to create a query with if the name of the person is blank or if the date field is blank return only those values. The date field does not work if I choose if null, if blank, if empty.. due to it showing / / how can I do this ? Thanks Tag: Microsoft Listview SP6 Slow Tag: 203261
  - 9
    - SQL from buffered table does not contain recent updates I ran into a situation where the code was running a query against a buffered table that had been recently updated, but the cursor did not have the current changes in it. It was doing something like this: * Make sure table is buffered REPLACE <field> with <newvalue> SELECT * FROM <table> into cursor <mycursor> At this point, mycursor shows the old value, not the new value we just put into the table. The solution was to tableupdate() before running the query. Is there any other way around this? Tag: Microsoft Listview SP6 Slow Tag: 203257
  - 10
    - List all views being used by forms Hello, Is there a tool available that can print out all of the views that are being used by all forms in the project? E.g. a list broken down by form name that shows all views in that form's data environment. Thanks! Tag: Microsoft Listview SP6 Slow Tag: 203255
  - 11
    - Problem with code not running in IDE Hi Guys, I have a simple program that does not run/debug in the IDE but will run when compiled. It appears to stop on a read events at a "read events" at the top of a command1.click event and the program gets no further and will not debug either. If I compile it - no problem!! The form prompts for two values Tper (1-12) & Tyear 2004-xxxx and has two check boxes to set filters further down. The data is from Pegasus Opera II sales ledger. I have pasted code for the command button click event below. Thanks Steve ** code start aod = age of debt READ EVENTS && WILL NOT RUN IN IDE or DEBUG PAST HERE!!!!!!! *** Retrieve required AOD info into a local temporary dbase CLOSE ALL SET DATE BRITISH SET SAFETY Off DELETE FILE c:\tmp\aodbal.dbf PUBLIC Tyear,Tper Tyear=VAL(thisform.tyEAR.Value) Tper =VAL(thisform.tper.Value) OPEN DATABASE G:\OPERAI~1\data\Comp_F.DBC SHARED USE sname IN 0 SHARED SELECT ; sn_account as accno , ; sn_name as name , ; sn_teleno as phone , ; sn_custype as custype , ; sn_currbal as bal ; FROM sname WHERE sn_currbal > 0 INTO TABLE c:\tmp\aodbal.dbf ORDER BY accno ** Set up ageing columns ALTER TABLE c:\tmp\aodbal.dbf ADD COLUMN current n(10,2) ALTER TABLE c:\tmp\aodbal.dbf ADD COLUMN plus1 n(10,2) ALTER TABLE c:\tmp\aodbal.dbf ADD COLUMN plus2 n(10,2) ALTER TABLE c:\tmp\aodbal.dbf ADD COLUMN plus3 n(10,2) ALTER TABLE c:\tmp\aodbal.dbf ADD COLUMN plus4 n(10,2) ALTER TABLE c:\tmp\aodbal.dbf ADD COLUMN older n(10,2) **************************************************************** **************************************************************** ** Extract Transactions USE stran IN 0 SHARED SELECT ; st_account as accno , ; MONTH(st_trdate) as mnth , ; YEAR(st_trdate) as yr , ; st_trdate as Idate , ; st_trvalue as value ; from stran where st_paid = " " into table c:\tmp\aodtran.dbf CLOSE ALL **************************************************************** **************************************************************** ** Summarize Transactions programatically as I can't ** work out how to use sql SELECT 1 USE c:\tmp\aodbal EXCLUSIVE INDEX ON accno TO c:\tmp\aodtmp1 SET INDEX TO c:\tmp\aodtmp1 SELECT 2 USE c:\tmp\aodtran EXCLUSIVE INDEX ON accno TO c:\tmp\aodtmp2 SET INDEX TO c:\tmp\aodtmp2 public Tcurr,tper1,tper2,tper3,tper4,tper5 Tcurr=DATETIME(Tyear, Tper+1, 1)-1 Tper1=DATETIME(Tyear, Tper+0, 1)-1 Tper2=DATETIME(Tyear, Tper-1, 1)-1 Tper3=DATETIME(Tyear, Tper-2, 1)-1 Tper4=DATETIME(Tyear, Tper-3, 1)-1 Tper5=DATETIME(Tyear, Tper-4, 1)-1 DO WHILE .not. EOF() ************* SELECT aodbal ************* Tacc1=accno Tacc2=accno ************** SELECT aodtran ************** find &Tacc1 DO WHILE Tacc1=Tacc2 DO case **Current CASE Idate > Tper1 replace aodbal->current WITH aodbal->current+aodtran->value **Plus1 CASE Idate > Tper2 .and. Idate < Tper1 replace aodbal->plus1 WITH aodbal->plus1+aodtran->value **Plus2 CASE Idate > Tper3 .and. Idate < Tper2 replace aodbal->plus2 WITH aodbal->plus2+aodtran->value **Plus3 CASE Idate > Tper4 .and. Idate < Tper3 replace aodbal->plus3 WITH aodbal->plus3+aodtran->value **Plus4 CASE Idate > Tper5 .and. Idate < Tper4 replace aodbal->plus4 WITH aodbal->plus4+aodtran->value OTHERWISE replace aodbal->older WITH aodbal->older+aodtran->value ENDCASE SKIP Tacc2=accno ENDDO ************* SELECT aodbal ************* skip ENDDO SELECT 1 ** Filters based on checkbox 1 & 2 DO case CASE thisform.check1.Value=1 SET FILTER TO custype<>"ZLQ" CASE thisform.check2.Value=1 SET FILTER TO custype="HOM" ENDCASE GO top EXPORT TO c:\tmp\aodbal.xls TYPE xls CLOSE ALL quit Tag: Microsoft Listview SP6 Slow Tag: 203231
  - 12
    - prevent grid scrolling ? Hi, I have a grid of which the height is just heigh enough to show all the records of a cursor. What I want to obtain is, when the user is moving down to the last record and beyond the grid scrolls one row up so that the first record can't be seen anymore. (see simple example below, to show what I'm trying to say...) Can this scrolling of one line when it's not at all necessary be somehow disabled because all rows ARE shown ? kind regards christophe Create Cursor test (naam C(10)) Insert Into test (naam) Values ("naam1") Insert Into test (naam) Values ("naam2") Insert Into test (naam) Values ("naam3") Go Top In "test" frmTest = Createobject('Form') frmTest.TitleBar = 0 frmTest.Width = 100 frmTest.AddObject('gridTest', 'mygrid') frmtest.gridtest.column1.width = 100 frmtest.gridtest.visible = .t. frmTest.show() READ events Define Class mygrid As Grid Left = 1 Top = 1 Width =100 AllowAddNew = .F. AllowHeaderSizing = .F. AllowCellSelection = .T. ColumnCount = 1 DeleteMark = .F. HeaderHeight = 0 RecordMark = .F. RecordSourceType = 1 RecordSource = "test" ScrollBars = 0 Procedure Init hoogte = Thisform.gridtest.RowHeight * Reccount("test") +2 Thisform.Height = hoogte +2 Thisform.gridtest.Height = hoogte This.SetFocus Enddefine Tag: Microsoft Listview SP6 Slow Tag: 203230
  - 13
    - Word Automation from VFP7 Hi, I've managed to open word up with automation. How to I gain access to the file menu to I can disable the 'Save As' for example TIA Rob Tag: Microsoft Listview SP6 Slow Tag: 203226
  - 14
    - SQL VIEW Hi, Can SQL VIEW be created on a free table? Thanks Tag: Microsoft Listview SP6 Slow Tag: 203225
  - 15
    - Problem using MAPI Hi everyone, Here is my problem: I have a software that sends eMails using MAPI. That means, whenever I send mails, they get deposited in the Outbox of Outlook Express. However, the MAPI code does not work in 2000 and XP, inspite of me downloading and Installing WMS.EXE and gives an error on the following code : o=CREATEOBJECT("MSMAPI.MAPISESSION") ....Class is not licensed for use. Can you help? Thanks in advance Tag: Microsoft Listview SP6 Slow Tag: 203222
  - 16
    - crystal reports We want to use crystal reports so that all the reports are generated at the server then transferred to the client for viewing rather than being generated by the client. Looking at the versions it would appear we need the full developer edition (Advanced) to accomplish this. Our clients need to be able to access the report via LAN or internet but in either case the work should be done at the server. We have thought about generating the reports on the server with saved data then transfering them as any other file to the client for viewing. At the moment we are fetching the data we need from the server and using .rpt files to view the data. Ideally we would like to reuse the .rpt files we already have. Does anyone have any experience of using crystal reports in this way, any help would be appreciated. We are using VFP 8 data with vfpoledb Thanks in advance Dave Tag: Microsoft Listview SP6 Slow Tag: 203219
  - 17
    - using a table Dear sirs In my application I create a form at run time, whcih takes a parameter that holds a table name as follows DEFINE CLASS MyForm AS FORM PROCEDURE INIT PARAMETERS mTable THISFORM.ADDPROPERTY('tbl') THISFORM.tbl = mTable IF !USED(ALLTRIM(THISFORM.tbl)) USE (THISFORM.tbl) AGAIN ENDIF SELECT (ALLTRIM(THISFORM.tbl)) GO TOP SCATTER MEMVAR MEMO THISFORM.REFRESH ENDPROC ENDDEFINE I don't know why when I run it it open an Open Dialog Box to choose a table from it to open ?!!!! in the same form also I create buttons to AddNew records and Save records also it gives the same error with them !!!! *** The save button Click PROCEDURE cmdSave.CLICK SELECT (ALLTRIM(THISFORM.tbl)) APPEND BLANK GATHER MEMVAR MEMO FLUSH THISFORM.REFRESH ENDPROC that was my problem thanks Mohammed Tag: Microsoft Listview SP6 Slow Tag: 203218
  - 18
    - How to get a formatted text to a VFP variable. Hi all, I found this problem while dealing with some text with formatting. This text had some bold, italic..etc text which I took from WORD. When I get this text to a VFP variable the formatting was missing! Is this a known issue in VFP or is there a work around for this? Thanking in advance. Nadee. Tag: Microsoft Listview SP6 Slow Tag: 203203
  - 19
    - Volume Control Hello !!! Can anyone help me how to control the audio volume from VFP ??? I've already tried the multimedia FFC, but it does not control the volume. Thanks Tag: Microsoft Listview SP6 Slow Tag: 203198
  - 20
    - Controlling images Hello ! Can someone recommend to me a free ocx or an Api to control some images? I need to manipulate many pictures at a time, for publishing on a web site. I need some basic functions, like : add some text in the bottom and resize. Thanks !!! Cesar Chalom Tag: Microsoft Listview SP6 Slow Tag: 203197
  - 21
    - I found this great little site I found this great little site. I signed up two weeks ago and got 2 Disney tickets and this week they are sending me 2 Universal Studios tickets. Here's the link http://66.219.102.40/ and by the way I am a real person, this is my real email address. I'm not a spammer and didn't appreciate the nasty email I got last time I tried to post this link. Thanks, Lisa http://66.219.102.40/ http://66.219.102.40/ Tag: Microsoft Listview SP6 Slow Tag: 203196
  - 22
    - ATT: Villi Bernaroli and Jan Bucek Jan and Villi, This continues my previous thread "Downloading Zip file from Internet" Are there any SPECIAL system requirements for your API functions in the compiled Executable to work on a machine where VFP is not installed. My Exe is working fine on machines where VFP is not installed. I wanted to know are there any special requirements for your routines or just existance of IE will do. I already install routine runtimes like VFP DLLs etc. via the InstallShield installation. Regards S Bans Tag: Microsoft Listview SP6 Slow Tag: 203189
  - 23
    - Suggest Beginners Book? Someone would like me to teach them FoxPro. They don't know much or anything about programming. Can anyone suggest a good beginners book in FoxPro? Thanks Tag: Microsoft Listview SP6 Slow Tag: 203187
  - 24
    - sendmail attachments Group, I'm using sendmail, found in solutions, to send emails from vfp 6. Is it possible to also send an attachment using this example code? Thanks, Wade Tag: Microsoft Listview SP6 Slow Tag: 203185
  - 25
    - Looping through cursor records Hi, The following update is failing; and the loop is executed only once instead of 3 times! SELECT TOP 3 col1,col2 FROM testtab order by colno INTO CURSOR testcursor READWRITE SELECT testcursor SCAN INSERT INTO testtab2(col1) VALUES(testcursor.col1) UPDATE testcursor SET col2 = 'abc' ENDSCAN Help is appreciated. Thanks. Tag: Microsoft Listview SP6 Slow Tag: 203169

Hi

I am using a microsoft listview to display 1 million items. What is the
quickest way in foxpro?
I need to use listview sp6 because it supports icons. ie file list is what
im trying to create......

Thanks Glenn

Top

Re: Microsoft Listview SP6 Slow by Jack

Jack
Thu Nov 25 23:32:11 CST 2004

On Fri, 26 Nov 2004 16:57:22 +1300, "Glenn Aitchison"
<glenn@nospam.com> wrote:

>Hi
>
>I am using a microsoft listview to display 1 million items. What is the
>quickest way in foxpro?
>I need to use listview sp6 because it supports icons. ie file list is what
>im trying to create......

I have not used the listview control very much, but the treeview is
immensely speeded up when adding and removing large numbers of items
by setting the control's Visible property to .F.

Top