descending order in grid

Visual FoxPro General

‹ Visual FoxPro
- Archive
  - Dotnet
  - VS Express
  - Windows Forms
  - Architecture
  - Visual Studio
  - Windows Live
  - SharePoint
  - VFP
  - IE
  - Smart Device
  - VB
  - Windows Vista
  - VC++
  - Visual C#
  - Office
  - SQL Server
  - Game
  - ISV
  - VS 2008

- Previous
  - 1
    - impersonateloggedonuser and Getfil() Yes. You may try to run the software with a user with administrator rights. If is working you may cut some "rights" testing if program is working. I ran it with a power user and still working. What kind of users are logonuser and impersonateloggedonuser Tag: descending order in grid
  - 2
    - Browse problem >Will I have a lot of work in recoding to use a grid Depends on how complex the Browse or the grid are. For a simple browse, or a simple grid, not much. Just get your data and set the recordsource property to populate the grid. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/35fc073a-6840-4046-aa72-90f3c69b7f1e.asp The grid control has many more properties and methods to be able to do fancier things. The simple examples in the help link will show you some of it. Do not use Browse on a form. Browse is now relegated to the command prompt for quick data viewing/manipulation when in development mode. Tag: descending order in grid
  - 3
    - Foxpro memo field in ado (or ado.net) Wierd that when I dump the physical .fpt file it looks the same in notepad Tag: descending order in grid
  - 4
    - RTF property OK, this is a new problem. I expect that Cetin may crack this one easily. I posted on this issue in Windows Forms General but so far nobody touched it. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2236535&SiteID=1&mode=1 In short I am trying to read my VFP memo fields in .NET but encountering a problem. I am trying to read them into RichTexTBox.Rtf property and I am getting an error that the string is not of correct format. I can read them into RichTextBox.Text property but all formatting characters are displayed. I loaded those fields in VFP from my OLE bound control whose name I do not quite remember now, I think it is also RichTextBox. It has worked quite well in XP but now it is a different era. Fox just expired in Vista on me. I do have a question. What if I convert my memo fields with type memo into either memo binary or binary or varbinary or whatever and try to read the latter into the control in .NET using DataBinding property in there. Will it work Is is possible to convert memo fields into blob 's Is it gonna work Thanks. Tag: descending order in grid
  - 5
    - GETPRINTER() causes access violation in VFP6R.DLL The local printer on that computer has an HP pritner with the latest driver. But my problem is even before getting to the report. Thanks anyway for the feed-back. Tag: descending order in grid
  - 6
    - How to use the session object. Thank you both for your input. I tried this from a calling form. I've put a command button which runs this: otest = createobject("session") set datasession to otest.datasessionid * CLOSE DATABASES all DO stt2c set datasession to thisform.DataSessionId release oTest I got this error, at the point when I try to set index in stt2c: COMMAND CANNOT BE ISSUED ON A TABLE WITH CURSORS IN TABLE BUFFERING MODE. Any ideas Thanks. Tag: descending order in grid
  - 7
    - VFP PopUp Menu In Vista It seems to be solved in the last post... Tag: descending order in grid
  - 8
    - filter breaks in vfp? Yes, read-wrire cursor idea sounds possible. This form may share the main form DS (the child form DS should be left default), so you main form will see the changes this form made in that cursor and react accordingly. I think the cursor idea sounds better than trying to use set filter. Tag: descending order in grid
  - 9
    - Philadelphia VFP User Group--Wednesday, August 15 The Philadelphia VFP User Group will meet this Wednesday, August 15 at Valley Forge Pension Management, 715 Twining Road, Suite 202, Dresher, PA 19025. (Note: The Oreland offramp from PA 309 Southbound has been permanently closed. The easiest way to reach the meeting location from the PA Turnpike or 309 Southbound is to come through the Fort Washington Industrial Park.) Feel free to bring something to eat and arrive as early as 6:30. Speaker: Jim Walsh I was born and raised in Philadelphia. I have a BS, Physics from St. Joseph's College (Phila), MS, Physics from Brown Univ (Providence, RI), and a Ph D in Physiology & Biophysics from Univ of Vermont (Burlington, VT). I did a post-doctoral fellowship in neuroscience at the Univ of Pennsylvania. After my MS degree, I worked for a couple of years with IBM in semiconductor technology development in Vermont. I was an Assistant Professor at Beaver College in Glenside, PA for several years teaching Anatomy & Physiology, and Computer Science. While teaching, I was doing computer consulting on the side. I finally decided that computer consulting was more fun, and gave up teaching entirely. The general theme of my career has been the use of computers in science, engineering, and medicine. I've had an opportunity to work in a lot of different fields (the advantages of being a Physics major). In college I worked for a year in a work-study program at NASA's Goddard Spaceflight Center. That is where I first learned to program. We were using computers to simulate proposed launches to determine the best parameters for getting successful orbits. My master's thesis was a magnetic resonance study of the structure of glass. Part of that involved using computers to simulate the measured spectra. At IBM, I was involved in characterizing semiconductor processing techniques that were coming out of the development labs. Part of that involved computer simulations of the experimental measurements. At the Univ of Vermont, I did research that involved electrical recordings from single brain cells. I used a DEC PDP-8 computer to completely control the experiments, and also computer simulation to model the results. My consulting work as been in the area of medical applications, mostly in the field of Biomechanics and Podiatry. I am also part-inventor of a system for measuring human gait: GaitMat II. Topic: Medical Computer Consulting - Looking at the world of medicine from the computer consultants point of view. This includes analyzing and integrating data in a variety of forms and using automation to help provide a comprehensive patient information. Tag: descending order in grid
  - 10
    - How to verify email address on smtp server Hi all I want to know is there any way to verify email address on smtp server. For example: Suppose my SMTP server is smtp.gmail.com & I want to check that either email address sur@gmail.com exists on gmail.com or not. Thanks Tag: descending order in grid
  - 11
    - problem setting up a ODBC data connection more questions. Did you configure sql2005 for remote connections It's disabled by default. Use SQLserver configuration and surface area editors to allow remote connections first and also be sure to adjust firewall for SQL2005 ports (default 1433 but SQL2005 uses dynamic ports, read details about on how to setup for remote connections in BOL). PS: You better not use ODBC but OLEDB driver for SQL server when you're using it from VFP. Tag: descending order in grid
  - 12
    - Trouble totaling up fields for a report Anomaly wrote: Hi everyone, My problem is that I have a table for which I need the totals, the table contains 6 columns, 3 of them are a character and the other 3 are money amounts: Group1 | Group2 | Group3 | TaxGroup1 | TaxGroup2 | TaxGroup3 A A1 A1a 1.00 .50 .25 B B1 B1a 2.00 .30 .45 A A1 <empty> 1.20 .25 .00 As you can see the TaxGroup1 is connected with Group1 and so on, also the other groups are sub-groups. I need to be able to generate a cursor to show the totals of each group. I hope my explanation helps. Thank you. We can get: select Group1, sum(TaxGroup1) as TotalTaxGroup1 from myTable group by 1 into cursor cur1 select Group2, sum(TaxGroup2) as TotalTaxGroup2 from myTable group by 1 into cursor cur2 select Group3, sum(TaxGroup3) as TotalTaxGroup3 from myTable group by 1 into cursor cur3 To connect them you may try to connect first based on Group1, second based on Group2, third based on Group3. So, you can combine now all steps in 1 SQL, e.g. select g.Group1, g.Group2, g.Group3, cur1.TotalTGroup1, cur2.TotalTGroup2, cur3.TotalTGroup3 from MyTable g ; inner join (select Group1, sum(TaxGroup1) as TotalTaxGroup1 from myTable group by 1) cur1 on g.Group1 = cur1.Group1 ; inner join .... Or you may have to use left join in case you don't have data in one of the columns. The idea is from the top of my head, not tested. Tag: descending order in grid
  - 13
    - Merge 2 text file if u know the layout of destination.txt, you can create a blank structrue and say use destination appe from desitnation.txt sdf or u can open destination.txt in excel and save it as dbf. then u can match product and destination to get a 3rd file i.e. sele a.productid,a.description,a.productgroup,b.destination from product a,destination b where a.productid = b.productid into dbf prddest.dbf your prddest.dbf will have all product codes with destination,description and group Tag: descending order in grid
  - 14
    - fast / draft mode printing in vfp Telling someone to embed printing control in a report is VERY BAD ADVICE. Removing those same embedded controls is one of the most frequently asked questions. This setting is best made in the Windows Control panel for the installed printer (assuming the printer driver supports draft printing), where it will not affect reports that sometimes need to be sent to other printers. It's nothing to do with VFP at all. Control printers through the printers control panel. Tag: descending order in grid
  - 15
    - How to Filter Records in a Grid I've become a big fun of Cursor Adapter lately, so I would probably use Cursor Adapter here as well. Anyway, let's try to work out textbox and SET KEY idea. In the textbox interactive change try: lcKey = alltrim(this.value) ** Assuming the table is ordered by Customer and it is the current alias SET KEY TO m.lcKey && This should filter all records matching the entered value ************************************************************************************************************************ If this would not exactly work as you want, you may construct lcKeyMin, lcKeyMax and use the second version of SET KEY command. Check details in the help. Let me know, if you would be able to make this idea work. Other ideas would be using local parameterized view. Tag: descending order in grid
  - 16
    - OLEDragDrop errors Thanks Naomi and DNI. I have fixed the problem and it turns out that it was not anything to do with the OLEDragDrop method - it was simply that I was referring to a property which did not exist. However, I would not have discovered this if I hadn't been trying to re-work the code so that I could provide a comprehensible example as requested by Naomi. I'm still baffled as to why the error crashes VFP rather than simply producing a 'property does not exist' error, but it is all working fine now in any case. Tag: descending order in grid
