Report

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
    - Graph controls We are currently using MSGRAPH to present some simple graphs within our application. There have been some new requirements requested that are not available within MSGRAPH and hence we are looking for an alternative graph method. What graph controls are people using instead of MSGRAPH? the facilities we require are "mouse-awareness" so we can display the current value on a plot or some additional application data. We also would like to be able to provide 'graph templates' that define things like graph formats etc. We need to be able to support multiple axes. thanks pete Tag: Report Tag: 203531
  - 2
    - Error Creatin FORM I have created a form in one system. Later on the same form was modified on other system. After the complete modification. I form.sct & form.sct file on the previous system. When i am running the command do form uccmast i am getting the error message as 'error loading file - record no.174 < one of its members>.parent;class name is invalid' what could be the error. I have renstalled the VFP on previous system after completely deleting the vfp programme folder. After this only the error is occuring. I have done copying procedure earlier also, but have not got such type of errors. Tag: Report Tag: 203528
  - 3
    - DE bug? In the de of a form, I open a remote view with alias teacher1, and again with alias teacher2. In form.load is this code: SELECT teacher1 INDEX ON personid TAG personid SELECT teacher2 INDEX ON personid TAG personid The second INDEX statement gives the message "personid already exists, overwrite it?" This is a different cursor. I shouldn't get such a message. If I respond Yes, teacher2 is indexed and the index on teacher1 is removed! Is it me? This is VFP9 public beta. Tag: Report Tag: 203518
  - 4
    - How many indexes is too many? Reading some postings, they mention not to use to many indexes (gets buggy). One of our VFP6 tables has 85 fields and ~ 120,000 records and growing. We do a variety of queries on many fields. Currently we have 8 indexes and would like to add a few more. I was wondering what a safe # of indexes is without compromising anything.? Any input/experiences is appreciated. TIA Mike Tag: Report Tag: 203516
  - 5
    - list box bug ? Hi all vfp8, sp1 I have just run across what appears to be a bug and would like others to confirm it (maybe everybody already knows about this <g>) List box this.rowsourcetype = 5 this.rowsource = array (this.alist) 3 columns in array source this.columncount = 0 or 1 (only want 1 to show) this.boundto = .t. (only because it is our framework default) this.controlsource = [none] Result: the value of This.List[This.ListIndex,2] or [...,3] = the same value as [..., 1] !!! if I change the columncount to 3, all is OK (after finding this, I realized that in all the years I have been doing this since 3.0, I have never had more colunns than I have displayed or set width to 0) al Tag: Report Tag: 203510
  - 6
    - how does VFP9 use web services? How does VFP9 use web services? With the no longer supported Soap ToolKit or with something else, maybe from .NET? I can't find an answer from Ken Levi's letter, and from googling around. -- The answer to the ethernal question is: put a read events after the launch of the form Tag: Report Tag: 203509
  - 7
    - Mohamed Nour hi sir. how can i copy all these Discussions to my private inbox in microsoft outlook2003 Tag: Report Tag: 203504
  - 8
    - Current Record is modified I have looked in the help but can't seem to find if a function exists for this. I need to know if any fields in the current record has been modified. The closest I found is getfieldstate. This would mean I would have to loop through each field to see if it has been modified? Is this the only way to do it or is there another function that I can't find? Tag: Report Tag: 203502
  - 9
    - Update a table with values from a different table without SQL Apparently I make a basic mistake, but it isn't working the way I want. Why not and how to get it right? There are two (free) tables: Table ORIGIN with column: Key C(10) and Desc c(20) Table Destination with column: Destkey C(10) and Destdesc c(20) I want to scan through table ORIGIN get the value from column Desc and update column Destdesc in Destination. I thought this ought to do the trick, but it doesn't: **** Start PRG***** USE 'c:\temp\destination.dbf' ALIAS destination IN 0 SHARED USE 'c:\temp\origin.dbf' ALIAS origin IN 0 SHARED SCAN lcKey = origin.key lcDesc = origin.desc upd(lcKey,lcDesc) ENDSCAN Procedure upd PARAMETERS cKey, cWaarde LOCATE FOR destination.destkey = cKey IF FOUND() replace destination.destdesc WITH cWaarde ENDIF Endproc ****End PRG ******************************* Create script: Create table DESTINATION (destkey c(10), destdesc c(20)) create table ORIGIN (key c(10), desc c(20)) Insert into DESTINATION (destkey) values ('Een' ) Insert into DESTINATION (destkey) values ('Twee' ) Insert into ORIGIN (key, desc) values ('Een', 'Test1') Insert into ORIGIN (key, desc) values ('Twee', 'Test2') Tag: Report Tag: 203501
  - 10
    - anybody out there who uses Visual Foxpro on Progress (V9) data?? Hi, I hope there is someone that reads this and knows how to update data interactively using Visual Foxpro on data in a Progress (V9) database. I can read / report on the data, but updates fail. How did you set up the connection properties and the properties of the remote view? In the view designer, update criteria tab, I selected the key field and selected update all fields, selected "send SQL Updates" and left other options at their default values. It is a remote view on a single table. The connection's user id has enough authority to read, write and execute. But if I try to update a field in a record it does not change the record, any changes are lost and the original values remain. I am using the Progress SQL92 driver (03.60.0006) (MERANT 3.60 32-BIT). Perhaps it has something to do with the setup of the driver on the server, if so can anybody point me to documentation about how to set it up so updates are allowed?. Tag: Report Tag: 203497
  - 11
    - anybody out there who uses Visual Foxpro on Progress (V9) data?? Hi, I hope there is someone that reads this and knows how to update data interactively using Visual Foxpro on data in a Progress (V9) database. I can read / report on the data, but updates fail. How did you set up the connection properties and the properties of the remote view? In the view designer, update criteria tab, I selected the key field and selected update all fields, selected "send SQL Updates" and left other options at their default values. It is a remote view on a single table. The connection's user id has enough authority to read, write and execute. But if I try to update a field in a record it does not change the record, any changes are lost and the original values remain. I am using the Progress SQL92 driver (03.60.0006) (MERANT 3.60 32-BIT). Perhaps it has something to do with the setup of the driver on the server, if so can anybody point me to documentation about how to set it up so updates are allowed?. Tag: Report Tag: 203496
  - 12
    - Microsoft Listview SP6 Slow 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 Tag: Report Tag: 203484
  - 13
    - VFP9 release date Anyone know yet (for MSDN subscribers)? Tag: Report Tag: 203480
  - 14
    - 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: Report Tag: 203473
  - 15
    - 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: Report Tag: 203457
  - 16
    - 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: Report Tag: 203455
  - 17
    - 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: Report Tag: 203446
  - 18
    - 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: Report Tag: 203438
  - 19
    - 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: Report Tag: 203433
  - 20
    - 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: Report Tag: 203429
  - 21
    - =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: Report Tag: 203405
  - 22
    - 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: Report Tag: 203404
  - 23
    - 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: Report Tag: 203389
  - 24
    - 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: Report Tag: 203387
  - 25
    - 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: Report Tag: 203386
- Next
  - 1
    - 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: Report Tag: 203385
  - 2
    - 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: Report Tag: 203383
  - 3
    - 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: Report Tag: 203382
  - 4
    - 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: Report Tag: 203380
  - 5
    - 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: Report Tag: 203374
  - 6
    - 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: Report Tag: 203366
  - 7
    - 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: Report Tag: 203359
  - 8
    - 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: Report Tag: 203355
  - 9
    - 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: Report Tag: 203351
  - 10
    - 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: Report Tag: 203340
  - 11
    - 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: Report Tag: 203338
  - 12
    - 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: Report Tag: 203330
  - 13
    - 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: Report Tag: 203325
  - 14
    - 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: Report Tag: 203323
  - 15
    - 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: Report Tag: 203319
  - 16
    - 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: Report Tag: 203312
  - 17
    - 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: Report Tag: 203295
  - 18
    - 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: Report Tag: 203280
  - 19
    - 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: Report Tag: 203275
  - 20
    - 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: Report Tag: 203261
  - 21
    - 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: Report Tag: 203257
  - 22
    - 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: Report Tag: 203255
  - 23
    - 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: Report Tag: 203231
  - 24
    - 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: Report Tag: 203230
  - 25
    - 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: Report Tag: 203226

Dear sirs
Is there any way that I can create a full report at run time
where in my project, the user can choose the table he wants then clicks on a
button create Report
How can I do such a thing???

thanks
Mohammed

Re: Report by Gerben

Gerben
Sat Nov 27 11:59:49 CST 2004

It depends if you have a report that looks the same for each table, and it
depends whether you are using VFP 9 or not.

In version < 9 I can suggest you this:
If you want, you can build a FRX at runtime in the dir: C:\Program
Files\Microsoft Visual FoxPro 8\Tools\Filespec are the files with the specs
off a FRX.
Or if you have the same report for each table, just use a standard table
where you copy your data in. And print the report with that standard table.

Or take a look at VFP9 and find out whether that version meet your needs.

Hth,
Gerben Kessen
www.wantit.nl

"Mohammed Abdel-Razzak" <MohammedAbdelRazzak@discussions.microsoft.com>
wrote in message news:C271EA67-D59E-42B6-B938-41987F413349@microsoft.com...
> Dear sirs
> Is there any way that I can create a full report at run time
> where in my project, the user can choose the table he wants then clicks on
> a
> button create Report
> How can I do such a thing???
>
> thanks
> Mohammed

Re: Report by Dan

Dan
Mon Nov 29 11:35:49 CST 2004

You can issue CREATE REPORT or MODIFY REPORT at runtime.

Also see the help topic for CREATE REPORT - Quick report

Dan

Mohammed Abdel-Razzak wrote:
> Dear sirs
> Is there any way that I can create a full report at run time
> where in my project, the user can choose the table he wants then
> clicks on a button create Report
> How can I do such a thing???
>
> thanks
> Mohammed

Re: Report by Altman

Altman
Mon Nov 29 15:45:19 CST 2004

Otherwise check out stonefield. I believe they have a report creating
wizard that would allow the user to create a custom report at runtime with
alot of options.
http://www.stonefield.com/

"Mohammed Abdel-Razzak" <MohammedAbdelRazzak@discussions.microsoft.com>
wrote in message news:C271EA67-D59E-42B6-B938-41987F413349@microsoft.com...
> Dear sirs
> Is there any way that I can create a full report at run time
> where in my project, the user can choose the table he wants then clicks on
> a
> button create Report
> How can I do such a thing???
>
> thanks
> Mohammed