SQL Explorer issue ?

Questions and answers regarding the use of eclipse environment as seen in Servoy Developer

SQL Explorer issue ?

Postby stefanoni » Thu Oct 07, 2010 11:17 am

Not confident about the concept of Eclips/Servoy, and if the question might be on the wrong place
(the feature to browse data in the tableditor comes from SQL Explorer ? ), i have the following issue:

The second column is type integer. If you scroll down the printscreen a view lines, you will see the sort behaves like
a type charachter without leading blanks.

Prtscrn_01.jpg
Prtscrn_01.jpg (376.36 KiB) Viewed 2838 times


When i check the first column (also type integer) the sort behaves the way i expect.

Prtscrn_02.jpg
Prtscrn_02.jpg (379.97 KiB) Viewed 2838 times

The difference between column one (id) and two (band key) is: The first on (id) has a primary key.

Does it make sense to you?
Thanke you for any suggestions.
Alessandro Stefanoni ---- gigdoodle.ch ---- stefanoni.ch ----
Stefanoni Informatik Gmbh, CH-8200 Schaffhausen
Switzerland
stefanoni
 
Posts: 313
Joined: Fri Jul 23, 2010 3:17 pm
Location: Switzerland

Re: SQL Explorer issue ?

Postby jcompagner » Thu Oct 07, 2010 1:30 pm

thats someting of the SQL Explorer plugin, servoy doesnt do anything with that.

I guess the sql explorer plugin thinks it selects a string, maybe you could look deeper into what sql explorer reports as the resultsetmeta data for that one.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: SQL Explorer issue ?

Postby stefanoni » Fri Oct 08, 2010 8:32 am

jcompagner wrote:..maybe you could look deeper into what sql explorer reports as the resultsetmeta data for that one.

Thanke you. Where can i have a look into resultsetmeta ?
Regards
Alessandro Stefanoni ---- gigdoodle.ch ---- stefanoni.ch ----
Stefanoni Informatik Gmbh, CH-8200 Schaffhausen
Switzerland
stefanoni
 
Posts: 313
Joined: Fri Jul 23, 2010 3:17 pm
Location: Switzerland


Return to Eclipse Environment

Who is online

Users browsing this forum: No registered users and 5 guests