Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mjcmkrsr

    SELECT SQL and free tables

    ... OK. But why then toggling the REPORTBEHAVIOR ? SET REPORTBEHAVIOR 90 DO FORM RELRESERVAS6 && 22/07/2025 SET REPORTBEHAVIOR 80 hth MarK
  2. mjcmkrsr

    SELECT SQL and free tables

    Hi SitesMassTec, SQL seems to make you sweat quite a bit - see your post from Oct 2024. My questions in this context : Why do you want to JOIN PASSAGEIROS since you don't include any field(s) from that table ? Why do you index the cursor without setting a tag ? Why do you close the tables...
  3. mjcmkrsr

    Is there an equivalent of "AfterRowColChange" in Listbox control?

    Hi, To emphasize what Joe said - when you scroll through a list/combo box its DisplayValue changes hence its Value, and this triggers InterActiveChange hth MarK
  4. mjcmkrsr

    Is there an equivalent of "AfterRowColChange" in Listbox control?

    ...a look a the code below PUBLIC go_Form go_Form=CREATEOBJECT("clsForm") go_Form.Visible = .T. go_Form.Show() READ Events CLOSE ALL CLEAR ALL ************ DEFINE CLASS clsForm as Form AutoCenter = .T. Width = 420 MinWidth = 420 MaxWidth = 420 Height = 360...
  5. mjcmkrsr

    Combobox not populated with array

    Hi SitesMassTec, I'm sorry, but you miss the point. The code was intended to show you how to normalize the data from your TEMPEXPL - with all those empty fields - and how to create a cursor to drive the report CREATE CURSOR csrReport (lcodi I, lor C(8), lco I, lno C(40), lqt...
  6. mjcmkrsr

    Cursor in Data Environment

    This question had long been answered by you. My answer is addressed to GTGeek88 who asked if a view could be used in the DE. MarK
  7. mjcmkrsr

    Cursor in Data Environment

    Hi Chriss, NoDataOnLoad of the view is set to .T. - the form property is fed when the form is activated and then the view is requeried I use updatable views - a cursor does not allow to update the underlying tables. Demo code attached - however without the DE and the NODataOnLoad MarK
  8. mjcmkrsr

    Cursor in Data Environment

    ...Houses.room, Students.pfa, Students.dentry,; Students.dexit, Students.rent,; Students.pfa+INT((4+Students.dexit-Students.dentry)/365*12*4)*Students.rent/4,; Students.dcaution, Students.cinstitution, Students.pkey, Students.nkey,; Students.fkey; FROM ; wunnraum!students ...
  9. mjcmkrsr

    Cursor in Data Environment

    Hi GTG, They will ala they have been defined and parameterized - I have quite a lot of LOCAL VIEWS in my DEs. I guess, as Chrisss posted, that you can't CREATE them in the DE. MarK
  10. mjcmkrsr

    How to interactively change control source of a grid at runtime?

    Hi, In my baseform class I have a method called SetDataBase. Code like below Local cObjClass, cObjName, cOldDatabase, cNewDatabase, oReference Local Array aCursors[1] If Not (Empty(gcDrive) Or Empty(gcPath)) = AMEMBERS(aCursors, THISFORM.Dataenvironment, 1) For i = 1 to...
  11. mjcmkrsr

    Combobox not populated with array

    Hi, I'm sorry I can't judge. However, I see is that you created a form with 12 * 4 textboxes. The question arises: what are you trying to achieve. Wouldn't a grid with 4 columns not be better to show the data? Btw, this post reminds me one you posted about recipes in August 2023 also creating...
  12. mjcmkrsr

    Strange MariaDB behavior with Sequential GUIDs

    Hi, VFP SQL behaves the same way - you have to specify ORDER BY if you want the data to show in a certain order - otherwise they will show in "natural" order hth MarK
  13. mjcmkrsr

    Any idea how to deal with blank spaces?

    Hi, Well, sometimes you have to think and sometimes you have to check. From the HELP FILE MarK
  14. mjcmkrsr

    Any idea how to deal with blank spaces?

    Hi Filip, Try thisform.label10.Caption='['+ALLTRIM(this.Value)+'/' hth MarK
  15. mjcmkrsr

    Combobox not populated with array

    ...Chriss's suggestions PUBLIC go_Form go_Form=CREATEOBJECT("clsForm") go_Form.Visible = .T. go_Form.Show() READ Events CLOSE ALL CLEAR ALL ************ DEFINE CLASS clsForm as Form AutoCenter = .T. Width = 420 MinWidth = 420 MaxWidth = 420 Height = 360...
  16. mjcmkrsr

    Combobox not populated with array

    Hi, That's fine. Well in this particular case it is the easiest way to attach the code - otherwise I would have to create a project, create/add classes, forms and tables ... zip them and then attach the zip file AFAIK, you have to edit/modify it in text mode. That's fine too, but e.o...
  17. mjcmkrsr

    Combobox not populated with array

    ...and code for a demo PUBLIC go_Form go_Form=CREATEOBJECT("clsForm") go_Form.Visible = .T. go_Form.Show() READ Events CLOSE ALL CLEAR ALL ************ DEFINE CLASS clsForm as Form DIMENSION gaEmployees[1] AutoCenter = .T. Width = 420 MinWidth = 420 MaxWidth =...
  18. mjcmkrsr

    Strange error

    Hi, What are you trying to achieve? If you need to Create View and Set View to ... please be aware of the weaknesses of these commands https://hackfox.github.io/section4/s4g107.html hth MarK
  19. mjcmkrsr

    Combobox not populated with array

    Hi, You may want to have a look at the BOUNDCOLUMN property of your combobox and set it to 2 to return the value of column 2. https://hackfox.github.io/section4/s4g481.html and have a look at may post...
  20. mjcmkrsr

    Combobox not populated with array

    ... and the whole explanation from VFP Hacker's Guide https://hackfox.github.io/section4/s4g445.html hth MarK

Part and Inventory Search

Back
Top