Steve Patrick (spatrick) writes:
> Mike, the following is from IMAGE/SQL's display map:
>
> INVOICES (INVOICES)
>     INVOICE-NO           INVOICE_NO      J4       CHAR(20)        I
> As you say, the J4 maps to a CHAR(20) and is Imprecise/Incompatible.
> I don't want ANY items, defined as J4, to be mapped to CHAR(20). So you can
> do the following, in IMAGE/SQL:
>      UPDATE TYPE J4 IN * TO DECIMAL(15,0)
 
Thanks a lot Steve!!!
I tried it and it works like a charm.  I had been trying the UPDATE
command, but obviously was doing something wrong.
Note: You do have to detach and re-attach your tables in ACCESS after you
do an update of course.
 
Again, many thanks
Mike.