sql-ledger-users — SQL-Ledger users

Re: [SL] Add a new currency

[Luc v. S. <lu...@co...>]

I wil start with waiting a day, As I rather not touch the database. 
Tommorrow we will see

Thanks for your reply

Ashley J Gittins wrote:
> On Tuesday 28 November 2006 21:01, Luc van Stappershoef wrote:
>   
>> This thread came right in time because I just had to make my first
>> "other currency" purchasing order and it worked. The only thing is I put
>> in the exchange rate wrong ( 1/x). So no worries I thought just delete
>> the just made purchasing order and make a new one.
>>
>> But that doesn't work. Somehow it keeps coming back with the same
>> exhange rate which I can not alter. Looking through the archives I saw
>> somebody wanting to have diffrent exchage rate in one day ( wich did not
>> work either).
>>
>> Is the solution to wait one day and can I have a new exchange rate
>> tomorrow ? Or is their another way I should handle this problem?
>>
>> Thanks in advance for your quick reply
>>
>> Luc
>>     
>
> The only way I have found (although I expect your plan to wait a day will also 
> work) is to directly update the database with a new or corrected exchange 
> rate for that day. The table named "exchangerate" has a listing of exchange 
> rates by date so you can modify that easily enough without affecting other 
> areas of the system (afaik).
>
>   

Re: [SL] Add a new currency

[Ashley J G. <agi...@pu...>]

On Tuesday 28 November 2006 21:01, Luc van Stappershoef wrote:
> This thread came right in time because I just had to make my first
> "other currency" purchasing order and it worked. The only thing is I put
> in the exchange rate wrong ( 1/x). So no worries I thought just delete
> the just made purchasing order and make a new one.
>
> But that doesn't work. Somehow it keeps coming back with the same
> exhange rate which I can not alter. Looking through the archives I saw
> somebody wanting to have diffrent exchage rate in one day ( wich did not
> work either).
>
> Is the solution to wait one day and can I have a new exchange rate
> tomorrow ? Or is their another way I should handle this problem?
>
> Thanks in advance for your quick reply
>
> Luc

The only way I have found (although I expect your plan to wait a day will also 
work) is to directly update the database with a new or corrected exchange 
rate for that day. The table named "exchangerate" has a listing of exchange 
rates by date so you can modify that easily enough without affecting other 
areas of the system (afaik).

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] Add a new currency

[Luc v. S. <lu...@co...>]

This thread came right in time because I just had to make my first 
"other currency" purchasing order and it worked. The only thing is I put 
in the exchange rate wrong ( 1/x). So no worries I thought just delete 
the just made purchasing order and make a new one.

But that doesn't work. Somehow it keeps coming back with the same 
exhange rate which I can not alter. Looking through the archives I saw 
somebody wanting to have diffrent exchage rate in one day ( wich did not 
work either).

Is the solution to wait one day and can I have a new exchange rate 
tomorrow ? Or is their another way I should handle this problem?

Thanks in advance for your quick reply

Luc

