Hi all,
I need connect Scriptcase to any opensource columnstore index database. Best of me is Monetdb (ODBC and JDBC driver exist). I need only read (SELECT FROM WHERE - etc.) Any solutions? Thanks
If you don’t have a scriptcase licence containing odbc then the only way to go is to use your own custom php code for accessing this odbc database, including the connect.
I have scriptcase licence containing odbc, but not function this way. Did you try it? ODBC driver setting is OK for MonetDB + Excel, MonetDB + R Studio, Monetdb + RapidMiner…) Thanks…
No I haven’t been using odbc, but afaik you need to have a dsn first, then you can define your connection to the datasource in scriptcase. you can have more than one connection so it should be easy to do. Connecting to sql server also requires a dsn to be setup and that works well so I think odbc should too.
Did you try making a form by simply typiing the sql select statement? The database tool in scriptcase is somewhat limited afaik. I always use a normal database editor next to it (sqlite expert, navicat, oracle sql developer etc…) then I type my select simply by hand.
The point I mean is whether you can get a simple form or grid working with a simple sql statement.
Yes, of course. You can see screenshots http://www.scriptcase.net/forum/filedata/fetch?photoid=63019 and result http://www.scriptcase.net/forum/filedata/fetch?photoid=63021
… FROM iris iris ? strange piece. This is not standard sql
[I]select_query:
[/I]SELECT [ ALL | DISTINCT ] ( '*' | [I]column_name[/I] ',' ... ) [ INTO[I] column_name[/I] ',' ... ]
[ FROM [I]table_name[/I] ',' ... ]
[ WHERE [I]search_condition[/I] ]
[ GROUP BY [I]column_name ',' [/I]... ]
[ HAVING [I]search_condition[/I]]
[ ORDER BY [I]ordering_spec[/I] ',' ... ]
[ LIMIT [I]posint[/I] ] [ OFFSET [I]posint[/I] ]
I dont see any FROM iris iris possibility in the syntax. FROM iris,iris yes… I guess you meant FROM iris
see: https://www.monetdb.org/Documentation/SQLreference/TableExpressions