Re: [libreoffice-users] Displaying data on an unbound field

2016-01-12 Thread Marion & Noel Lodge
Hi Egbert,

I suspect that the property name may be case sensitive.

I have similar code that works with "Text". Try using -
oDiscountFact.Text = format(sDiscountFact, sFormatString2)
and see if that fixes it.

Noel
--
Marion & Noel Lodge
lodg...@gmail.com

On 12 January 2016 at 12:12, Egbert Eissing  wrote:

> I have a form which holds several fields which are not bound to a database
> table, but are showing data for information purposes only.
>
> Consider the following code snippet.
>
> oResultSet = oStatement.executeQuery()
> if not isnull(oResultSet)then
> oResultSet.next
> sDiscountFact = oResultSet.getString(1)
> oDiscountFact = oForm.getByName("discountFact")
>   oDiscountFact.TEXT = format(sDiscountFact, sFormatString2)
> end if
>
> If the form has just been opened, the last line returns an error:
> "Property or method not found: .TEXT."
> If I now change the formatted field to a text box and back again to a
> formatted field, the problem is solved - until the form is closed and
> opened again.Is this a bug to be fixed soon, or is this a more permanent
> "feature"?
>
> Now I changed the last line with the following:
> oDiscountFact.setString(sDiscountFact)
> That produces the same error message:
> "Property or method not found: setString."
>
> I have also tried:
> oDiscountFact.BoundField.updateString(sDiscountFact)
> As expected, this does not work, because the field is not bound to a
> database.
>
> Is there any other alternative to display text on an unbound field, one
> that works correctly all the time? The solution to this problem is really
> important for me.
>
> Thanks for any suggestions.
> Egbert
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


[libreoffice-users] Displaying data on an unbound field

2016-01-11 Thread Egbert Eissing
I have a form which holds several fields which are not bound to a database 
table, but are showing data for information purposes only.

Consider the following code snippet.

    oResultSet = oStatement.executeQuery()
    if not isnull(oResultSet)then
    oResultSet.next
    sDiscountFact = oResultSet.getString(1) 
    oDiscountFact = oForm.getByName("discountFact")
      oDiscountFact.TEXT = format(sDiscountFact, sFormatString2)
    end if

If the form has just been opened, the last line returns an error:
"Property or method not found: .TEXT."
If I now change the formatted field to a text box and back again to a formatted 
field, the problem is solved - until the form is closed and opened again.Is 
this a bug to be fixed soon, or is this a more permanent "feature"?

Now I changed the last line with the following:
    oDiscountFact.setString(sDiscountFact)
That produces the same error message:
"Property or method not found: setString."

I have also tried:
    oDiscountFact.BoundField.updateString(sDiscountFact)
As expected, this does not work, because the field is not bound to a database.

Is there any other alternative to display text on an unbound field, one that 
works correctly all the time? The solution to this problem is really important 
for me. 

Thanks for any suggestions.
Egbert

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted