Massimo Arnaudo wrote: > Hi everibody, > i have a problem when i try to insert the second invoice of a suppliers > i get this error message: > > Error! > > INSERT INTO acc_trans (trans_id, chart_id, amount, > transdate) > VALUES (10323, (SELECT id FROM chart > WHERE accno = ), > -30.00, '31/05/2002') > ERROR: parser: parse error at or near ")" > > I saw in archive that is probably an error of a old version of postgres, > but i work with 7.2. > >
Hi, i have found that the problem is made by the articles. If i put in a new invoice an old article, the program advise me with the error message: if i insert a new product, it work fine. Any suggestions? Best regards. -- Massimo Arnaudo Tesoriere http://www.croceverdequarto.it _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ Listinfo https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.geocrawler.com/redir-sf.php3?list=sql-ledger-users
