sql param

Classic Servoy
1

Trying to connect to a MSSQL2008 db…
OK with 1st db, not with 2nd on the same server, same instance.
In the faulty case, I get:
com.servoy.j2db.dataprocessing.DataException: Object name ‘GrfOffre’ not valid.
GrfOffre being the table name. though I get ok the table field names, properties, etc. and I did specify a row_ident.

When issuing a SQL query using the rawsql plugin, I get the same pb, I must specify the whole path, that is including the owner’name, ‘dbo’ in most situations, ‘neo’ in this case.
For some reasons, servoy always uses table names without the owner’s prefix in MSSQL, but in this case, it seems I’d need it. but no way to insert it for a form datasource, I can only browse the name.
I could load record using a query + a separate foundset, but then I get a problem for relationships.
What am I missing? probably on MSSQL side where both looks almost identical.

2

lesouef,

Try filling in the schema and/or the catalog in the server definition.

Rob

3

you’re right, I just found it 20mn ago, too soon for me to update the thread here. the default schema had to be specified in servoy, though already defined in mssql for the account used from within servoy.
btw, how do you make these editable drop down (like shema in server definition), those we have in servoy do not allow free data entry when using combos…

4

lesouef:
btw, how do you make these editable drop down (like shema in server definition), those we have in servoy do not allow free data entry when using combos…

Check the Editable property.

5

true, but does not work in all situations. for instance, if the valuelist is based on a table, then free data entry is disabled anyway.
sometimes it would he handy to enable a user to type some data, even if the choice is based on a table field.
The workaround is to make a custom valuelist you fill with a query, but you must refresh this all the time…
I simply don’t like pure custom lists, as the user cannot insert new entries himself.
Actually, I could do a generic method which populates all my custom lists from a table at startup, but that seems like a bit too much work for the advantage…
anyway, I can live with that, not so important.

6

lesouef:
true, but does not work in all situations. for instance, if the valuelist is based on a table, then free data entry is disabled anyway.

Only if your valuelist has a display and real value. When the display and real value is the same column it should work fine.