Neil Johnson wrote:
> Many thanks.
>
> Neil
>
>
>
> Graeme Bruton wrote:
>   
>> There is a place on the invoice screen to manually change the currency and
>> exchange rate. I use it if I purchase software in USD, and sell it in the
>> local currency. If you put your currency first in the list under the
>> "System" settings, it is the default. When you change the invoice screen to
>> a different currency, the exchange rate field becomes available.
>>
>>
>>
>> -----Original Message-----
>> From: sql...@li...
>> [mailto:sql...@li...]On Behalf Of Neil
>> Johnson
>> Sent: Tuesday, November 28, 2006 1:50 AM
>> To: sql...@li...
>> Subject: Re: [SL] Add a new currency
>>
>>
>> and the exchange rate.......?
>>
>>
>> Graeme Bruton wrote:
>>   
>>     
>>> Hi Srimal
>>>
>>> Quite simple - go to "System" on the left menu, add your currency in the
>>> right hand frame, separated by a colon.
>>>
>>> Graeme
>>>
>>> -----Original Message-----
>>> From: sql...@li...
>>> [mailto:sql...@li...]On Behalf Of
>>> Srimal Jayawardena
>>> Sent: Monday, November 27, 2006 7:54 PM
>>> To: sql...@li...
>>> Subject: [SL] Add a new currency
>>>
>>>
>>> Hi
>>>
>>> Im rather new to sql-ledger..but am impressed by its versatality.
>>>
>>> Could anyone tell me how to add a new currency ?
>>>
>>> Thanks in advance
>>>
>>> Srimal.
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>>     
>>>       
>> your
>>   
>>     
>>> opinions on IT & business topics through brief surveys - and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>> -------------------------------------------------------------------------
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>>     
>>>       
>> your
>>   
>>     
>>> opinions on IT & business topics through brief surveys - and earn cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>> _______________________________________________
>>> sql-ledger-users mailing list
>>> sql...@li...
>>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>>
>>>
>>>     
>>>       
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>   
>>     
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   

Re: [SL] Upgrade problem

[Adrian B. <adr...@ie...>]

Progress:

the error is now:

DBD::Pg::st execute failed: ERROR: column t.validto does not exist
.
.
.

ERROR: column t.validto does not exist

I should add, I had a hard disk crash but I could do a pg_dumpall & SQL-Ledger is the only database. I have had to upgrade from 
postgres 7.? to 8.1.?

Adrian

Dieter Simader wrote:
> edit the backup you made with SQL-Ledger,
> change the tables orderitems, inventory and assembly and add 'WITH OIDS'
> (see the FAQ)
> restore the backup with psql
> 
> psql -U sql-ledger dbname < backup.sql
> 

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

Re: [SL] Corrupting Access

[nefsoft <in...@ne...>]

Lane,

i'll advice to use the owner of the database self as owner of the tables:
on my box i've :

CREATE DATABASE prod
  WITH OWNER =3D "sql-ledger"
       ENCODING =3D 'LATIN9'
       TABLESPACE =3D pg_default;

you can see that in pgadmin3 by clicking on the db name that you want.

for the users, i've only these 2:
CREATE USER postgres
  WITH SYSID 1
  ENCRYPTED PASSWORD 'md52f001c210c241d8ec746617694853b43'
  CREATEDB CREATEUSER;
CREATE USER "sql-ledger"
  WITH SYSID 100
  ENCRYPTED PASSWORD 'md54392a91bc26740bbaeff738cc34c2735'
  CREATEDB CREATEUSER;

in your case i think that lane is not an user database. if yes, u can make
it owner of the db and owner of all tables, restart the db and should works
too.

good luck
kasem

2006/11/27, Lane Sharman <la...@op...>:
>
>                List of relations
> Schema |      Name      |   Type   |   Owner
> --------+----------------+----------+------------
> public | acc_trans      | table    | sql-ledger
> public | ap             | table    | sql-ledger
> public | ar             | table    | sql-ledger
> public | assembly       | table    | sql-ledger
> public | audittrail     | table    | lane
> public | business       | table    | lane
>
>
> shows that my ownership is partially corrupted. Normally, all datatbase
> tables are owned by sql-ledger. So, I will change the owner to
> sql-ledger? Please advise.
>
> thanks, Kasem.
>
> Lane
>
> Nefnifi, Kasem wrote:
>
> >Hi Lane,
> >
> >Logon into your db as DBA using pgadmin3 (use may be sql-ledger or
> >postgres user),
> >Grant permissions to the user lane.
> >So the problem should be solved.
> >Kasem,
> >
> >
> >-----Original Message-----
> >From: Lane Sharman [mailto:la...@op...]
> >Sent: maandag 27 november 2006 5:35
> >To: sql...@sq...
> >Subject: [SL] Corrupting Access
> >
> >I have corrupted access to my most important data set. Call it A. And
> >call the user lane.
> >
> >Basically, in admin mode, I set up dataset B and saved the user as lane.
> >That was a big mistake. Now I cannot get into dataset A under any
> >user:
> >
> >DBD::Pg::st execute failed: ERROR: permission denied for relation
> >customer at SL/Form.pm line 1823.
> >
> >
> >    Error!
> >
> >SELECT ct.name AS customer, a.curr AS currency, a.customer_id,
> >current_date + ct.terms AS duedate, a.department_id,
> >d.description AS department, ct.notes, ct.curr AS currency
> >FROM ar a
> >JOIN customer ct ON (a.customer_id =3D ct.id)
> >LEFT JOIN department d ON (a.department_id =3D d.id)
> >WHERE a.id =3D 10452
> >ERROR: permission denied for relation customerDatabase handle destroyed
> >without explicit disconnect.
> >
> >
> >
>
>
> --
> Kindest Regards,
>
> Lane Sharman
> 858-755-2868
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>


--=20
Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / Freundlic=
he
Gr=FC=DFe !!!
NEFSOFT
St. Truidensesteeweg, 263
3300 Tienen (Belgium)
Tel : +32 16 78 09 38
Fax : +32 16 82 04 58
GSM : +32 495 25 12 33
Email : in...@ne...
www.nefsoft.com

Re: [SL] Add a new currency

[Neil J. <nei...@ma...>]

Many thanks.

Neil



Graeme Bruton wrote:
> There is a place on the invoice screen to manually change the currency and
> exchange rate. I use it if I purchase software in USD, and sell it in the
> local currency. If you put your currency first in the list under the
> "System" settings, it is the default. When you change the invoice screen to
> a different currency, the exchange rate field becomes available.
>
>
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Neil
> Johnson
> Sent: Tuesday, November 28, 2006 1:50 AM
> To: sql...@li...
> Subject: Re: [SL] Add a new currency
>
>
> and the exchange rate.......?
>
>
> Graeme Bruton wrote:
>   
>> Hi Srimal
>>
>> Quite simple - go to "System" on the left menu, add your currency in the
>> right hand frame, separated by a colon.
>>
>> Graeme
>>
>> -----Original Message-----
>> From: sql...@li...
>> [mailto:sql...@li...]On Behalf Of
>> Srimal Jayawardena
>> Sent: Monday, November 27, 2006 7:54 PM
>> To: sql...@li...
>> Subject: [SL] Add a new currency
>>
>>
>> Hi
>>
>> Im rather new to sql-ledger..but am impressed by its versatality.
>>
>> Could anyone tell me how to add a new currency ?
>>
>> Thanks in advance
>>
>> Srimal.
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>     
> your
>   
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>     
> your
>   
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>>     
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] Upgrade problem

[Dieter S. <dsi...@sq...>]

edit the backup you made with SQL-Ledger,
change the tables orderitems, inventory and assembly and add 'WITH OIDS'
(see the FAQ)
restore the backup with psql

psql -U sql-ledger dbname < backup.sql

-- 
Dieter Simader       http://www.sql-ledger.com   Tel: (780) 472-8161
DWS Systems Inc.        Accounting Software      Fax: (780) 478-5281
============== On a clear disk you can seek forever ================

On Tue, 28 Nov 2006, Adrian Blake wrote:

> I was forced to do an upgrade and now have the following error:
>
> DBD::Pg::st execute failed: ERROR: column o.oid does not exist
> .
> .
> .
>
> ERROR: column o.oid does not exist
>
>
> The FAQ has the following :Drop the tables and rebuild WITH OIDS
>
> I have my O'Reilly " Practical PostgreSQL" handy, but still do not understand how to "Drop the tables and rebuild WITH OIDS"
>
> Adrian
>

Re: [SL] [sl] inventory donated to charity____

[Ashley J G. <agi...@pu...>]

On Tuesday 28 November 2006 01:38, R Pennington wrote:
> On Friday 24 November 2006 9:34 am, Nefnifi, Kasem wrote:
> > i think an invoice with 100% discount is the solution for that. also if u
> > use something internally for yoursel. regards
> > kasem,
>
> Thank you for your advice Kasem !
> I'll have to to re-read the manual section about discounts

Hi Roy, I suspect you were on the right path with the invoice then pay from 
donations account. If you discount the item 100% then you will not be able to 
pay the invoice from the donations account and you will lose the ability to 
show your charitable donations in your balance sheet / income statement etc.

Your accountant might be the best one to start answering the question - find 
out what the end result needs to be (eg: a GL account showing donations to 
charity as an expense account), and then find a way to do that in SL while 
keeping stock etc correct. I suspect your first idea was probably the best 
approach but others might have better ideas.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] Add a new currency

[Graeme B. <gb...@te...>]

There is a place on the invoice screen to manually change the currency and
exchange rate. I use it if I purchase software in USD, and sell it in the
local currency. If you put your currency first in the list under the
"System" settings, it is the default. When you change the invoice screen to
a different currency, the exchange rate field becomes available.



-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of Neil
Johnson
Sent: Tuesday, November 28, 2006 1:50 AM
To: sql...@li...
Subject: Re: [SL] Add a new currency


and the exchange rate.......?


Graeme Bruton wrote:
> Hi Srimal
>
> Quite simple - go to "System" on the left menu, add your currency in the
> right hand frame, separated by a colon.
>
> Graeme
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of
> Srimal Jayawardena
> Sent: Monday, November 27, 2006 7:54 PM
> To: sql...@li...
> Subject: [SL] Add a new currency
>
>
> Hi
>
> Im rather new to sql-ledger..but am impressed by its versatality.
>
> Could anyone tell me how to add a new currency ?
>
> Thanks in advance
>
> Srimal.
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Upgrade problem

[Adrian B. <adr...@ie...>]

I was forced to do an upgrade and now have the following error:

DBD::Pg::st execute failed: ERROR: column o.oid does not exist
.
.
.

ERROR: column o.oid does not exist


The FAQ has the following :Drop the tables and rebuild WITH OIDS

I have my O'Reilly " Practical PostgreSQL" handy, but still do not understand how to "Drop the tables and rebuild WITH OIDS"

Adrian
-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30

Re: [SL] Add a new currency

[Neil J. <nei...@ma...>]

and the exchange rate.......?


Graeme Bruton wrote:
> Hi Srimal
>
> Quite simple - go to "System" on the left menu, add your currency in the
> right hand frame, separated by a colon.
>
> Graeme
>
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of
> Srimal Jayawardena
> Sent: Monday, November 27, 2006 7:54 PM
> To: sql...@li...
> Subject: [SL] Add a new currency
>
>
> Hi
>
> Im rather new to sql-ledger..but am impressed by its versatality.
>
> Could anyone tell me how to add a new currency ?
>
> Thanks in advance
>
> Srimal.
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] Add a new currency

[Graeme B. <gb...@te...>]

Hi Srimal

Quite simple - go to "System" on the left menu, add your currency in the
right hand frame, separated by a colon.

Graeme

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of
Srimal Jayawardena
Sent: Monday, November 27, 2006 7:54 PM
To: sql...@li...
Subject: [SL] Add a new currency


Hi

Im rather new to sql-ledger..but am impressed by its versatality.

Could anyone tell me how to add a new currency ?

Thanks in advance

Srimal.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Add a new currency

[Srimal J. <sr...@ma...>]

Hi

Im rather new to sql-ledger..but am impressed by its versatality.

Could anyone tell me how to add a new currency ?

Thanks in advance

Srimal.

Re: [SL] Corrupting Access

[Lane S. <la...@op...>]

ok. I fixed it. here is the background.

see http://archives.postgresql.org/pgsql-novice/2001-01/msg00290.php for 
changing the Owner of a table.

here is the transcript of the sql:

=# select usesysid from pg_user where usename = 'sql-ledger';
=# select usesysid from pg_user where usename = 'lane';

with the above integer values:
=# update pg_class set relowner=101 where relowner=103;
uniformly assigns the ID of sql-ledger to all of your tables.

Lane

Lane Sharman wrote:

>                List of relations
> Schema |      Name      |   Type   |   Owner   
>--------+----------------+----------+------------
> public | acc_trans      | table    | sql-ledger
> public | ap             | table    | sql-ledger
> public | ar             | table    | sql-ledger
> public | assembly       | table    | sql-ledger
> public | audittrail     | table    | lane
> public | business       | table    | lane
>
>
>shows that my ownership is partially corrupted. Normally, all datatbase 
>tables are owned by sql-ledger. So, I will change the owner to 
>sql-ledger? Please advise.
>
>thanks, Kasem.
>
>Lane
>
>Nefnifi, Kasem wrote:
>
>  
>
>>Hi Lane, 
>>
>>Logon into your db as DBA using pgadmin3 (use may be sql-ledger or
>>postgres user),
>>Grant permissions to the user lane.
>>So the problem should be solved.
>>Kasem,
>>
>>
>>-----Original Message-----
>>From: Lane Sharman [mailto:la...@op...] 
>>Sent: maandag 27 november 2006 5:35
>>To: sql...@sq...
>>Subject: [SL] Corrupting Access
>>
>>I have corrupted access to my most important data set. Call it A. And
>>call the user lane.
>>
>>Basically, in admin mode, I set up dataset B and saved the user as lane.
>>That was a big mistake. Now I cannot get into dataset A under any
>>user:
>>
>>DBD::Pg::st execute failed: ERROR: permission denied for relation
>>customer at SL/Form.pm line 1823.
>>
>>
>>   Error!
>>
>>SELECT ct.name AS customer, a.curr AS currency, a.customer_id,
>>current_date + ct.terms AS duedate, a.department_id,
>>d.description AS department, ct.notes, ct.curr AS currency
>>    
>>
>>FROM ar a
>  
>
>>JOIN customer ct ON (a.customer_id = ct.id)
>>LEFT JOIN department d ON (a.department_id = d.id)
>>WHERE a.id = 10452
>>ERROR: permission denied for relation customerDatabase handle destroyed 
>>without explicit disconnect.
>>
>> 
>>
>>    
>>
>
>
>  
>


-- 
Kindest Regards,

Lane Sharman
858-755-2868

Re: [SL] Corrupting Access

[Lane S. <la...@op...>]

                List of relations
 Schema |      Name      |   Type   |   Owner   
--------+----------------+----------+------------
 public | acc_trans      | table    | sql-ledger
 public | ap             | table    | sql-ledger
 public | ar             | table    | sql-ledger
 public | assembly       | table    | sql-ledger
 public | audittrail     | table    | lane
 public | business       | table    | lane


shows that my ownership is partially corrupted. Normally, all datatbase 
tables are owned by sql-ledger. So, I will change the owner to 
sql-ledger? Please advise.

thanks, Kasem.

Lane

Nefnifi, Kasem wrote:

>Hi Lane, 
>
>Logon into your db as DBA using pgadmin3 (use may be sql-ledger or
>postgres user),
>Grant permissions to the user lane.
>So the problem should be solved.
>Kasem,
>
>
>-----Original Message-----
>From: Lane Sharman [mailto:la...@op...] 
>Sent: maandag 27 november 2006 5:35
>To: sql...@sq...
>Subject: [SL] Corrupting Access
>
>I have corrupted access to my most important data set. Call it A. And
>call the user lane.
>
>Basically, in admin mode, I set up dataset B and saved the user as lane.
>That was a big mistake. Now I cannot get into dataset A under any
>user:
>
>DBD::Pg::st execute failed: ERROR: permission denied for relation
>customer at SL/Form.pm line 1823.
>
>
>    Error!
>
>SELECT ct.name AS customer, a.curr AS currency, a.customer_id,
>current_date + ct.terms AS duedate, a.department_id,
>d.description AS department, ct.notes, ct.curr AS currency
>FROM ar a
>JOIN customer ct ON (a.customer_id = ct.id)
>LEFT JOIN department d ON (a.department_id = d.id)
>WHERE a.id = 10452
>ERROR: permission denied for relation customerDatabase handle destroyed 
>without explicit disconnect.
>
>  
>


