import text data in a base table

View: New views
3 Messages — Rating Filter:   Alert me  

import text data in a base table

by Stefano Brigliadori :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi everyone. I have a problem with saving a value from one form to a
base table.

The field of the form is text type. the column of the table to save the
value is a text too.

My problem is that if I post a type value of 0.0x in the base table is
encoded as XE-02, while values of type X, XX or 0, X0 are saved
correctly. Someone can help me?

Thanks


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...


Re: import text data in a base table

by ottoshmidt :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi, might be a unicode problem?

Oto


On Thu, 2009-09-24 at 10:27 +0200, Stefano Brigliadori wrote:

> Hi everyone. I have a problem with saving a value from one form to a
> base table.
>
> The field of the form is text type. the column of the table to save the
> value is a text too.
>
> My problem is that if I post a type value of 0.0x in the base table is
> encoded as XE-02, while values of type X, XX or 0, X0 are saved
> correctly. Someone can help me?
>
> Thanks
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...


Re: import text data in a base table

by Frank Schoenheit, Sun Microsystems Germany :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello Stefano,

> Hi everyone. I have a problem with saving a value from one form to a
> base table.
>
> The field of the form is text type. the column of the table to save the
> value is a text too.
>
> My problem is that if I post a type value of 0.0x in the base table is
> encoded as XE-02, while values of type X, XX or 0, X0 are saved
> correctly. Someone can help me?

I'm not sure I completely understand what you mean with "values of type
X, XX, 0, X0", but what you describe sounds a little bit as if you used
a Formatted Field, having a numeric format, though bound to a text
field. Try changing either the formatting (in the property browser, in
design mode), or the control type (context menu of the control, also in
design mode).

Ciao
Frank


--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...