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!

Search results for query: *

  1. Mark826

    Creating a variable size cursor

    The ALTER TABLE command can be used for cursors to add columns. Sample: CREATE CURSOR test (cKey c(10)) ALTER TABLE test ADD COLUMN col1 c(11) -Mark
  2. Mark826

    vfp6 and 'as' in select stmt

    Is this what your looking for - 4 columns: first,last,young, and old. Only dates with dob < 1980 go in the young column, others in the old. select first, ; last, ; IIF(year(dob)<1980, dob, {}) AS Young, ; IIF(year(dob)>=1980, dob, {}) AS Old ; from member - Mark
  3. Mark826

    how to stop textbox from scrolling

    Don't know what made me think of that solution. If you take a look at the maximum character width for these fonts it might give a better idea of what I think VFP is doing for this scrolling. FONTMETRIC(7, "Arial",10) && Returns 35 FONTMETRIC(7, "Courier New",10) && Returns 9 A little test I...
  4. Mark826

    How to TRANSFORM a number?

    You can also use PADL(3, 4, "0") to get the same results.
  5. Mark826

    how to stop textbox from scrolling

    It probably has to do with the font being a proportional font. If you change the width of the textbox to be wider, say 100, it will not scroll, but it won't look so good either. Changing the font to a Fixed spaced font (such as Courier new) should work without having to change the width, but...
  6. Mark826

    looking for generic refresh for pageframe

    In your Pageframe class, Create an ActivePage_Access Method (To create this method while modifying your class, Under the 'Class' menu, Select 'Edit Property/Method', Click on the 'ActivePage' property, and Check the 'Access Method' box and apply changes.) Place the following code in the...
  7. Mark826

    Disappearing Flag Settings

    We're basically having the same problem as this post - Has anyone found a solution to this yet? Thanks

Part and Inventory Search

Back
Top