-- 
Kindest Regards,

Lane Sharman
858-755-2868

Re: [SL] [sl] inventory donated to charity____

[R P. <arc...@mt...>]

On Friday 24 November 2006 9:34 am, Nefnifi, Kasem wrote:
> i think an invoice with 100% discount is the solution for that. also if u use something internally for yoursel.
> regards
> kasem,

Thank you for your advice Kasem !
I'll have to to re-read the manual section about discounts 

Cheers !
Roy

Re: [SL] [OT] Low and high language

[GeorgeOsvald <geo...@ya...>]

On Tuesday 28 November 2006 00:07, Markus Schiltknecht wrote:
> Hi,
>
> Clemens Dorfner wrote:
> >>> Moreover, ``High German'' and ``Low German'' refer to the altitude of
> >>> the places they are spoken in.
> >
> > As I am a German: thats plainly wrong!
>
> I'm Swiss, and I can assure you Clemens is 99.999% right.
>
> > but Hochdeutsch simply names the german, which is taught in school and
> > is understood by the 99% of german speaking people. This has nothing
> > to do with quality!

We bought a new fridge last week. Just thought you might wanna know.

Re: [SL] [OT] Low and high language

[<to...@in...>]

Come on guys, please take this off list. This isnt the place for this sor=
t
of discussion, regardless of who is right/wrong/etc.

This is for SQL-ledger related discussions, and this stuff isnt related b=
y
even a longshot..

Re: [SL] [OT] Low and high language

[Markus S. <ma...@bl...>]

Hi,

Clemens Dorfner wrote:
>>> Moreover, ``High German'' and ``Low German'' refer to the altitude of
>>> the places they are spoken in. 
> As I am a German: thats plainly wrong!

I'm Swiss, and I can assure you Clemens is 99.999% right.

> but Hochdeutsch simply names the german, which is taught in school and 
> is understood by the 99% of german speaking people. This has nothing
> to do with quality!

That's where I don't quite agree. I got the impression, that High German 
is called so because the High Society prefers to speak it. So as to 
distinguish itself from the plebs, who speaks dialects, which does not 
sound as international and commonly understandable.

Anyway, we Swiss have a very schizophrenic attitude towards High German, 
so I'm certainly biased.

Regards

Markus

Re: [SL] Low and high language (was: Je me souviens!)

[Clemens D. <Cle...@sc...>]

Hi all,

I know, this don't belongs to the list, but there is a bit of=20
information, I have to correct:

Somebody wrote:
>> Moreover, ``High German'' and ``Low German'' refer to the altitude of
>> the places they are spoken in.=20
As I am a German: thats plainly wrong!

As Roy P quoted later: Hochdeutsch - high german is the grammaticaly=20
very exact described form of common used german, closely related to=20
written german - Schriftdeutsch. The nearly offical reference for that=20
is the "Duden", which is updated yearly.
The derived dialects Bayrisch, Schw=C3=A4bisch, S=C3=A4chsisch, Plattdeut=
sch=20
belong to their locality they appear. Especially Bayrisch - the bavarian=20
dialect- which belongs to the highest regions of germany, is in parts=20
very different from Hochdeutsch.

I cant state, what the terms high or low language mean in english or=20
french;
but Hochdeutsch simply names the german, which is taught in school and=20
is understood by the 99% of german speaking people. This has nothing
to do with quality!


