Search results for query: *

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

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

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...

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

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...

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...

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