Hello, I think maybe I should assign my macro to another event, perhaps one associated with the form to work, I do not know, my idea is just. Tempted now assigned to mouse button released event of a button called Calculate Total. regards, Yessica
2013/2/1 Yessica Brinkmann <yessica.brinkm...@gmail.com> > 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 >>> >> >> >
