Recent content by ironic100

Thanks Dima, but this seems to work only for one name i.e. a single string without whitespace. What I really need is a way to intialise ALL the names that are input into the 'first_name' field. For example if I input my name as: first_name: John Albert Downs last_name: Smith The 'initials'...

I have a field in my screen called First Name and another field called Initials. I need to make it so that when I enter a first name, the initials field populates with the initals of however many first names there are. For example, Tom Green Jones should come up as T G (assuming Jones is a...

Hi Guys, this query works fine: SELECT pol.policy_no, pl.planno, pl.plan_name, NVL(MAX(pol.pol_stat),' '), NVL(MAX(d.description),' ') stat_descn, NVL(SUM(ua.units_allocated * fv.bid_price), 0) pol_value, NVL(MAX(psc.fees), 0) penalty, c.description...

Does anyone know how to create a page break when you create a form-letter in reports 6i? Thanks

thanks nagornyi i think i have it. i deleted the second to_date and it seems to work with the parameters being strings. i'm now trying to concatenate the two together so the user first inputs the date then the time in a seperate box, any ideas? thanks.

I am trying to select records where the parameter date is greater than/equal to a record in PA_TRANS. I want to have a date and time comparison to the records in the table. It works for only for the date portion i.e. dd/mmm/rrrr as in below: SELECT t.SITENO, t.PA_TRANSNO, t.PA_TR_COMM...