column length quandary

When uploading to the (remote) server, we often get something like this:

[warning] The server version of the column ‘rct_evnt_fee’ of table ‘receipts’ in server ‘c3net’ has length 8 while in the import version the column has length 19.

We have not changed the length of the column (knowingly, at least).

What do you suppose is happening?

Jim

It sounds like you have two different database systems? This is typical for example if you import a solution from MS SQL into Oracle. MS SQL has an integer datatype and Oracle uses something like NUMBER(10,0) for the same. But of course, they are not the same, so you get this message.

We are using Sybase with Developer, and also the host is using Sybase.

What I notice is that the error may reoccur, but that clients are not affected.

Perhaps it is something to ignore.

I have seen such errors thrown too, without a real reason. Have you created columns direct in the database backend before using them within Servoy? Maybe the reason lies there, that Servoy interprets the type after an export other than the ‘real’ type?

No; I create columns in Servoy only.