Re: insert and update data from basic

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