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 -- Ariel Constenla-Haile La Plata, Argentina
pgpVW7wVmvYs2.pgp
Description: PGP signature