A quote of the quote of Roy P:
> Low German or Plattdeutsch=20
> Any dialect that differs from High German."
This is misleading, too. There is no "Low German". We have Hochdeutsch=20
and the derived dialects - one of them is Plattdeutsch, another Bayerisch=
.

Just to correct some misinformations.
Clemens Dorfner
--=20
Schloss-Hotel Hirschau - Hauptstr.1 - 92242 Hirschau - Tel. 09622/70100
www.schloss-hirschau.de                                Fax 09622/701040

Re: [SL] Corrupting Access

[Nefnifi, K. <Kas...@at...>]

Hi Lane,=20

Logon into your db as DBA using pgadmin3 (use may be sql-ledger or
postgres user),
Grant permissions to the user lane.
So the problem should be solved.
Kasem,


-----Original Message-----
From: Lane Sharman [mailto:la...@op...]=20
Sent: maandag 27 november 2006 5:35
To: sql...@sq...
Subject: [SL] Corrupting Access

I have corrupted access to my most important data set. Call it A. And
call the user lane.

Basically, in admin mode, I set up dataset B and saved the user as lane.
That was a big mistake. Now I cannot get into dataset A under any
user:

DBD::Pg::st execute failed: ERROR: permission denied for relation
customer at SL/Form.pm line 1823.


    Error!

SELECT ct.name AS customer, a.curr AS currency, a.customer_id,
current_date + ct.terms AS duedate, a.department_id,
d.description AS department, ct.notes, ct.curr AS currency
FROM ar a
JOIN customer ct ON (a.customer_id =3D ct.id)
LEFT JOIN department d ON (a.department_id =3D d.id)
WHERE a.id =3D 10452
ERROR: permission denied for relation customerDatabase handle destroyed=20
without explicit disconnect.

--=20
Kindest Regards,

Lane Sharman
858-755-2868

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Je me souviens!

[Roy P <or...@sh...>]

On Sunday 26 November 2006 22:24, Stuart Luppescu wrote:
> On =E6=97=A5, 2006-11-26 at 20:34 -0600, John Hasler wrote:
> > Because qu=C3=A9b=C3=A9cois and parisian are two different dialects of =
french.
> > Neither is "higher" or "lower", but they are different.
>
> Moreover, ``High German'' and ``Low German'' refer to the altitude of
> the places they are spoken in.=20

OK since everyone seems  to want to make this a thread I'll just go with th=
e=20
flow for a bit.

=46or some reason people think higher and lower have some qualitative inten=
t.=20

In my understanding, "Lower" in this case usually refers to a derived diale=
ct=20
that is less common.=20
I have also seen the definition "linguistically subordinate" used.
It's NOT a qualitative term.


In regards to High German and Low German referring to usage locations..
There is a quote that explains it better than I can...

=2D----------------
"The common, though technically incorrect linguistically, use of these term=
s=20
is:=20
High German or Hochdeutsch=20
The official language of Germany as promulgated in the schools, the press, =
the=20
broadcast media, and specifically in the dictionary series called the Duden=
=2E=20

Low German or Plattdeutsch=20
Any dialect that differs from High German."
=2D---------------------------

That common, non technical definition quoted above, is the same as used by =
my=20
German born In-laws who speak Low German and my German born grandmother who=
=20
spoke High German and the local language school I took basic German from 25=
=20
years ago.

There is nothing to say that Low German is inferior in any way no matter wh=
ich=20
definition of the term you use.
(It was the 1st language of my wife so if anyone thinks it inferior she may=
=20
come over and punch you..!! LOL )


Here's is what I mean by lower and higher languages
Languages are derived from others historically preceding it.
Hence American, Australian and Canadian English ARE sub-dialects/lower form=
s=20
of Formal English.=20
or.....Cajun is a sub-dialect/lower form of Acadian French which is a=20
sub-dialect/lower form of French as spoken in France.

