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 Chriss Miller 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

    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...
  2. 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
  3. 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
  4. mjcmkrsr

    Any idea how to deal with blank spaces?

    Hi Filip, Try thisform.label10.Caption='['+ALLTRIM(this.Value)+'/' hth MarK
  5. 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...
  6. 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...
  7. 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...
  8. 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
  9. 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...
  10. mjcmkrsr

    Combobox not populated with array

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

    Combobox not populated with array

    Hi, Did you know that you can import directly the data from an array into your combobox ? Set the ROWSOURCE property to the array name and the ROWSOURCETYPE property to 5 - Array. You'll have of course to REFRESH() or REQUERY() the combobox when data changes in the array. see also...
  12. mjcmkrsr

    Checkbox added to grid is invisible until clicked

    Hi, Make sure that the SPARSE property of the column is set to .F. and that CURRENTCONTROL of that column is your checkbox. Fwiw, please find attached demo code. PUBLIC goForm goForm = NEWOBJECT("frmForm") goForm.Show Read Events Close all Clear All RETURN ********** DEFINE CLASS...
  13. mjcmkrsr

    List Out Missing Numbers of a Number Range

    I understand, but I nowhere found this kind "mistrust" - neither in the "Hacker's Guide" nor in Tamar's many papers on SQL. May be she could chime in for further input. TIA MarK
  14. mjcmkrsr

    List Out Missing Numbers of a Number Range

    Hi Chriss, Could you please explain. TIA MarK
  15. mjcmkrsr

    List Out Missing Numbers of a Number Range

    Hi Chriss, Thanks. Works now. Best with SET DELETED ON - otherwise you see the records marked for deletion ;) MarK
  16. mjcmkrsr

    List Out Missing Numbers of a Number Range

    Hi Chriss, I tested your code. Unfortunately it has one flaw and one misspelling If you insert this line you'll have 0 as missing value - which does not make sense Should read = Seek(Gaps.iGapStart, ...) Below your code with my suggestions Create Cursor Gaps (iGapStart I, iGapEnd I)...
  17. mjcmkrsr

    List Out Missing Numbers of a Number Range

    Hi, Yes, now it works - even in VFP9 ;) MarK
  18. mjcmkrsr

    List Out Missing Numbers of a Number Range

    Hi mmerlinn, I tested your code. Unfortunately I found one little flaw: the results show that there are dupes, but do NOT show how many times the same value is present in the table hth MarK
  19. mjcmkrsr

    List Out Missing Numbers of a Number Range

    Hi, Just for fun : sketch of code to show the correct values, the missing values and duplicate values in a given range. *!* good values, missing values and duplicates PUBLIC goFormSales goFormSales=NEWOBJECT("clsForm") goFormSales.Show Read Events Close all Clear All RETURN...
  20. mjcmkrsr

    List Out Missing Numbers of a Number Range

    Hi Yes - ALL values in the chosen range. In your case laAllValues[1] = 15 and laAllValues[2] = 1 hth MarK

Part and Inventory Search

Back
Top