Hello, thank you very much for the reply. The table name is cliente, as shown in the print screen attached to my previous mail. Actually I tried already to put quotes in many ways to the table names and columns but never works for me. Regards, Yessica
2013/2/1 Ariel Constenla-Haile <arie...@apache.org> > 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 >
