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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mjcmkrsr

  1. mjcmkrsr

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

    Hi, To illustrate Joe's answer, please have 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...
  2. 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...
  3. 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
  4. 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
  5. mjcmkrsr

    Cursor in Data Environment

    Hi Chrisss, Thanks for the insight. ad 1) Of course. How would you create a LOCAL view outside a DBC? I must confess - I never did work with REMOTE or OFFLINE views ad 2) Yes, but this variable can be fed from inside the form like I below SELECT Houses.name, Houses.room, Students.pfa...
  6. 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
  7. 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...
  8. 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...
  9. 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
  10. 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
  11. mjcmkrsr

    Any idea how to deal with blank spaces?

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

    Combobox not populated with array

    ... and the same example taking into account 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...
  13. 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...
  14. 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...
  15. 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
See more

Part and Inventory Search

Back
Top