Hello, Thank you very much for the reply. Sorry, did not know that I should not put attachments. Now I have no errors in the macro, and I used the SQL UPDATE indicated. Just do not know why but UPDATE fails. So, when I check the table, I do not see the value of the changed field. I refreshed the table also but nothing. I printed the total value also to see if I was right and good. I do not know what is going wrong. Regards, Yessica
2013/2/1 Fernand Vanrie <s...@pmgroup.be> > Ariel, Yessica, > > with OObase database, table and field names are case sensitive, their is > no need to quote if: tables are lowercase and fieldnames uppercase. > > if quotes are used, then leave the dots out of the quotes > sSQL= "SELECT ""mybase"".""cliente"".""**saldo_saldo_actual"" > WHERE...................." works > > greetz > > Fernand > > On Thu, Jan 31, 2013 at 08:01:22PM -0300, Yessica Brinkmann wrote: >> >>> Hi, thanks for your answer. >>> Now I advanced. >>> I print the value of the client code correctly. >>> Only now I have another error, tells me that the Customer table does not >>> exist or something like this: >>> Basic runtime error. There was an exception. Type: >>> com.sun.star.sdbc.**SQLException. Message: Table not found in statement >>> >> This may need to quote table and fields names: >> >> sSQL="UPDATE cliente SET cliente.saldo_actual = >>> cliente.saldo_saldo_actual + "& oTotal.getCurrentValue()& " WHERE >>> cliente.id_cliente=" & CInt(sCliente) >>> >> What is the name of the table? "CLIENTES" or "clientes"? >> >> >> Regards >> > >
