Re: Error in macro.
Op 02/02/2013 11:20, Yessica Brinkmann schreef:
Hello,
Yes, I write: SELECT cliente.saldo_actual FROM cliente WHERE id_cliente=0
and it works. It say: Command executed successfully.
The column name is saldo_actual , so I wrote in my last version of the
macro, which is in my previous mail.
If its run in a query, than it must also in the macro ?
TRYE to run a other macro with only the statement with the id and the
value hardcoded
Regards,
Yessica
2013/2/2 Fernand Vanrie
Op 02/02/2013 07:04, Yessica Brinkmann schreef:
Hello,
I wanted to ask if I can please help with this issue. Is that really need
to implement this functionality for my database. The macro has no errors
but UPDATE is not performed in the customer table. I do not know if you
owe
the event in which I am putting my macro, event currently in the Mouse
button released Calculate Total button. Same should work if saldo_actual
field for a record is empty it?
do the sql statement works when run from elsewhere (make a query to test)
I also see that all new users first make an introduction, I'm doing my
thesis on Computer Engineering and I am working Independent, as do
systems. I have more experience working on Java and XML, but I think this
is a nice opportunity to learn Visual Basic.
My macro is now as follows:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim rs As Object
Dim sCliente as String
Dim ColIndex as Integer
'Dim oIdPago As Object
oFrm=Evento.Source.Model.**Parent
If oFrm.hasByName("id_cliente") Then
oCliente=oFrm.getByName("id_**cliente")
Else
Print "Cannot find id_cliente"
Exit Sub
End If
rs=oFrm.createResultSet()
sCliente=rs.getString(rs.**findColumn("cod_cliente"))
oTotal=oFrm.getByName("**fmttotal")
Print sCliente
Print oTotal.getCurrentValue()
oCon=ThisDatabaseDocument.**CurrentController.**ActiveConnection
oStat=oCon.CreateStatement
sSQL = "UPDATE ""cliente"" " & "SET ""cliente"".""saldo_actual"" =" &
"
""cliente"".""saldo_actual"" + " & oTotal.getCurrentValue() & " WHERE
""cliente"".""id_cliente""=" & CInt(sCliente)
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Regards,
Yessica
2013/2/1 Yessica Brinkmann
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
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
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
Re: Error in macro.
i opened your base document , opened to edit your cliente table, close
and run your macro
now your macro works :-)
Op 03/02/2013 13:38, Fernand Vanrie schreef:
Op 02/02/2013 11:20, Yessica Brinkmann schreef:
Hello,
Yes, I write: SELECT cliente.saldo_actual FROM cliente WHERE
id_cliente=0
and it works. It say: Command executed successfully.
The column name is saldo_actual , so I wrote in my last version of the
macro, which is in my previous mail.
If its run in a query, than it must also in the macro ?
TRYE to run a other macro with only the statement with the id and the
value hardcoded
Regards,
Yessica
2013/2/2 Fernand Vanrie
Op 02/02/2013 07:04, Yessica Brinkmann schreef:
Hello,
I wanted to ask if I can please help with this issue. Is that
really need
to implement this functionality for my database. The macro has no
errors
but UPDATE is not performed in the customer table. I do not know if
you
owe
the event in which I am putting my macro, event currently in the Mouse
button released Calculate Total button. Same should work if
saldo_actual
field for a record is empty it?
do the sql statement works when run from elsewhere (make a query to
test)
I also see that all new users first make an introduction, I'm doing my
thesis on Computer Engineering and I am working Independent, as do
systems. I have more experience working on Java and XML, but I
think this
is a nice opportunity to learn Visual Basic.
My macro is now as follows:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim rs As Object
Dim sCliente as String
Dim ColIndex as Integer
'Dim oIdPago As Object
oFrm=Evento.Source.Model.**Parent
If oFrm.hasByName("id_cliente") Then
oCliente=oFrm.getByName("id_**cliente")
Else
Print "Cannot find id_cliente"
Exit Sub
End If
rs=oFrm.createResultSet()
sCliente=rs.getString(rs.**findColumn("cod_cliente"))
oTotal=oFrm.getByName("**fmttotal")
Print sCliente
Print oTotal.getCurrentValue()
oCon=ThisDatabaseDocument.**CurrentController.**ActiveConnection
oStat=oCon.CreateStatement
sSQL = "UPDATE ""cliente"" " & "SET
""cliente"".""saldo_actual"" =" &
"
""cliente"".""saldo_actual"" + " & oTotal.getCurrentValue() & " WHERE
""cliente"".""id_cliente""=" & CInt(sCliente)
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Regards,
Yessica
2013/2/1 Yessica Brinkmann
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
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
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
Re: Error in macro.
Hello, thank you very much for your answers. I created a macro as you show
me, and it works:
Sub modificacion
oCon=ThisDatabaseDocument.CurrentController.ActiveConnection
oStat=oCon.CreateStatement
sSQL = "UPDATE ""cliente"" "& "SET ""cliente"".""saldo_actual"" =" & "
""cliente"".""saldo_actual"" + " & 1000 & " WHERE
""cliente"".""id_cliente"" =" & 1
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Also my original macro works, but the problem is it only works if manually
SETTING saldo_actual field to 0 previously. That is my macro works, now my
problem is that I can not put defaults to 0 to saldo_actual field. As I had
said in my previous mail, 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.
Regards,
Yessica
2013/2/3 Fernand Vanrie
> i opened your base document , opened to edit your cliente table, close and
> run your macro
> now your macro works :-)
>
>
> Op 03/02/2013 13:38, Fernand Vanrie schreef:
>
> Op 02/02/2013 11:20, Yessica Brinkmann schreef:
>>
>>> Hello,
>>> Yes, I write: SELECT cliente.saldo_actual FROM cliente WHERE id_cliente=0
>>> and it works. It say: Command executed successfully.
>>> The column name is saldo_actual , so I wrote in my last version of the
>>> macro, which is in my previous mail.
>>>
>> If its run in a query, than it must also in the macro ?
>> TRYE to run a other macro with only the statement with the id and the
>> value hardcoded
>>
>>> Regards,
>>> Yessica
>>>
>>> 2013/2/2 Fernand Vanrie
>>>
>>> Op 02/02/2013 07:04, Yessica Brinkmann schreef:
Hello,
> I wanted to ask if I can please help with this issue. Is that really
> need
> to implement this functionality for my database. The macro has no
> errors
> but UPDATE is not performed in the customer table. I do not know if you
> owe
> the event in which I am putting my macro, event currently in the Mouse
> button released Calculate Total button. Same should work if
> saldo_actual
> field for a record is empty it?
>
> do the sql statement works when run from elsewhere (make a query to
test)
I also see that all new users first make an introduction, I'm doing my
> thesis on Computer Engineering and I am working Independent, as do
> systems. I have more experience working on Java and XML, but I think
> this
> is a nice opportunity to learn Visual Basic.
> My macro is now as follows:
> Sub ActualizarSaldoVentas (Evento)
> Dim oFrm As Object
> Dim oCliente As Object
> Dim oTotal As Object
> Dim oCon As Object
> Dim oStat As Object
> Dim sSQL As String
> Dim oRes As Object
> Dim rs As Object
> Dim sCliente as String
> Dim ColIndex as Integer
> 'Dim oIdPago As Object
> oFrm=Evento.Source.Model.Parent
> If oFrm.hasByName("id_cliente") Then
> oCliente=oFrm.getByName("id_cliente")
> Else
> Print "Cannot find id_cliente"
> Exit Sub
> End If
> rs=oFrm.createResultSet()
> sCliente=rs.getString(rs.findColumn("cod_cliente"))
> oTotal=oFrm.getByName("fmttotal")
> Print sCliente
> Print oTotal.getCurrentValue()
> oCon=ThisDatabaseDocument.CurrentController.ActiveConnection
> oStat=oCon.CreateStatement
> sSQL = "UPDATE ""cliente"" " & "SET ""cliente"".""saldo_actual""
> =" &
> "
> ""cliente"".""saldo_actual"" + " & oTotal.getCurrentValue() & " WHERE
> ""cliente"".""id_cliente""=" & CInt(sCliente)
> oRes=oStat.ExecuteQuery(sSQL)
> End Sub
> Regards,
> Yessica
> 2013/2/1 Yessica Brinkmann
>
> 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
>>
>> 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
>>>
>>> Ariel, Yessica,
>>>
with OObase database, table and field names are case sensitive,
their
is
no need to quote if: tables are lowercase and fieldnames uppe
Re: Error in macro.
Yessica ,
its a property off the cliente fields table, put 0 for default
Hello, thank you very much for your answers. I created a macro as you show
me, and it works:
Sub modificacion
oCon=ThisDatabaseDocument.CurrentController.ActiveConnection
oStat=oCon.CreateStatement
sSQL = "UPDATE ""cliente"" "& "SET ""cliente"".""saldo_actual"" =" & "
""cliente"".""saldo_actual"" + " & 1000 & " WHERE
""cliente"".""id_cliente"" =" & 1
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Also my original macro works, but the problem is it only works if manually
SETTING saldo_actual field to 0 previously. That is my macro works, now my
problem is that I can not put defaults to 0 to saldo_actual field. As I had
said in my previous mail, 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.
Regards,
Yessica
2013/2/3 Fernand Vanrie
i opened your base document , opened to edit your cliente table, close and
run your macro
now your macro works :-)
Op 03/02/2013 13:38, Fernand Vanrie schreef:
Op 02/02/2013 11:20, Yessica Brinkmann schreef:
Hello,
Yes, I write: SELECT cliente.saldo_actual FROM cliente WHERE id_cliente=0
and it works. It say: Command executed successfully.
The column name is saldo_actual , so I wrote in my last version of the
macro, which is in my previous mail.
If its run in a query, than it must also in the macro ?
TRYE to run a other macro with only the statement with the id and the
value hardcoded
Regards,
Yessica
2013/2/2 Fernand Vanrie
Op 02/02/2013 07:04, Yessica Brinkmann schreef:
Hello,
I wanted to ask if I can please help with this issue. Is that really
need
to implement this functionality for my database. The macro has no
errors
but UPDATE is not performed in the customer table. I do not know if you
owe
the event in which I am putting my macro, event currently in the Mouse
button released Calculate Total button. Same should work if
saldo_actual
field for a record is empty it?
do the sql statement works when run from elsewhere (make a query to
test)
I also see that all new users first make an introduction, I'm doing my
thesis on Computer Engineering and I am working Independent, as do
systems. I have more experience working on Java and XML, but I think
this
is a nice opportunity to learn Visual Basic.
My macro is now as follows:
Sub ActualizarSaldoVentas (Evento)
Dim oFrm As Object
Dim oCliente As Object
Dim oTotal As Object
Dim oCon As Object
Dim oStat As Object
Dim sSQL As String
Dim oRes As Object
Dim rs As Object
Dim sCliente as String
Dim ColIndex as Integer
'Dim oIdPago As Object
oFrm=Evento.Source.Model.Parent
If oFrm.hasByName("id_cliente") Then
oCliente=oFrm.getByName("id_cliente")
Else
Print "Cannot find id_cliente"
Exit Sub
End If
rs=oFrm.createResultSet()
sCliente=rs.getString(rs.findColumn("cod_cliente"))
oTotal=oFrm.getByName("fmttotal")
Print sCliente
Print oTotal.getCurrentValue()
oCon=ThisDatabaseDocument.CurrentController.ActiveConnection
oStat=oCon.CreateStatement
sSQL = "UPDATE ""cliente"" " & "SET ""cliente"".""saldo_actual""
=" &
"
""cliente"".""saldo_actual"" + " & oTotal.getCurrentValue() & " WHERE
""cliente"".""id_cliente""=" & CInt(sCliente)
oRes=oStat.ExecuteQuery(sSQL)
End Sub
Regards,
Yessica
2013/2/1 Yessica Brinkmann
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
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
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
T
Re: Case Study on Open Office
Le 02/02/2013 17:39, Rob Weir a écrit : Since the work is done by volunteers, a top-down hierarchical approach cannot work. No one can order a volunteer to do something. It must be something they want to do, something that they are interested it and enjoy doing. Well, this is not always the case. Some don't really follow this guideline. Hopefully, they are not that many. But this is a reality of the community. See: http://markmail.org/message/uzs5bu3r5oby2fza and the whole thread. Hagar
Re: Case Study on Open Office
Le 31/01/2013 23:15, Ryan, Benjamin a écrit : 3. Describe how the various personal involved in the process, contribute to the overall development? For the record, the Forum team (the Volunteers at http://forum.openoffice.org/en/forum/ ) have been interviewed last year for the master thesis of 2 students of the Lund University (Sweden). The thesis can be downloaded (free) here: http://www.lunduniversity.lu.se/o.o.i.s?id=24923&postid=2827648 It explains some of the motivations of the people who help the users. Note that the ASF was not used to integrate forums (they are used to mailing lists) in their projects. But since OpenOffice is very much end-user oriented, they agreed to host the forums (that were hosted by former OOo "owner" Sun then Oracle). The interest from users in the forum has never decreased and after more than a year, the forum is showing the same popularity as before Oracle gave the code to ASF. For an end-user oriented application like AOO, there are important areas of the project that need more work because the audience is made of end-users with low level of computer knowledge (not all of them of course). I'm thinking of forums of course but also wiki and documentation. Access to information on how to use the application must be made as much easy as possible. It's not part of the development itself (as for the code) but it's part of the success of such a large project. Hagar
Re: FOSDEM: Thank you all!
thank you too :-) Hope to see you again Regards Sylvain Denis Le 3 févr. 2013 17:45, "Fabrizio Marchesano" a écrit : > Hi guys, > FOSDEM has been a great experience: thank you all for the opportunity, your > kind helpfulness and, moreover, your friendship. > I know that this mailing list should be used to talk about development > matters, but this was the easiest way to say that to you all in one shot. > Hope to have the chance to meet you again soon. > Regards, > > Fabrizio >
Re: Error in macro.
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 pgpI1GmtMCU8w.pgp Description: PGP signature
Re: Error in macro.
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 > 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 >
Re: Error in macro.
Hi Yessica, On Sun, Feb 03, 2013 at 02:31:49PM -0300, Yessica Brinkmann wrote: > 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 I don't have a 3.3.0 right now to test, but with 3.4.1 I could make it work. If you don't want to update, you can try using an external database, like MySQL or PostgreSQL (if your project is for a real business management system, using an embedded database isn't a good idea anyway, at some point you'll see the need to switch to an external database). Regards -- Ariel Constenla-Haile La Plata, Argentina pgpDLsu5uN79Y.pgp Description: PGP signature
Re: Error in macro.
Hello, Thank you very much for all the help! And for all the patience! My macro works! I had an installer of Open Office 3.4.0 and wonder but that version without any problems I could modify the default saldo_actual field from the Customer table. Regards, Yessica 2013/2/3 Ariel Constenla-Haile > Hi Yessica, > > On Sun, Feb 03, 2013 at 02:31:49PM -0300, Yessica Brinkmann wrote: > > 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 > > I don't have a 3.3.0 right now to test, but with 3.4.1 I could make it > work. If you don't want to update, you can try using an external > database, like MySQL or PostgreSQL (if your project is for a real > business management system, using an embedded database isn't a good idea > anyway, at some point you'll see the need to switch to an external > database). > > > Regards > -- > Ariel Constenla-Haile > La Plata, Argentina >
Re: Interesting factoid: 442 subscribers to the Dev mailing list!
Hi 2013/2/2 Rob Weir : > Also, 186 subscribed to the QA list and 175 on the marketing list. Good. The project is growing. :-) -- Albino Biasutti Neto Software Livre | Open Source | Free Software albino.ws ... @bino28 no identi.ca ~bino28 -- s.apache.org/zKb
Re: Ebay
Hi 2013/2/1 Andrea Pescetti : > But in short, there is no commercial version of Apache OpenOffice, and the > OpenOffice license allows to sell the product; OpenOffice can be downloaded > for free from http://openoffice.org and we recommend that you get it from > there. +1 -- Albino Biasutti Neto Software Livre | Open Source | Free Software albino.ws ... @bino28 no identi.ca ~bino28 -- s.apache.org/zKb
Re: [Call For QA Volunteers] AOO UI IAccessible2 testing work
Hi Steve, Yes, the branch "ia2" is ready for QA now. The earlier the power users involve, the faster project progress we can expect. Good idea! I hope NVDA dev team can join AOO IA2 dev work now. NVDA and Symphony had ever corroborated for a while in 2010, they are very professional and enthusiastic. Your initial testing is welcome. It will be helpful for IA2 QA work. I am sorry that I did not attend the event. I hope we can meet in the near future. : ) Thanks. On Sat, Feb 2, 2013 at 11:34 PM, Steve Lee wrote: > Hi Steve, thanks Don > > It's good to hear you have progressed so far already. > > Is the work in a state ready for testing by some screen reader users > who are very technical? > > If you have binaries or they are easy enough create I suggest we bring > in the NVDA dev team in now or very soon. They have been wanting IA2 > in [A]OO for a long time, but in it's absence have been recommending > Symphony to their users; the Java Access Bridge is a real pain for > their users to install. They will obviously give a very thorough > testing and should engage well at a deep technical level. One of the > NVDA contributors has provided the Arabic support so we'd get broad > extra testing of IA2 with i18n and RTL languages. If you feel you are > ready then let me know and I will make the introductions. > > http://www.nvda-project.org/ > > Otherwise how can I help? I have restricted cycles for the next week > or 2. I could do some initial 'gorilla testing'. > > PS Steve did we meet in Boston at a Mozilla/GNOME a11y event? > > Steve Lee > Programme Leader (Open Accessibility) > OpenDirective http://opendirective.com > > > On 1 February 2013 14:29, Steve Yin wrote: > > Hi Steve and Don, > > > > Thanks Don. Welcome Steve Lee! Now we can do more on AOO accessibility > > testing, not only IA2. : ) > > > > > > > > On Fri, Feb 1, 2013 at 8:46 PM, Donald Harbison > > wrote: > >> > >> Hi Steve Yin, > >> > >> Steve Lee from OpenDirectives is keen to help get the testing started. > >> He's > >> new to AOO, but an old hand with A11Y work. He's very well connected to > >> the > >> accessibility community and will be able to help us connect with experts > >> for the testing process. > >> > >> Take it away Steve (Lee), > >> > >> /don > >> > >> On Mon, Jan 28, 2013 at 1:46 AM, Steve Yin > >> wrote: > >> > >> > Hi Diego Valle, > >> > > >> > Welcome to join AOO IAccessible2 QA work. > >> > We will prepare QA cases and assign some of them to you. And I hope we > >> > can > >> > work together at the beginning. > >> > > >> > > >> > On Sun, Jan 27, 2013 at 6:44 AM, Diego Valle Rosado < > >> > diegogvalleros...@gmail.com> wrote: > >> > > >> > > Hello > >> > > > >> > > My name is diego valle.At the moment I study the career IT in > Quintana > >> > Roo, > >> > > Mexico. > >> > > > >> > > I'm interested in AOO IAccessible2 testing work and I'd like to be a > >> > > QA > >> > > volunteer. Would be a great way to learn how to get started > >> > > programming > >> > > OpenOffice and to help bring the benefits of OpenOffice to my > country > >> > > and > >> > > the region where I live. > >> > > > >> > > Regards > >> > > > >> > > Diego Valle > >> > > > >> > > > >> > > 2013/1/25 Steve Yin > >> > > > >> > > > Hi all, > >> > > > > >> > > > The UI part of the AOO IAccessible2 migration dev work will be > done > >> > > > in > >> > a > >> > > > few days. We need QA volunteers to join the testing work and > ensure > >> > > > the > >> > > > migration quality. This work will be started on the branch "ia2". > >> > > > https://svn.apache.org/repos/asf/openoffice/branches/ia2 > >> > > > > >> > > > If you are interested in AOO IAccessible2 testing work, please > reply > >> > this > >> > > > mail. Thanks. > >> > > > > >> > > > -- > >> > > > Best Regards, > >> > > > > >> > > > Steve Yin > >> > > > > >> > > > >> > > >> > > >> > > >> > -- > >> > Best Regards, > >> > > >> > Steve Yin > >> > > > > > > > > > > > -- > > Best Regards, > > > > Steve Yin > -- Best Regards, Steve Yin
Re: [Accessibility] IA2 bridge and UI related changes were submitted on the branch "ia2"
Hi Pedro, Yes, the sidebar should support not only IA2 but the whole ACC feature. But I think it is not a dependency, sidebar and its ACC support work are parallel. Thanks! On Sat, Feb 2, 2013 at 2:34 AM, Pedro Giffuni wrote: > Just curious ... > > > - Messaggio originale - > > Da: Andre Fischer > > > > > Am 01.02.2013 16:20, schrieb Shenfeng Liu: > >> Steve, > >> Great work! > > > > Yes, great work. I was not expecting this phase to be completed so soon. > > > > -Andre > > > > > I guess in Symphony, and now in AOO, the sidebar is somehow > related (a dependency perhaps) to the IA2 UI work? > > I am really impressed on how the pieces are starting to fit > together. You guys are great! > > Pedro. > -- Best Regards, Steve Yin
