Am Sonntag, den 10.07.2005, 14:45 +0200 schrieb Marc Santhoff:
> Hi,
>
> I'm trying to find a hopefully small solution for writing data to a
> registered data source. I've tried with basic by getting a connection
> and creating a statement from the values to write, but this is a tedious
> task because the formatting of values (dot vs. comma) and date/time
> values has to be done manually.
>
> Another approach might be to create a temporary query object or using a
> record set directly. But with a query I found no way to hand over the
> data by putting it to parameters...
>
> Can someone please push me in the right direction for achieving my goal
> and not reinventing the sdb[c[x]] layers?
A RowSet seems to be what is needed her. So in trying I found another
thing unclear:
Is there a method of updating any column without decoding the type
before?
What I do now:
select case typename
case com.sun.star.sdbc.DataType.BIT
aRowSet.updateBoolean(value)
case com.sun.star.sdbc.DataType.INTEGER, _
aRowSet.updateInt(value)
... and so on for each updateXxx method ...
What I'd like to do:
aRowSet.updateAny(value)
Is this possible?
TIA,
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
