Hello, sorry, I totally understand what you're saying and just tried to do so. As I had said in my previous mail, when I try to change the default saldo_actual field in the editing area of the Customer table, do not let me Base. You tell me:
- Edit the table "customer": right click on the "customer" table, select "Edit" from the context menu. Edit the field "saldo_actual", in "Default value" enter 0. Save the Table Design. I've done that several times and does not allow me Base save the table, and then the cursor is positioned right on the field saldo_actual. We tried to do several things to see if it allowed me to make that change, such as: As much as I put in value If required, I deleted all records from the customer table and Have even removed all relationships with Other tables, just do not let me, I can not just save the change made and the cursor is just saldo_actual field. I do not know if I have a problem with my version of Open Office or what is happening ... I am using Open Office 3.3.0 regards, Yessica 2013/2/3 Ariel Constenla-Haile <arie...@apache.org> > Hi Yessica, > > On Sun, Feb 03, 2013 at 02:58:58AM -0300, Yessica Brinkmann wrote: > > Hello, > > Excuse me please if I do a silly question. But the truth is that I could > > not change the default value of saldo_actual field from the cliente > table. > > As much as I put in value If required, I deleted all records from the > > cliente table and have even removed all relationships with other tables, > > just do not let me, I can not just save the changes made and the cursor > is > > just saldo_actual field. It seems very strange that there must be > something > > I'm not understanding. > > Much appreciate an answer, > > I did it using the User Interface, though I guess that could also > perform some SQL statements. In the user interface: > > - Edit the table "cliente": right click on the "cliente" table, select > "Edit" from the context menu. Edit the field "saldo_actual", in > "Default value" enter 0. Save the Table Design. > > - Open the table "cliente": if you put the cursor on the last row, in > order to insert a new record, you'll see that now saldo_actual is set > to 0 automatically. For all the existing records (in the sample DB > AURORA and OTRO CLIENTE) you will have to set it manually (or you can > execute a SQL statement). > > - Open the form: your macro works now > > > Regards > -- > Ariel Constenla-Haile > La Plata, Argentina >
