Omar, rebuild the dataset from the official source and don't change the table structures if you don't know what you can change.
I had my reasons to use floats. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 2 Jun 2002, omar wrote: > I have just entered the purchase orders , and when I create the invoice and > try to post it I get the following error , I thing It has something to do > with the numeric and float, > I have changed the float to numeric before starting to work, > Can anyone tell me what can I do > Omar > > Error! > UPDATE parts SET > lastcost = 25.00, > onhand = onhand + 20.53 > WHERE id = 10084 > ERROR: Unable to identify an operator '+' for types 'numeric' and 'double > precision' > > > > _______________________________________________________________ > > 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 > _______________________________________________________________ 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
