Error application using Powerbuilder 7 and postgresql 7.3
От | agus liem |
---|---|
Тема | Error application using Powerbuilder 7 and postgresql 7.3 |
Дата | |
Msg-id | 40CDD09B.8050303@gmx.net обсуждение исходный текст |
Ответы |
Re: Error application using Powerbuilder 7 and postgresql
|
Список | pgsql-general |
Hai.. I introduce myself, my name : Agus, from Indonesia. Im develop application using POwerbuilder 7 and postgresql 7.3. I have serveral error, and cannot solve yet. Anybody help me? This is the error : 1. When I connecct postgresql using powerbuilder , there is message like this ... Catalog tables could not be created and are not available for use Why ? 2. When I login to my application , sometimes raise error like this... SQLSTATE = 28000 FATAL : Sorry, too many clients already Why? What is the solution 2. There are 5000 rows, then there are report call query like this SELECT so_hd.* so_dt.kd_barang , so_dt.qty_kecil , so_dt.harga , so_dt.mod_date , so_dt.user_id , so_dt.no_so , so_dt.qty_besar , so_dt.outstanding_qty_besar , so_dt.outstanding_qty_kecil , so_dt.kd_kelompok_brg , so_dt.price_list , so_dt.potongan , so_dt.jumlah , so_dt.keterangan , so_dt.disc_total , mst_salesman.nama_salesman , so_dt.disc , mst_salesman.komisi , mst_barang.kd_satuan , po_dt.disc , po_dt.harga FROM {oj so_hd LEFT OUTER JOIN so_dt ON so_hd.no_so = so_dt.no_so} , mst_barang , mst_salesman , po_dt WHERE ( so_dt.kd_barang = mst_barang.kd_barang ) and ( so_dt.kd_kelompok_brg = mst_barang.kd_kelompok_brg ) and ( so_hd.kd_salesman = mst_salesman.kd_salesman ) and ( so_dt.no_so = po_dt.no_so ) and ( so_dt.kd_barang = po_dt.kd_barang ) and ( so_dt.kd_kelompok_brg = po_dt.kd_kelompok_brg ) and ( ( so_hd.tgl_so >= :adt_tgl1 ) and ( so_hd.tgl_so <= :adt_tgl2 ) and ( so_hd.closed = '1' ) ) when running aplication call this report, application become hang. Why ? there is solution? 4. There are some report become hang . The transaction is few but design report using sub report. Is it cause hang? is there the solustion ? 3. There is error like this... Sybase Inc. Product File has encountered a problem and needs to close When I using report window for query and access thousand record transcaction. Why ? Any suggestion thx Agus
В списке pgsql-general по дате отправления: