Recent content by kthompsn

Beg pardon! I mis-spoke earlier. Went into my Control Panel just now and noticed that i'm using the Tweak-UI Powertool. THAT'S where the forms is, that allows one to select/deselect individual drive letters, A:-Z:. Other than that, one can use the LASTDRIVE to "select" a range of drives, for...

For info on adding/changing drive letters, check: http://home.att.net/~andyross/ZIP-FAQ/ZIPDriveLetters95.html Yes, it mentions ZIP drives -- but the principle is the same for any add-on. On the home W98SE system, am using an IOmega external HD as D:, internal CD-rom as E:, various USB...

Had similar problem. Eventually found that i had not activated (allocated) a drive-letter for it. Possible? Ken Thompson, Programmer & Mainframe Dinosaur

So, what i'm hearing is, this cannot be done? Ken Thompson, Programmer & Mainframe Dinosaur

I received a file in PDF format, containing a family tree diagram. The diagram is in landscape orientation, just a bit wider than US letter-size (>11 inches). If i shrink the diagram to fit 11x8.5, the print is too small to read; legal size is only a bit better. What i'd like is to enlarge...

Yes, data still unsorted. FWIW, columns in the original ORDER BY clause are 'calculated' rather than 'selected'; however, have tried specifying 'selected' columns in the ORDER BY, with no visible effect. At what point in time is the data actually sorted -- when the data is selected into...

Greetings, Dima We are (trying to) sort rows. Am in the process of learning SQL, PL/SQL, Oracle FORMS & REPORTS. Massive learning curve. Ken Thompson, Programmer & Mainframe Dinosaur

Will check that. Will also try specifying a different column in the ORDER BY, just to make sure that this is NOT just a perception problem. Ken Thompson, Programmer & Mainframe Dinosaur

The data on the form was not in sequence by the columns specified in the ORDER BY clause. In fact, it was in the order of appearance in the table from which it was extracted. tke

Cancel above query. Turns out we were running afoul of the 1000 item limit in an &quot;IN&quot; clause. Set up a counter to break &quot;IN&quot; range into smaller (<=1000) element segments.

In FORMS, using a DataBlock Wizard to create block for tabular form. There is an 'ORDER BY' clause specified in the property pallette for the block; seems to be ignored. How do we do a sort in this case, pls?

Beg pardon -- forgot specifics. Forms 6i, on Oracle 8i database. tke

In FORMS, in a procedure, we are building an IN clause for a SELECT in a variable by concatenating numeric values. DECLARE v_str varchar2(32760); . . IF v_str IS NOT NULL THEN v_str := v_str || ', ' || i_stars_no; ELSE v_str := i_stars_no; /* first time */ END IF; We are getting an...

Had a similar situation with a record group. Customer wanted a check-box on each record, set up so that once checked, could not be un-checked. Tried to use SET_ITEM_INSTANCE_PROPERTY, didn't work. Ended up using a radio group, w/ one of the buttons visible and the other hidden. Customer...

Believe the multi-byte character refers to the fact that some languages (mainly non-european?) have more characters than can be represented in the normal ASCII or EBCDIC code ranges. So some hex values are designated as &quot;prefix&quot; codes, and can be followed by up to 254(?) values, to...