It's not snobbish at all....It's the hierarchy of what you could call=20
the "family tree" of languages


A recap of my thoughts from my original post:
1) Learning as many languages as possible is a very good thing.
2) Learning a dialect is not a good idea. It's better to learn a more,=20
universal, higher form to increase your chances of being easily=20
understood by as many people as possible.


Regards,
Roy


AND PLEASE..  if you want to reply to me on this topic, then do it directly=
=2E..=20
I can CC: everyone else in the thread if they wish.=20
I don't think other list members subscribed to "SQL-ledger users", want to=
=20
sift through this type of off topic discussion. I will truly welcome your=20
emails, since I enjoy discussions like this. I only wish we could all do it=
=20
over some coffee.

Re: [SL] Refund Checks

[<ma...@hu...>]

> Mark Bucciarelli wrote:
>>
>> Yes, you have found an area that doesn't work well.
>>
> I think doesn't work well is a bit of an understatement!

The only reason it doesn't work well for the OP is that he has policies in
place that prohibit him from cutting a manual check.  I would guess this
requirement has not come up too often to date for DS.  Now it has.

Maybe you can help make the case that it's worth his time to put into the
system.  Good luck!

m

[SL] Corrupting Access

[Lane S. <la...@op...>]

I have corrupted access to my most important data set. Call it A. And 
call the user lane.

Basically, in admin mode, I set up dataset B and saved the user as 
lane.  That was a big mistake. Now I cannot get into dataset A under any 
user:

DBD::Pg::st execute failed: ERROR: permission denied for relation 
customer at SL/Form.pm line 1823.


    Error!

SELECT ct.name AS customer, a.curr AS currency, a.customer_id,
current_date + ct.terms AS duedate, a.department_id,
d.description AS department, ct.notes, ct.curr AS currency
FROM ar a
JOIN customer ct ON (a.customer_id = ct.id)
LEFT JOIN department d ON (a.department_id = d.id)
WHERE a.id = 10452
ERROR: permission denied for relation customerDatabase handle destroyed 
without explicit disconnect.

-- 
Kindest Regards,

Lane Sharman
858-755-2868

Re: [SL] Je me souviens! Was:Re: Swedish SQL-ledger 2.6.20, To buy a computer: no right account number

[Stuart L. <sl...@cc...>]

On 日, 2006-11-26 at 20:34 -0600, John Hasler wrote:
> Because québécois and parisian are two different dialects of french.
> Neither is "higher" or "lower", but they are different. 

Moreover, ``High German'' and ``Low German'' refer to the altitude of
the places they are spoken in. High German is spoken in areas of higher
elevation, e.g., the mountains of Bavaria; Low German is spoken in the
low-lying areas near the north coast. So, ``high'' and ``low'' do not
denote value, but, rather, geography. Here's a quote from Wikipedia:

The High German languages (in German, Hochdeutsch) are any of the
varieties of standard German, Luxembourgish and Yiddish as well as the
local German dialects spoken in central and southern Germany, in
Austria, in Liechtenstein, in Switzerland, in Luxembourg and in
neighbouring portions of Belgium, France (Alsace and northern Lorraine),
Italy and Poland. It is also spoken in former colonial settlements, for
instance in Romania (Transylvania), Russia, U.S. or Namibia.

"High" refers to the mountainous areas of central and southern Germany
and the Alps, as opposed to Low German spoken along the flat sea coasts
of the north. High German can be subdivided into Upper German and
Central German (Oberdeutsch, Mitteldeutsch).

(From: http://en.wikipedia.org/wiki/High_German_languages)

-- 
Stuart Luppescu -=- s-luppescu .at. uchicago.edu        
University of Chicago (^_^)/ CCSR 
才文と智奈美の父 -=-=- Kernel 2.6.17-gentoo-r
If I set here and stare at nothing long enough,
<people might think I'm an engineer working on
<something.   -- S.R. McElroy