Servoy Forum

by **chartpacs** » Sat Aug 26, 2006 2:16 am

Hello,

For some reason, when I created this paticular solution and entered some columns, Servoy went ahead and added an extra column that I can't remove. Please see attached screenshot.

The extra column is named "dummy_col", and when I try to remove it I get the following error: "ASA Error -143: Column "dummy_col" not found. I even tried first creating the dummy table and columns with Sybase Central 9.0.1, but Servoy still added this dummy column. The weird thing is that so far it's the *only* table that's affected. Other tables I've created are "normal".

Any ideas?

by **jcompagner** » Sat Aug 26, 2006 9:42 pm

thats odd, so after a restart the column is there listend but it isn't really in the database (looking at it with sybase central?)

What happens if you export it and import it again in a clean repository?
If you also have it then, please send us that solution (upload to our support system)

by **chartpacs** » Sat Aug 26, 2006 10:33 pm

Hi Jan,

thats odd, so after a restart the column is there listend but it isn't really in the database (looking at it with sybase central?)

Yep. Here's a short movie that illustrates this problem:
http://www.entropysolutions.net/test/se ... column.mov

Am I doing something wrong?

by **chartpacs** » Sat Aug 26, 2006 10:46 pm

FWIW, I can export the solution, but I can't re-import it (tried both a regular and clean import). I get the same error that's on the video (-124).

Is "dummy" a reserved word in Servoy? :wink:

FWIW, here's a screenshot from Sybase Central:

by **chartpacs** » Sun Aug 27, 2006 12:21 am

I think there's actually something about naming a table "dummy" that triggers the creation this extra "pseudo" column. I can reproduce this on any database. Can anyone confirm this? NOTE: try this on a test database, not a production database.

This is *really* weird.

by **IT2Be** » Sun Aug 27, 2006 10:24 am

Hmm, I think Servoy is already secretly working on some features asked for earlier like artificial intelligence. I can imagine they are working on tables like 'dummy', 'smart-ass', 'stupid', 'intelligent' etc. :lol:

What happens when you create a table 'smart-ass'?

by **ROCLASI** » Sun Aug 27, 2006 10:56 am

IT2Be wrote:What happens when you create a table 'smart-ass'?

I predict it will create a virtual column named 'marcel' because it will constitute the same thing as the table name.

by **Harjo** » Sun Aug 27, 2006 11:36 am

ROCLASI wrote:
IT2Be wrote:What happens when you create a table 'smart-ass'?

I predict it will create a virtual column named 'marcel' because it will constitute the same thing as the table name.

by **IT2Be** » Sun Aug 27, 2006 11:40 am

hmm, they call that 'back-fire' or 'boomerang' effect

by **jcompagner** » Sun Aug 27, 2006 5:11 pm

pleas sent that solution that you can't import anymore to our support system.

by **chartpacs** » Sun Aug 27, 2006 6:59 pm

Hey guys,

Can you reproduce this problem, or is my Mac cursed?

FYI, I think Servoy 4.0 is codenamed "goofball" :wink:

Johan, I'll upload a sample solution later today.

by **chartpacs** » Tue Aug 29, 2006 8:10 pm

Finally got around to sending a sample solution to Servoy support.

Servoy Forum

Extra Column Being Created

Extra Column Being Created

Who is online