Thanks Dieter , it worked , I was lucky that I was able to backup my data and then restor in the new dataset, I am checking the numbers I had entered , but posting invoices is working now, I will never touch someting again by the way I got an arabic printer module , i will try it next month when I return back home Omar
23/03/23 07:27:50 �, Dieter Simader <[EMAIL PROTECTED]> wrote: >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 > > _______________________________________________________________ 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
