Re: [CK-Ledger-users] accno

[robert d. h. <rd...@st...>]

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.  :)

> 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