- Next
  - 1
    - ADO and NULL in VFP tables When I use the AddNew() method of a recordset the new record has all the fields set to .NULL. Unfortunately the tables I am accessing do not allow NULL values in the fields. Can you tell me please is there a simple way to change this behaviour of the recordset so that the fields are set to empty values instead such as "", 0, {} etc Otherwise I am guessing that I would have to write a routine of my own that changes any null values that haven't been set by the client. At the moment when I call the Update() method of the recordsetit throws a pretty general exception saying something went wrong. I am guessing that it is because of the NULLs. As a bit of background I am trying to use ADO to access VFP native tables so that I can easily use the recordsets as business entities that can be passed between my classes without having to specify dozens of parameters in the method calls. I am hoping to also pass these business entities between my COM server and the calling client application. Regards Darren Tag: descending order in grid
  - 2
    - GENDBC and Filters Hi Andy, In my Primary Keys (PK) I'm used to add a filter clause "NOT DELETED()". When I run GENDBC on my Database that has some filters on some PKs, I get the warning: "Filters no PRIMARY keys are not supported at this time. A comment will be added to your output file specifying the filters" I see that the latest GENDBC file was created in 1997, and it generates a commented line: ****** These filters need to be added manually ****** * Table Name: TESTE1 * Primary Key: ID * Filter Expression: .NOT.DELETED() **************************************************** I'd like to know if someone has modified the GENDBC program in order to generate the tables with the correct filter expressions. Thanks in advance Cesar Tag: descending order in grid
  - 3
    - Outlook contact details Here's a program from my book on automating Outlook. This reads some of the information for each contact and puts each into a new record: * MakeContactList.PRG * c 2000, Tamar E. Granor and Della Martin * From: Microsoft Office Automation with Visual FoxPro * Hentzenwerke Publishing. www.hentzenwerke.com * Read Outlook contact information into a cursor #DEFINE olContacts 10 #DEFINE olNone 0 #DEFINE olHome 1 #DEFINE olBusiness 2 #DEFINE olOther 3 LOCAL oNameSpace, oContacts, oContact LOCAL cFirst, cLast, cAddr, cPhone IF VarType(oOutlook) <> "O" * Start or connect to Outlook * Make it public for demonstration purposes. RELEASE oOutlook PUBLIC oOutlook oOutlook = CreateObject("Outlook.Application") ENDIF oNameSpace = oOutlook.GetNameSpace("MAPI") * Get Contacts folder oContacts= oNameSpace.GetDefaultFolder( olContacts ) * Create a cursor to hold contact information CREATE CURSOR ContactInfo ; (cFirstName C(15), cLastName C(20), mAddress M, cPhoneNum C(30)) * Go through contacts FOR EACH oContact IN oContacts.Items WITH oContact cFirst = .FirstName cLast = .LastName cPhone = .PrimaryTelephoneNumber * Choose the right address. If the primary phone number is empty, * pick up the phone number associated with this address. DO CASE CASE .SelectedMailingAddress = olHome cAddr = .HomeAddress IF EMPTY(cPhone) cPhone = .HomeTelephoneNumber ENDIF CASE .SelectedMailingAddress = olBusiness cAddr = .BusinessAddress IF EMPTY(cPhone) cPhone = .BusinessTelephoneNumber ENDIF CASE .SelectedMailingAddress = olOther cAddr = .OtherAddress IF EMPTY(cPhone) cPhone = .OtherTelephoneNumber ENDIF CASE .SelectedMailingAddress = olNone cAddr = "" ENDCASE INSERT INTO ContactInfo VALUES (cFirst, cLast, cAddr, cPhone) ENDWITH ENDFOR * Show the results BROWSE RETURN Tag: descending order in grid
  - 4
    - VFP9 freeze at startup with a superimposed image of a folder title....!!! If you have access to menu>Tools>Options you may restore defaults. You may also run setup.exe with option repair (you may need original cd) from: C:\Program Files\Microsoft Visual FoxPro 9\Visual FoxPro 9.0 Professional - English Tag: descending order in grid
  - 5
    - vFox9 vs PHP+SQL... Hi Mr Claude, Thanks for the answer.... so PHP kind of slow.... If someone ask what would be the 10 best Business Application Developer Tools... (including VFOX9).... would you be please to answer and Why COBOL not around us anymore... even It is, at first to be design for building business application (But VisualBasic still be use in most window application....) Thanks again! Tag: descending order in grid
  - 6
    - arabic Fox Me Up wrote: i would like to write in russian but when ever i try to put something in a text box i see " " Fox Me Up: Please do not hijack someone elses thread with a different question. His problem is Arabic adnd Right-to-Left issues. If you want to ask about Russian fonts (like " ER Bukinist 1251") and how to work with Russian in VFP you should start a new thread. Make sure you have Windows settings and fonts set to Russian. In VFP, add CODEPAGE=1251 to config.fpw Tag: descending order in grid
  - 7
    - Export to Excel with multi-language Hi, guys I'm fixing some multi-language function for our application software, we use FoxPro 9.0 and SQL server. For now, I can successfuly extract data from SQL, display it in FoxPro Form (using OLE object); or import data from Excel, then save it into SQL server (thanks to Rick Strahl , http://www.west-wind.com/presentations/foxunicode/foxunicode.asp ). But then, I stuck. When I try to extract data from SQL, then export them to Excel, I always get a lot of strange mark instead of my Chinese, Japanese or Arabic data shown in SQL server. I've try to STRCONV() data to Unicode or UTF-8, it just not work. Following are how I convert data in FoxPro: ** when extract data out of SQL server, convert data into VarBinary first SQLEXEC (nConn,"SELECT CAST(CAST(p_wname as nVarChar(4000)) AS VarBinary(8000)) AS p_wname FROM program ","temp") **convert data into UTF-8 SELECT CAST ( STRCONV (p_wname,10) AS M) p_wname FROM temp INTO CURSOR TFData ** After above steps, I can show multi-language data in form normally ** And if I want to save the data back to SQL, I need to .... ** Coonvert data back to Unicode then to VarBinary SELECT CREATEBINARY ( STRCONV (p_wname,12)) AS p_wname FROM temp INTO CURSOR TFData1 ** then Convert data into nVarChar SQLEXEC (nConn, " INSERT INTO program (p_wname) VALUES (CAST( TFData1.p_wname as nVarChar(50)))") So how can I show data normally when exporting to Excel Thanks a lot. Tag: descending order in grid
  - 8
    - Creating Audio Hello, I am not technically talented in any way. I am a writer and a painter. I often cruise this forum to try to learn things from you folks. I sometimes have a hard time getting around the niche language but I am very good at researching some of the terms you use. I told you all that so you would take it easy on me if you answer this question. I would like to be able to dictate material to be typed up and edited later. It would save me an amazing amount of time as well as make it easier for me to record ideas. Except for writing programs, (talking text not programming) my system is pretty basic. Windows XP w/media player. Can anyone tell me if this is possible and how I could accomplish it Thank you for your help. Tag: descending order in grid
  - 9
    - Validations on Textbox I believe in your case you're looking for EMPTY() function which correctly works for every data type. In other words: if empty(thisform.myTextbox.value) =messagebox(...) endif Tag: descending order in grid
  - 10
    - How to create a calendar in report? Thank you both for your reply. I feel scan ....replace.....scan will do. But what about the first issue Can I NOT put all the heading in the group head band Tag: descending order in grid
  - 11
    - Object assisted report in dot matrix printers I encountered a problem using object assisted reporting. Preview works fine but when I tried printing it in dot matrix printers like Epson FX-890 or Epson LQ-2170, it printed smaller fonts and the whole letter size paper was only printed 3/4 of its size, what could be the problem To further determine the cause of the problem, I tried printing it using report behavior 80 and it came out fine, thus report behavior 90 is to be attributed as the problem for these printers. Please enlighten me on why this is happening. Thanks. Tag: descending order in grid
  - 12
    - invisible form Could it be that you put some object (say, shape or container) above the fields Just guessing in addition to excellent advices by dni and Alex. Tag: descending order in grid
  - 13
    - how do i disable the windows logo key? i did not use any user rights, it's just if you use my workstation it was controlled at the server.. only recently that someone got a way to use without permission...thanks Tag: descending order in grid
  - 14
    - Problem with Browser activex control You can take a reference to the HTML form: oFrm = This.Object.Document.myForm Then refer to the form's objects: If oFrm.elements.Length > 0 For Each oElem In oFrm.elements oElem.Name EndFor EndIf HTH Tag: descending order in grid
  - 15
    - How to keep VFP standard toolbar up all the time? I tried WVISIBLE("Standard") in command winmdow in vfp 6 and if vfp 9 and is working fine. In 6 I receive .F. Tag: descending order in grid
  - 16
    - Microsoft is going open-source the core portions of the Visual FoxPro DBMS! If you consider the VFP core going into .Net, then it will be free in the Express versions. Tag: descending order in grid

honey1016

What can i do if my index is desceding order in Gid Column. It will automatically descending order in column 1 For example in grid column1 i have 02/02/06 but if i will add 02/02/07 it will automatically go to the top row. Please help. Thanks

Top

Re: descending order in grid

Alex Feldstein

Your question is not clear. If you mean you want to change to ascending order, either change your index tag on the controlling column with INDEX ON ... TAG ... or change the ORDER BY statement on your underlying query or view.

Top