Inserting a column into a database

Classic Servoy
1

Hi,
I have a wired issue in inserting a column into a table. I choose it to be type Number,length 8,and when i press Apply, the length changes to 2. I need the length to be 8, do you have any idea what could be the solution to this? Thank you!

2

Hi,

I tried this in Servoy 3.5.7 (Oracle database) and it works fine.

A few questions :

  • what Servoy version are you using

  • are you creating the new column in Servoy ?

  • what if you create the new table/columns in the database and the restart Servoy and look at the table. Is it oke then ?

  • what database and version are you using ?

Regards,

3

Hi,
Thank you for your answer! I am using Sevoy 3.5 and I am creating the column from Servoy (dataprovider). The database is on another server(I am working remote), I am supposed to use DBVisualizer 6.0.14 to handle the databases but i don’t have the username and password yet(I will get them tomorow). Is there any setting from Servoy that can solve this?

4

Is it an Oracle DB? If yes, I have seen this issue before. It is likely an encoding problem that occurs if you use the wrong JDBC driver. If you work with Oracle, you have to be 100% sure you use exactly the JDBC driver version that Oracle issues for the release of the database that you are using. So my suggestion is: download the correct driver and try again.

5

I agree with Patrick,

I had issues with varchar2 columns in an Oracle database.
these were solved when using the correct Jdbc driver.

So first of all : get the correct Jdbc driver. Or you will get more issues.

Regards,

Hans

6

Hi,
Thank you for your answers!
I am using Sybase as database. I don’t know what the problem is but when i don’t set the length for type Number(from Servoy dataprovider) the length is automatically set to 8. When inserting a new number field WITH setting the length, the field length is not correctly set into the database(it changes it to 2). What could be the reason for that?

7

I see the same issue now to.

If you create a new table in Servoy and add a column you can set the length to 38 for example.
It stays 38 when you apply the change.
But if you stop and start Servoy and look at the same column it will display a length of 2.

If you add a number column to an existing table and you set the length to 8 or 10 or 50 and then apply the change
Servoy will set the length to 2.

The resuting column in Oracle is always number(19,2).

Patrick, can you verify this ?

Regards,