[cegottardi]

Greetings Isomorphic.

I read the smartgwt quick start guide and then the examples from the Smartgwtee's showcase.

But i have a few question that didn't find the answer in the guide and in the examples.

What if i need a nested mysql select in a sql templating? is it possible to do? if it possible to do with smartgwt pro?. For example: I have many tables which the result MYSQL query with nested select is the datasource.ds.xml defined.
The same question for UNION, JOIN etc.
Maybe i misunderstood everything.

The other question: I didn't find an example of using many datasources from a single DSRequest.
What i mean is that i want to iterate a dsrequest value in the DB tables and use the logic that actually i do with php.
For example: i have a ID value from a dynamicform that is in the dsrequest and executed in the defined datasource. I think it could be done with dmi but in the same dmi method can use others datasource that represent others tables from the DB? i want to verify the value in the others tables and then make a new DSResponse for the defined datasource.ds.xml.

I'm thinking buying a pro license but first i want no know if with pro i can do all these.

Carlos Gottardi.

[Isomorphic]

SQL Templating is a Power feature.

You can implement whatever SQL you want. Use the <customSQL> to build complete replacement SQL if you cannot do what you want via clause-by-clause replacement.

Unclear on your use case of multiple dsRequests, but it's very easy to initiate additional dsRequests on the server-side within a DMI. See this sample.

[cegottardi]

ohh thank you very much Isomorphic for the quick response.

The validation example is what i need i think. I will look it deeply.

With the pro features what do you suggest to affront my case? <customSQL> ?

Cya.

[Isomorphic]

<customSQL> and SQL Templating in general is a Power feature. You can upgrade by just paying the difference, otherwise, you'll need to generate your own SQL entirely and go direct to JDBC to execute it.

[cegottardi]

So alternatives are power or use HSQLDB ?.

mmmm i think if it mean less code, i will go power.

[Isomorphic]

No, HSQLDB is an embedded database shipped with samples and has nothing to do with Pro vs Power.

Pro will automatically generate simple SQL queries against any supported database (MySQL, Oracle, etc).

Power will generate SQL for AdvancedCriteria filters and will allow you to customize the SQL via SQL Templating.

Yes, Power definitely requires less code. In many cases, applications built by Isomorphic consulting no longer require any custom server Java logic at all.

[yamabushi]

<customSQL> and SQL Templating in general is a Power feature. You can upgrade by just paying the difference, otherwise, you'll need to generate your own SQL entirely and go direct to JDBC to execute it.

Hello Isomorphic

I new with your framework. I have tested Smart GWT LGPL and its very cool. I'm java programmer so its the right thing i was looking for.

But now i wanted to test Smartgwtee trial. I have a few question if you can please answer me.

1. Does smartgwtee trial have all the features enabled? CustomSQL and SQL Templating?

2. In the case i can't pay your power ( i can pro ) license because I'm a single developer and the difference in my country is 4x1. So... $1950x4 is too much for me jet.
And i have read there that pro does not suport that features that i need. you said that i can generate my own SQL in pro and execute it with JDBC.

Do you have any demo or example in your showcase for that?.
What do you suggest to do?
I was looking in the Smartgwtee samples a way of execute an own SQL query but all what i find is that they are all executed in Datasources ( and that is my problem that with pro i cant make complex select in the datasource ).
Maybe i don't have very clear the concepts of smartgwtee but i have read the quick-start guide and most of the examples in your showcase.

thank you for your time.

[Isomorphic]

1. yes it does

2. basically, take any JDBC sample you find on the web, and just place the Java code for that in a SmartGWT DMI. In Pro edition, you'll need to generate the entire SQL statement yourself.