View Foundset Datatypes

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

View Foundset Datatypes

Postby gk1441607435 » Wed Oct 21, 2020 9:39 am

Hi

I tried to create a View Foundset. This works fine with date and number fields. But as soons as I use Text or UUID Fields I get errors like:

ERROR com.servoy.j2db.util.Debug - Column type for column 'fieldname' defined in view datasource 'view:fieldname' does not match the one provided in the query.

This happens for example, when I have columns named 'x' both of Type 'Text' in a 'sourcetable'- and a view foundset definition.
When I take a look into the dbi-file of a sourcetable for the query, I see that a textfield has a datatype of -9. I guess that is the java.sql.Type of NVARCHAR;
But in the dbi-file of the view foundset the datatype is 12. This looks like the java.sql.Type of VARCHAR;
For the type UUID(Text(36)), the datatype is in both files 12. That looks ok. But in the (source)dbi file the "flags" property is set to 5, whereas in the view foundset dbi file the "flags" propterty is 4.
This differences are probably the reason for the error.

This looks to me like a bug. But it has been demonstrated in a the Webinar "2019.06 Launch Part 1 - FoundSet Optimization". (https://www.youtube.com/watch?v=06vbETaR8iA)
There it worked fine with TEXT-fields. So why shouldn't it work now?

Are there any options in developer for dbi creation or is it still a bug in a newer version of servoy?

Thanks

Gregor

Servoy 2020.06
SQL-Server 2012
gk1441607435
 
Posts: 14
Joined: Mon Sep 07, 2015 8:30 am

Re: View Foundset Datatypes

Postby pitc » Wed Mar 03, 2021 10:11 pm

Hi Gregor,
did you get an answer for this.
I am getting the same error.
Tom
Servoy 2020.12.3263
Tom
prospect-saas.com
pitc
 
Posts: 84
Joined: Thu Nov 14, 2019 2:22 pm
Location: Ottawa, Ontario, Canada

Re: View Foundset Datatypes

Postby pitc » Mon Mar 08, 2021 10:43 pm

Update: I added a Servoy Jira defect:
https://support.servoy.com/browse/SVY-15928?filter=-2
There I comment on the workaround editing .tbl file
Tom
prospect-saas.com
pitc
 
Posts: 84
Joined: Thu Nov 14, 2019 2:22 pm
Location: Ottawa, Ontario, Canada

Re: View Foundset Datatypes

Postby gk1441607435 » Wed Mar 17, 2021 2:41 pm

Hi Tom
Sorry for my late reply. I didn't expected an answer to this anymore and the the view foundset is just a nice to have in our project at the moment.
Anyway, thanks for creating a case and getting a 'solution' for this.

For others: workaround and case from Tom ist here:
https://support.servoy.com/browse/SVY-15928?filter=-2
See Tom's comment
gk1441607435
 
Posts: 14
Joined: Mon Sep 07, 2015 8:30 am


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 4 guests