Data Sort Using Grid Control

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
    - Chinese Unicode I have a VFP 5 application using the Stephen Black translation stuff. We need to produce it in Chinese. Is this possible? If so, what do I have to do? Thanks, -- Andrew R. Tag: Data Sort Using Grid Control Tag: 201903
  - 2
    - Documenting all posts and replies Good day! is there a way for us to save all of these posts and questions in my local pc? i have a palm tungsten w and i would like to read all of the items posted here during most of my free time, i'm new in vfp and i would like to get as many information as i can get to be as proficient as you guys. i am using an acrobat reader for my handheld for this. a million thanks! yong Tag: Data Sort Using Grid Control Tag: 201901
  - 3
    - problem using CDO to send email I want to send emails from foxpro (using VFP 6.0, XP svc pack 2) and am trying to use CDO. I understand that all I need to do is configure Outlook express, then run the following code: oMSG = createobject("CDO.Message") oMsg.to = 'f7test@hotmail.com' oMsg.From = 'Bill@MarathonSoftware.com' oMSG.Subject = "Testing CDO email" oMsg.TextBody = "hello world" omsg.Send() I get the error: OLE IDispatch exception code 0 from ?; The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available. The code's simple, so my tendancy is to look at my SMTP configuration. But that seems fine, and I can send emails using outlook express. I've tried turning off firewalls, I've tried using a Win2000 computer, I've added statements to query the configuration. I'm not finding the cause to the problem. (My info on CDO comes from the book "Megafox: 1002 things...." and the foxpro Wikki.) I'm running this from a .prg. Any ideas, anyone? Thanks, Bill Freeburg Tag: Data Sort Using Grid Control Tag: 201894
  - 4
    - InstallShield and VFP8 I'm having 2 problems when trying to install an application that was created with InstallShield that came with VFP 8. First my disk will not auto run on any computer. This is acceptable as the user can click on setup.exe from the CD. Second, when the application is ready to install, installShield claims there is not enough diskspace. However, there is more than 10 gigs free on any test computer. The application to install is only 7mb. Any ideas, THanks, John. Tag: Data Sort Using Grid Control Tag: 201892
  - 5
    - Web Development Hi All, I've been using most versions of Fox since v2.6. The time has come however when more and more of our clients want their applications to be used on the web. I've therefore been given the task of finding the most appropriate web development language to enable us to start converting (or re-writing as the case may be) one of our client's applications. The aim of this particular app is to enable the client's customers to log onto a web site, enter some data and for the app to give them back some data in return. It's an estimating app so the kind of of data being requested would be materials to be used, requested time scales etc, most fields should be lookup fields. The data given back would be estimated price, confirmation of availability etc. The data should then be posted to the backend database, at the moment VFP or possibly SQL Server (of which we have about 12 months experience with). There seems to be so many languages out there capable of doing this that we don't know where to begin. We have absolutely no experience of any web development languages whatsoever, but we are prepared to learn. We don't mind a steep learning curve as long as we retain the majority of control (not keen on wizard driven languages that work well as long as something doesn't go wrong). Any recommendations or hint and tips greatly appreciated. Thanks in advance. jlp Tag: Data Sort Using Grid Control Tag: 201891
  - 6
    - UNC links in email.. Probably not the best place to ask this question but I'm working on something that does a load of stuff silently but records its actions to a logfile table. When processing has finished I'm sending a plain text email with a message to the users. I was going to put a link in the email to my log viewer so they could just click to see the log. With this in mind I made the viewer take a command line parameter for the log id; so the message would look something like this. Dearest users, the automatic processing has finished; please view the log here: \\server\share\directory\myfoxprog.exe id_for_logfile_records_to_view The problem; as demonstrated above (if you have a newsgroup reader such as outlook express..) is that I cannot place a space in the command. I crossed my fingers and tried putting %20 in place of the space but it's not a HTTP URL and so it didn't work. My next thought was that I can write a batch file nd attach it which can handle having a space in it but it's not quite so neat. Can I do this with a "pretty blue text" link or is the batch file the best route? -- TIA Andrew Howell Tag: Data Sort Using Grid Control Tag: 201883
  - 7
    - report form / more than one page I need print a report containing 3 pages, keeping the order. I am using the procedure : use arq DO WHILE .NOT.EOF() REPORT FORM REPO1 NEXT 1 TO PRINT NOCONSOLE NOWAIT REPORT FORM REPO2 NEXT 1 TO PRINT NOCONSOLE NOWAIT REPORT FORM REPO3 NEXT 1 TO PRINT NOCONSOLE NOWAIT skip ENDDO but I ' d like to simplify that, printing these 3 pages in order VFP6 SP5 windows ALL alberto Tag: Data Sort Using Grid Control Tag: 201874
  - 8
    - Bespoke COM version Any advice please. I am developing a collection of COM objects to provide an interface to a commercially available accounting software product. I have a customer who has a bespoke version of this accounting software. I therefore need to provide a bespoke version of the COM objects for this customer but ideally I don't want to maintain a completely separate set of code. Any ideas how I can do this? The customer is using VBA in MS Access to instantiate my COM objects. -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.opera-ii.com/pegasus-opera-ii/pegasus-opera-ii.php Tag: Data Sort Using Grid Control Tag: 201868
  - 9
    - table upation problem in some systems I think somebody can give solution to the following problem in vfp 7 version, it would be very tankful. I am facing a severe problem, that in some of my clients systems some records are missing or not updating properly. for example, if I have 3 tables to be updated in a Transactions, one of the table found not updated. the records Ã§an be find updated before 'End Transactions'. but after the 'End Transactions' Records are vanished(the records which is inserted or appened this session) it is not showing any error messages even i put error handling functions. After running reindex or regenerate database records(new records not vanished) are update properly for sometimes. but the same problem repeats after sometimes It is happening only in some systems. Suppose, if it is a index problem how can i check secondly how i can check database/index file integrity before updating records. following commands are given for updation *************************** begin transactions program detail-------- if !Tableupdate(1,.t.,'invoice') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif if !Tableupdate(2,.t.,'invTrans') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif if !Tableupdate(2,.t.,'LedgerTransactions') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif && after table updation we can find the records thro' seek / locate / brows end transactions select invoice if !eof() skip else skip -1 endif && but here records are missed (not in all, but in one table the records which inserted in last transactions ) ************************** sam Expand AllCollapse All Manage Your Profile |Legal |Contact Us |MSDN Flash Newsletter Tag: Data Sort Using Grid Control Tag: 201866
  - 10
    - shortcut Menu Dear sirs I' ve made a program to create a shortcut menu as follows DEFINE POPUP myMenu SHORTCUT RELATIVE FROM MROW(),MCOL() DEFINE BAR 1 OF myMenu PROMPT "Background" DEFINE BAR 2 OF myMenu PROMPT "Edit table" ON BAR 1 OF myMenu ACTIVATE POPUP Background DEFINE POPUP Background SHORTCUT RELATIVE DEFINE BAR 1 OF Background PROMPT "Color" DEFINE BAR 2 OF Background PROMPT "Image" ON SELECTION BAR 1 OF Background ; DO bar_color_click ON SELECTION BAR 2 OF Background ; DO bar_image_click ACTIVATE POPUP myMenu PROCEDURE bar_color_click IF TYPE("m.oRef") = "O" m.cColor = GETCOLOR() IF m.cColor < 0 RETURN ENDIF oRef.BACKCOLOR = m.cColor ENDIF PROCEDURE bar_image_click MESSAGEBOX('two') and then I 've call this program in my form I want the user to be able to change the form backColor when he choose Color bar from the shortcut menu the last code didn`t work with me ??!! I want to know how can I make that thanks Mohammed Tag: Data Sort Using Grid Control Tag: 201864
  - 11
    - Rencontres AtoutFox Bonjour, Les rencontres AtoutFox 2004 se dérouleront les 11 - 12 - 13 novembre 2004 au Hilton Paris-la Défense. Programme des rencontres Cette année les rencontres seront articulées autour de Grands Thèmes: a.. Approfondir sa connaissance et sa pratique de Visual FoxPro, particulièrement ses dernières versions et ses nombreux outils tiers b.. Un nouveau thème qui nous paraît particulièrement important pour bonifier l'image de FoxPro auprès des décideurs informatiques : promouvoir Visual FoxPro et ses applications francophones c.. En prolongement des rencontres de Strasbourg (nov. 2003) et Namur (juin 2004) : améliorer l'efficacité - donc la compétitivité - des professionnels FoxPro en partageant et réutilisant facilement le code existant d.. Enfin, le meilleur pour la fin, une rencontre exceptionnelle avec les Représentants de Microsoft Corp., Europe et France et non des moindres puisque ... Ken Levy, MS Corp. VS Data Product Manager, nous présentera VFP9 au cours d'une keynote session d'1h30 en traduction française simultanée !! Ces rencontres se clôtureront par la première Assemblée Générale de l'association AtoutFox où nous établirons le calendrier d'actions et le budget pour 2005, et nous élirons le bureau. Téléchargez le programme détaillé des Rencontres en cliquant ici : http://www.atoutfox.org Pour le bureau, AtoutFoxement, Thierry Nivelet Communauté Francophone des Professionnels FoxPro http://www.atoutfox.org/ news://news.AtoutFox.com/AtoutFox.association Tag: Data Sort Using Grid Control Tag: 201863
  - 12
    - Foxuser.dbf disable hi sir. how can i disable files ( Foxuser.dbf , Foxuser.fpt ) created automatically when run exe file of vfoxpro? i.e. i use vfoxpro0.8 thanks mohamed Tag: Data Sort Using Grid Control Tag: 201857
  - 13
    - logo screen startup hi sir. is there any way to appear logo of my company when my application startup? as when i open vfoxpro the logo appear i.e. i use vfoxpro0.8 regards mohamed Tag: Data Sort Using Grid Control Tag: 201855
  - 14
    - Append general problem WinXPPro SP2 VFP8 SP1 Create cursor curImage (gImage G) select curImage append general from f:\images\saturn.jpg I create report with picture control. I selected 'picture from field' option with 'curImage.gImage' as a source. Instead of picture I get text 'saturn.jpg' on report. When I browse curImage I also have text 'saturn.jpg' in field. I must double click on text to see picture. I usually use 'picture from file' option for these tasks but in this case I must use append general option (Customer request. Don't ask why.) What is wrong here? Tag: Data Sort Using Grid Control Tag: 201854
  - 15
    - how to copy a View from one DBC to a second DBC Hi, somebody knows how to copy a local view from one DBC to a nother one? I have to do it programatically because enduser has been enambled to change the view on the first DBC and I need to make sure that the second one is identical up to date I have tried copying the corresponding records from the DBC using the following code use (rutadest+"\aedb.dbc") append from (rutaorig+"\aedb.dbc") for objectname = "vcalif " set filter to objectname = "vcalif " go top wobjectid = objectid set filter to append from (rutaorig+"\aedb.dbc") for parentid = wobjectid use However, when I try to open the database I get an error message " database is corrupted and this can not be fixed using validate database command I also tried changing the objecid of the view with a very big number (to avoid duplicates) but it did not fix the trouble select 0 use (rutadest+"\aedb.dbc") append from (rutaorig+"\aedb.dbc") for objectname = "vcalif " set filter to objectname = "vcalif " replace objectid with 999999 go top wobjectid = objectid set filter to append from (rutaorig+"\aedb.dbc") for parentid = wobjectid use I really would appreciate any help Oscar Taboada Tag: Data Sort Using Grid Control Tag: 201852
  - 16
    - COM issues I have a main application (C++) which calls a VFP 7/8/9 COM server. The Foxpro server also needs to communicate with the calling application in order to: - read properties - use functions in the main application - send back status information - send back progress information The main application will probably be multi-threaded, so properties in the main application can change while a Foxpro function is active. What would be the best way to do this? Zeke Tag: Data Sort Using Grid Control Tag: 201851
  - 17
    - Procedures and Functions In a Class Good day! I've been creating classes to simplify the coding in my projects, i was surprised that procedures and functions are not allowed in classes? howcome? is there alternative ways to implement this? classes are great for the debugging of codes are contained within the class itself. what is the new procedure if to place a procedure or function within a class? please help, thank you and more power... yong Tag: Data Sort Using Grid Control Tag: 201847
  - 18
    - About Resource Files good day! i have been a foxpro2.5 programmer for a very long time now, about 9 years, im now into vfp, and would like to apply all of my theories to this new programming platform, or at least if not that do-able, may find other ways using the same language, stretching it out.... as i read on books on the language, would somebody please tell me the advantages of using Resource files... i've read some info's on this feature but i cant get a clearer picture on using it at it's fullest functionality, when and where to tap its use... hope experts could help me, a million thanks! yong Tag: Data Sort Using Grid Control Tag: 201846
  - 19
    - tables are not updating properly if anybody can give solution to the following problem in vfp 7 version, it would be very tankful. I am facing a severe problem, that sometimes in some of my client's systems, records are missing or not updating properly . for example, if I want to update 3 files (1. 'invoice' a header file, 2. 'invTrans' a detail file 3.'LedgerTransactions' a transacton file) in a begin-end Transactions, one of the above files may roll back or not updated. It is sure that the records are writting properly and Ã§an be seen thro' brows command before 'End Transactions' command. But after the 'End Transactions' command, it is found that one of the file is not updated with records. It is not showing any error messages even i put error handling functions. this phenomina showing sometimes only. it starts saving after rebuild index or recreate database. Few days later it happens again. In other systems database updating properly. secondly how i can check database/index file integrity. the following command are given for updation *************************** bigin transactions program code ------l if !Tableupdate(1,.t.,'invoice') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif if !Tableupdate(2,.t.,'invTrans') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif if !Tableupdate(2,.t.,'LedgerTransactions') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif endtransactions select invoice if !eof() skip else skip -1 endif ************************** Tag: Data Sort Using Grid Control Tag: 201838
  - 20
    - MRP resources? Hi all, A new client has just asked me to create an MRP application for his manufacturing company. Any idea where I can find MRP resource? Better yet, anybody where can I find an evaluation software to give me some idea? TIA, Willianto Tag: Data Sort Using Grid Control Tag: 201834
  - 21
    - Combo box Dear sirs Is there any way makes me don`t let the user at run time not to change in the values of the combo box ( edit , or write in the combo box) thanks Mohammed Tag: Data Sort Using Grid Control Tag: 201830
  - 22
    - records are not updating in some systems if anybody can give solution to the following problem in vfp 7 version, it would be very tankful. I am facing a severe problem, that in some of my clients systems some records are missing or not updating properly. for example, if I have 3 files to be updated in a Transactios, one of the file is not updating. the records Ã§an be find updated before 'End Transactions'. but after the 'End Transacton' Records are not updated it is not showing any error messages even i put error handling functions. But the fact, which is updating properly in some other system. secondly how i can check database/index file integrity. the following command are given for updation *************************** bigin transactions detail if Tableupdate(1,.t.,'invoice') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif if Tableupdate(2,.t.,'invTrans') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif if Tableupdate(2,.t.,'LedgerTransactions') rollback =messabox('') thisform.txtinvoiceno.setfocus() return endif endtransactions select invoice if !eof() skip else skip -1 endif ************************** Tag: Data Sort Using Grid Control Tag: 201827
  - 23
    - HELP! I need VFP 6 VFPCOM.DLL I am reading yet another book from the Hentzenwerke publishing empire: "Microsoft Office Automation with Visual FoxPro". Chapter 13 mentions using VFPCOM.DLL. I was eager to follow the examples given. Complications ensued. It turns out that there are two VFPCOM that I have been able to find. One is supposedly for VFP 6 and the other for 8. Neither package has the file VFPCOM.DLL. This severely cramps my style. I am using VFP 6. I have googled and gone through the results, to no avail. Does anyone know where I can get this file? If you have it, please send me a copy. (Given the results of my search, I feel I am safe in asking like this: 50,000,000 copies are not going to be headed my way. <G>) Alternatively, I may be misunderstanding something. Pointing out how I can get either package working is fine, too. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Data Sort Using Grid Control Tag: 201823
  - 24
    - Foxpro for Windows - HELP needed I am currently running a FoxPro for windows application under Widows 95. I have a second system, and am trying to run the SAME application under Windows 95 but getting different results. The application runs - but when the first screen is displayed the cursor is not sitting at the first input field, therefore I must use a mouse to position the cursor in the field before I can enter the data. This program is identical on both systems - works fine in one - but not the other. As well, the first system - that functions correctly - has 32 mb of ram (90% free) While the second system -(running the same application) - has 64mb of ram (96% free) and I get an error indicating "insufficient memory" Is there somewhere that I can tell the system how much memory to allot to this application? I don't understand how the 2 systems running the SAME APPLICATION can be so different Many thanks in advance for any help you can give me. PS . Woody was able to help me resolve my previous problem. Tag: Data Sort Using Grid Control Tag: 201821
  - 25
    - HELP - Foxpro for windows - Windows 95 I am currently running a FoxPro for windows application under Widows 95. I have a second system, and am trying to run the same application under Windows 95 but get the following On start-up the following error is displayed: "An error has occurred in your program. To keep working anyway click ignore and save work to a new file. To quit this program click close" If I click ignore - the application runs - but the cursor placement is different, and I eventually get an error indicating "Insufficient memory" - even though the new system has 64mb of memory, - 96% free, while the old system (which does work) has 32 mb memory, 90% free. The question is: 1. if the new system has a newer version of Windows 95 - is there a patch that will eliviate this problem? 2. is there a command somewhere that dictates how much memory is to be allocated to this application? Can someone out there HELP me - I am running out of ideas. If so could you EMail me direct. Many thanks in advance. Tag: Data Sort Using Grid Control Tag: 201820
