Re: [CK-Ledger-users] accno

[C K Wu <ck...@ch...>]

robert del huerto wrote:

> On Thursday 23 May 2002 04:54 am, C K Wu wrote:
> > I am afraid there is some confusion over the purpose of the 'accno'
> > and the 'id' field within the 'chart' table.
> >
>
> oops, didn't see that.  Well, I deleted my tables and edited
> /ck-ledadmin/adminsetup.php.  Inside, I changed this line:
>
> $sql = "CREATE TABLE chart ($id_field, accno int UNIQUE,description text," ;
>
> to:
>
> $sql = "CREATE TABLE chart ($id_field, accno char(20) UNIQUE,description
> text," ;
>
> Then I created the chart of accounts, master data, and sample data.
>
> I looked at table 'chart' and all of the records were there.  So, I guess that
> means the install code works with the new 'acct no' type.  :)
>

Lovely.  However, you may like to watch out for something down the road.
In some of the crowded screens (eg, invoice input), account selection box
occupies quite a portion of the screen.  When the current 4-digit account# is
expanded to 12 digits or more, there may be problem with how the browser
handles the expanded selection box.  But, the whole thing will automatically
disappear, when 1280x1024 becomes the standard display :-) .

>
> > The design of   "ap.ap_accno_id, ..... " => "chart.id" (design 1), instead
> > of, "ap.ap_accno_id,...." => "chart.accno" (design 2) is to separate
> > internal pointer structure from external interface.
> >
>
> Nice.
>
> robert
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users