ResultsetColumn.Typename inconsistent between drivers?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

ResultsetColumn.Typename inconsistent between drivers?

Drew Jensen
Hi,

For example:

Given an Image Control bound to a field of type longvarbinary

This code is required:

for cntr = 1 to oDataForm.Columns.count
       CurrentColumn = oDataForm.Columns(cntr -1 )
       if UCASE( CurrentColumn.Typename) = UCASE("longvarbinary") then

because under HSQLdb it is LONGVARBINARY under MySQL Native it is
longvarbinary.

Shouldn't this be consistent? Issue?

Thanks

Drew



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: ResultsetColumn.Typename inconsistent between drivers?

frank.schoenheit
Hi Drew,

> for cntr = 1 to oDataForm.Columns.count
>        CurrentColumn = oDataForm.Columns(cntr -1 )
>        if UCASE( CurrentColumn.Typename) = UCASE("longvarbinary") then
>
> because under HSQLdb it is LONGVARBINARY under MySQL Native it is
> longvarbinary.
>
> Shouldn't this be consistent? Issue?

This name is completely driver-controlled, so each and every database
can do what it wants here, OOo just routes through, without interfering.
The only thing you can interpret is the css.sdbc.DataType.

Ciao
Frank

--
- Frank Schönheit, Software Engineer         [hidden email] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]