- Next
  - 1
    - newbie question : checkbox and dbf field Hi, I already created a checkbox control in a grid, but upon clicking on the checkbox it didn't show the 'tick' and 'untick' graphic. also the field value of that column always .F. Plz advice. TQ Regards tnhoe Tag: Data Sort Using Grid Control Tag: 201818
  - 2
    - Extract JPGs from General field in VFP6 I have a VFP6 table that has a general field that contains embedded JPGs and I need to extract them to individual *.JPG files on the C:\. Is there any internal VFP6 command that can do that in batch? It seems like there was one for memo fields but I don't see one for a general field. Thanks Matt P Tag: Data Sort Using Grid Control Tag: 201814
  - 3
    - Upgraded to VFP8 installer problem Hi, Just trying to upgrade to vfp8 from vfp7, but soap won't install (and therefore neither will anything else unless I use /NO_BSLN_CHECK) Do I need soap (well I might need a wash!!) ? I am not going to write web apps. Steve Tag: Data Sort Using Grid Control Tag: 201812
  - 4
    - form instance Dear sirs I`ve created a class Form (MyForm) and I`m calling it from another form by the following code zfrm = 'frm'+THISFORM.Caption &zfrm = NEWOBJECT("MyForm","proClass.prg","",zTable) &zfrm..VISIBLE = .T. &zfrm..AUTOCENTER = .T. &zfrm..BACKCOLOR = RGB(152,198,254) &zfrm..RIGHTTOLEFT = .T. where zTable is a parameter I send to the form I don`t know why this code doesn`t work with me? when I run it the form instance appears only for a second I don`t know why??? thanks Mohammed Tag: Data Sort Using Grid Control Tag: 201811
  - 5
    - Office 2003 - XML - VFP Dear listmembers, First, sorry for my poor englisch. In december I am a speaker on a conference about Office 2003 and XML. At the end of the presentation, after I've told the attendees about the XML possibilities of Office 2003, I've two small demo's about transferring XML data from Office to the application by XML. My current demo-applications are written in VB. I want to do one demo with Office XML (Word of Excel) in combination with VFP. I'am not a VFP programmer, so i am not able to create it myself. My question is: Do you have such a demo? The exact function doesn't matter, the key issue is: Using Office XML data. The conference is in the Netherlands. I prefer Dutch, but an Englisch demo-aplication is OK to. If you want i can put your company logo on the slides of the presentation. All other details can be handled outside this newsgroup. Thanks in advance Jan Vente Broekhuis Training Marten Meesweg 145 3068 AV Rotterdam The Netherlands (+31) (0)10- 2861010 Tag: Data Sort Using Grid Control Tag: 201809
  - 6
    - Re: how to use font in the report form vfp 6 I now use the vfp 8 but I so not use this font tq for guide me I really need anybody can help me "Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message news:#GobFt6tEHA.3572@tk2msftngp13.phx.gbl... > Hi Arash, > > Have you updated VFP6 to Service Pack 5? There were some fixes that affect > reports and non-Roman languages. > > Visual Studio 6 SP6 doesn't have anything that affects VFP. Here's the link > to SP5: > http://msdn.microsoft.com/vstudio/downloads/updates/sp/vs6/sp5/dnldoverview. aspx . > > -- > Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP > cindy_winegarden@msn.com www.cindywinegarden.com > > > "arash" <but_realworld@hotmail.com> wrote in message > news:uyiOZKutEHA.2956@TK2MSFTNGP12.phx.gbl... > >I Want use a old database in foxpro 2.6 ms.dos > > but , the font in the database is farsi language (perstion) . > > i found a font (persion in windows xp ) when i use this font in the foxpro > > for win 2.6 it good work for browseing > > but this font not work in the vfp 6 browsing > > i am working in the vfp 6 and making report but i can not use this font in > > the report form > > Tag: Data Sort Using Grid Control Tag: 201804
  - 7
    - Upgrading from 2.4 or 2.6 Hello I need some verification. How far up a version can I upgrade. Or can I upgrade all the way to version 8. I need a procedure on what is the better way to upgrade on this old version without getting that many error in between. What type of software whether is a full version or an upgrade will I need to do it. The PC that is goint is a Pentium 4 512Ram 40 GB with Windows 2000 or XP. If someone can help I will definetely will appreciated. Tag: Data Sort Using Grid Control Tag: 201803
  - 8
    - Windows Server 2003 / Colors all wrong on forms! Does anyone know why colors would not appear correctly when running a program developed using VFP 7.0 through terminal services? For example, I have a grid which (depending on what data the user is looking at) could be either dark green, brown, or another shade of green. I only ever develop using the limited colors offered in VFP's color palette, so it's not like I'm doing anything outrageous! The dark green on the grid is appearing as black and as the font's forecolor is black this is obviously causing quite a problem!! Help, suggestions, sympathy, what-ever - I'd be grateful to hear from someone! Thanks - Debbie -- _____ This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://info.mailfrontier.com Tag: Data Sort Using Grid Control Tag: 201802
  - 9
    - Dynamic Menus I need to add functionality to my menu to allow users something similar to the way MS Office has the list of the most recent X files opened in the file menu. I have no problem tracking which items need to be in the menu, I am just too stupid to understand how to dynamically add them to the menu and change them as the selections change. Can anyone point me in the right direction? Thanks, Scott Tag: Data Sort Using Grid Control Tag: 201790
  - 10
    - receiving email My software send emails without problem, but I'd to read emails from outlook express and save attachments in a especific place. Is it possible ?? I'm using VFP6 and outlook 6 For all windows 95,98,Xp ... Thanks Alberto Tag: Data Sort Using Grid Control Tag: 201789
  - 11
    - Data dissapears from screen when upgrading to version 8 I am upgrading from version 5 to 8. When I drag my cursor over some fields on the form, the data dissapears. I read in the notes that Themes could be responsible. I'm guessing it must be some property setting. Does any one have any suggestions? Thanks, Jim. Tag: Data Sort Using Grid Control Tag: 201782
  - 12
    - VFP7 grid refreshing I have a niggly problem that comes up at least once a year and I still haven't found a satisfactory solution to it. If you have large data files which are displayed on a grid on a form, if the file is filtered, grid refreshing takes ages. I've kept grid refreshing to a minimum because of this. The niggle is that if you come into a screen, I want the file to stay on the record that was last viewed so I don't GO TOP or anything. This means that the current record always shows at the very top of the grid even if it's the very last record in the file and there are a few thousand more above it. I'm not sure why the grid does this. I know a solution, but it involves doing a GO TOP and refreshing the grid then going back to my stored record number. But this then causes a massive slow-down which we can't live with. Is there any other way of making the grid show the current record in the middle rather than at the top? I hope you all catch my drift. Any comments would be welcome. bernie Tag: Data Sort Using Grid Control Tag: 201778
  - 13
    - Code Magazines did it again with a whole volume for VFP9 http://www.code-magazine.com/focus/index.aspx You can download and print a pdf version and I recommend you do so. -- Edhy Rijo Programming System Solutions www.progytech.com Bronx NY Tag: Data Sort Using Grid Control Tag: 201758
  - 14
    - View PDF in VFP Form, Edit Form Field, Capture PDF Form Data VFP8. We are once again looking at editing PDF forms inside of VFP. We are currently testing the pdf.ocx from Adobe in conjuntion with Gnostice's pdftoolkit. I have looked at a couple of other options such as iSedQuickPDF. Right now I am able to open a pdf file using Gnostice's pdftoolkit (the ocx is slapped on the VFP form) and programmatically populate the pdf formfields on the pdf form with data from our app using the Gnostice pdftoolkit. We then save the pdf form to disk and open it again in the form using the pdf.ocx. The Adobe pdf.ocx allows the user to edit the fields on the pdfform. If the pdf form is saved to disk, I can then grab the changes to the formfields on the form using the Gnostice pdftoolkit and save those changes to tables in our app. The problem we are encountering is that the Adobe activex ocx will only save the changes to disk if the workstation has the full version of Adobe Acrobat installed. If only Adobe Reader is installed then the pdf form is saved without any data. Of course, our goal is to capture the form field data changes and save those changes back to our app's tables. Since the Adobe ocx is providing the means of displaying and editing the pdf form fields, the Gnostice pdftoolkit on the form does not see the pdf form once it is loaded in the Adobe ocx (since it is in memory and not stored to disk yet after the changes are made) or its values. The pdf toolkit can only grab the form field valus once the pdf form is saved to disk again after the changes are done. Then we run into the problem of requiring the full version of Adobe Acrobat on the workstations so the adobe pdf.ocx will save the form with the data to disk so the toolkit can read the changes. Any ideas? We could handle it with purchasing two separate pdf tools if necessary. If that is the case, then we need a means of displaying the pdf form and allowing the user the means to edit the form fields on the pdf form, and then save the data to disk so the 2nd toolkit can readin the changes. Thanks for any ideas you may have! Vita contingit. Vive cum eo. (Life Happens, Live With it!) Tag: Data Sort Using Grid Control Tag: 201757
  - 15
    - Uniq Number Hi Everybody. I need some ideas how to get the unique number in the range 1-9999 for my application. It has to be absolutely uniq for any instance of my application. What I am doing is I try to create on my server file name with certain prefix and four digit number and try to see if I can open it exclusively. If I can then it's uniq. I am using Fcreate(MyFileName). The problem that I have is FCREATE function works very slow when it cannot create file. Does anyone know how to bypass FCREATE() to check for exclusive excess or may have any other ideas to my problem? Thanks in advance Leon Tag: Data Sort Using Grid Control Tag: 201755
  - 16
    - VFP 8.0 and copying folders. Is there a native foxpro command to copy a folder and its contents to a different drive. I can only find examples that require WSH is installed on the target machine. I have about 2000 files to copy from a CD to the users harddrive. I need to do this from within the installation or from code. I would include all these files, but InstallShield Express hangs up when I try to drag the folder during creating a new project. I assume that there are too many files. And since I do not have the full Install Shield program, I cannot create a link to this folder. Thanks, John. Tag: Data Sort Using Grid Control Tag: 201747
  - 17
    - Zetafax (Paul Pederson) and printing reports directly We were discussing faxing from VFP - we have mostly decided that Zetafax will meet our needs but are curious if printing a VFP 6 report directly to Zetafax's print driver has been a problem for anyone. How have you dealt with embedding fax number information, perhaps via a header band? Many thanks in advance. -S- Tag: Data Sort Using Grid Control Tag: 201744
  - 18
    - How to save VFP Debuger window's size and position? Hi all, I have specific preference while opening a debugger. I want the Trace Window and the Watch Window to have some specific Height and Width, I seldom need Output and Locals Window, so I prefer them to hide, and I want the Stack window to be on specific position. Anyway, it's really troublesome to do this every time I open the debugger. Anybody here knows how to set those window size and position such that they stay there every time I open the debugger? TIA, Willianto Tag: Data Sort Using Grid Control Tag: 201738
  - 19
    - Data access in VFP 8.0 views I was thinking of changing over to OLEDB data access instead of current ODBC connection. My application uses lot of VFP views to do select, update, insert etc. I am worried that when changing over to OLEDB, I cannot use Views any more. It will require more programming to change over from view to SQL pass through query using OLEDB. Has any body done this kind of work? Any help will be appreciated. Thanks Ajay Tag: Data Sort Using Grid Control Tag: 201734
  - 20
    - kalle kalle? Tag: Data Sort Using Grid Control Tag: 201721
  - 21
    - foxpro 2.6 Fields - disabled fields makes software to abort Hi I have a problem in foxpro 2.6. I have 2 Fields in a screen. The first field is alphanumeric and the second is a date field. In field1-Valid() I check that field1 is empty and if so field2 will be disabled. When the program runs and field1 is empty it works to use the tabulator to leave field1. What happens is that field 2 is disabled and the control is forwarded to the next object in the screen. My problem is if I use the mousepointer to click in field2. Then, field2 is disabled but the program aborts without any messages. I have tried different solutions for example to add code in the When() clause for field2 that determines that field1 is empty and gives control to another object in the screen. But it won't work. If anyone knows how to get around please send a response. Best regards /G Tag: Data Sort Using Grid Control Tag: 201720
  - 22
    - VFP appliaction very slow Dear I have a problems. When I put the Visual Foxpro database file to LAN Server share to lan Workstation access. I load the record very slow. Can you advice which solution can define this problems. Thanks Jackie Wong Tag: Data Sort Using Grid Control Tag: 201718
  - 23
    - Status Bar display My status bar has suddenly decided not to shew the active record number and the total of records. The Status Bar is Set on, if I Set Status on I just get the narrow blue band shewing <c> and 'num. I'm missing something here, what have I done wrong and how do I return to the display of record no/total records? Tag: Data Sort Using Grid Control Tag: 201713
  - 24
    - Task Pane Could the Task pane be included as part of an exe as the main starting or is it only available in the development environment. Thanks Shahriar Tag: Data Sort Using Grid Control Tag: 201698
  - 25
    - Collating sequence in VFP8 I want to use the HUNGARY collating sequence. When I issued SET COLLATE TO "HUNGARY" no any error messages. If I want to create a new idx file I receive the error "Collating sequence "HUNGARY" is not found." What mistake did I make? -- Sandor Tag: Data Sort Using Grid Control Tag: 201697

I have a grid control that displays all the rows and columns of a table
diagcode.
I have a option group that allows user to select sort by column "diagcode"
or "diagdesc". How can I now get the data in the grid to sort based on what
is selected in the optiongroup?

Top

Re: Data Sort Using Grid Control by Stefan

Stefan
Tue Oct 26 02:35:40 CDT 2004

You can create index tags and use Set Order To ... at runtime, e.g.
&& at designtime
Use diagcode Exclusive
Index On yourFieldExpr Tag tagName

&& at runtime
Select diagcode && assuming alias is open Shared already
Set Order To tagName && or...
Set Order To tagName Descending

See also "Using Rushmore Query Optimization to Speed Data
Access", Sys(3054) and related in help

hth
-Stefan

"baagh" <baagh@discussions.microsoft.com> schrieb im Newsbeitrag
news:0DD005C3-AE02-4436-ACF5-A215676F5E60@microsoft.com...
>I have a grid control that displays all the rows and columns of a table
> diagcode.
> I have a option group that allows user to select sort by column "diagcode"
> or "diagdesc". How can I now get the data in the grid to sort based on what
> is selected in the optiongroup?

Top