Table view with SQL Server 2005

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Table view with SQL Server 2005

Postby maservoy » Thu Nov 08, 2007 10:26 am

Hello,
when creating a new form using as a server SQL Server 2005, the tables list is not only composed by the tables in the database, but also by other tables (views, in fact) of the master databes: all_*, database_*, xml_schema_*, etc.

It would be nice to filter all these views. And it would be even nicer if we could use a regular expression to filter the tables of the server view: for example, although I have other tables on the database, the only ones I want to use are the ones starting by tb_*.

Thank you,
Miguel.-
maservoy
 
Posts: 46
Joined: Tue Nov 06, 2007 12:22 pm

Postby janteque » Thu Nov 08, 2007 11:25 am

I've proposed a similar request on this thread:

http://forum.servoy.com/viewtopic.php?t=7355
janteque
 
Posts: 44
Joined: Wed May 16, 2007 5:22 pm

Postby martinh » Fri Nov 09, 2007 10:08 am

It is the JDBC that Servoy uses, which can not see the difference between user tables and systemtables.

I posted already same situation and that was the reply of Servoy.

They don't use (/want to use) specific coding for a certain database.

All passes by standard JDBC-calls which are valid for each type of database.

I agree with your request, but not much chance that Servoy is going to do something about this.
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 15 guests