Re: Various Forms Questions

Angel Perez wrote:

> Hi all,
>
> I have four questions some of them I posted before but was unable to
>
> see if they were answered or not, so excuse me if I get a little
> "repeating". Here they go:
>
> 1. - I want to know if there's a way to select the printer to send
> our
> reports to from within Forms (passing it as a parameter to Reports
> maybe?) using API's or Forms built-ins? I think it's annoying to our
> customers having to close Report Server, changing the default printer
> on
> Windows and launching the application again...
>
You can put these parameters on the command line, like:RUN PRODUCT r25run DESTYPE=destination DESFORMAT=format .....

You can select a printer by these DESTYPE and DESFORMAT parameters.

You can also pass r25run values in this same manner.

> 2. - Has anyone had problems with Oracle Forms Designer disconnecting
>
> itself from the Oracle Server? We are working with Forms 4.5.7.1.2 and
>
> Oracle 7.2 for Alpha/Win NT 3.51, and sometimes (randomly) we get
> disconnected from the DB without reason... Any light to our dark path?
>
dunno. If you think it's a client-side problem, try upgrading to newer version of forms? Dev/2000 1.3.2, which includes a newer release of forms45, is reputedly much more stable.

> 3. - Also, we want to know if there's a way to avoid the blank spaces
>
> we get on a numeric field when we use a mask. I mean when we give a
> default values to a field and then we want to input say a negative
> value
> we first have to delete al the field and then input the desired value.
>
> Is there a way to solve this?
>
When you navigate to a field at runtime, doesn't the whole field appear highlited? As soon as you type a character on my forms install, it wipes the pre-exisiting value, replacing it with whatever you type. (Windows client).

> 4. - And the last one is a bit about language problems. In Spain the
>
> decimal part of a numeric value is usually noticed by a dot(.), I mean
>
> (US) 189,89 = (SP) 189.89
> We want our customers to easilly use the numeric keypad to input
> quantities, but with the stantard masks they must mark the decimal
> with
> a comma (,). Anyone knows how can we overcome this?
>
Assuming forms and reports masks follow same rules, I looked under the r25des help for number format masks. This is handled - one option allows comma to be used as decimal separator. Help docs say use D as mask for 'local' decimal sep and G for mask as 'local' thousands separator. Where these local masks are defined, I don't know.

But looking up, that wasn't your question. You could write a trigger using SUBST to format the data before inserting it. Then users could enter it using any character as the decimal, or nothing at all (like adding machines) if your users always include the hundredths places.

> Well, that's all! Any help would be very appreciated. Anyway, best
> regards,
>
> Rafa Flores Yoldi
> cesinsl_at_redestb.es (work)
> coach_at_ctv.es (home)

Hope something above helps,
-Ian Received on Thu Jun 19 1997 - 00:00:00 CEST