The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Query Builder Questions
Posted: 17 Jun 08 11:11 AM
|
Hi
1.How to use aggregate formulas in global joins?
2.How to convert a numeric field in a calculated field to string?(like cint(Age))?
John
 |
|
|
|
Re: Query Builder Questions
Posted: 17 Jun 08 6:09 PM
|
Regarding #1, you can't, but there are a couple of workarounds.
If you're using SLX 7.x you can create a SQL View that selects IDs based on any SQL you like, then join your view in the query builder.
If you're on 6.2 and you're using a inner join, and you want to base the join on two fields, you can join one field the normal way, then add a condtion like "ACCOUNT.MYFIELD IN (A3.OTHERFIELD)" where A3 is the alias used on the table you're joining to (I just figured this out last week). |
|
|
|
Re: Query Builder Questions
Posted: 18 Jun 08 2:39 AM
|
Thanks Dan
1.I am using slx7.2,whether i have to create sql view in AA or in database(i.e directly in sqlserver)
2.How to convert a numeric field in a calculations used in QueryBuilder to string?(like cstr(Age) which is used for type coversion vb.net)?
|
|
|
|
Re: Query Builder Questions
Posted: 18 Jun 08 4:14 PM
|
I haven't worked with the query builder in SLX Web much, but what I would try is to build the SQL view in SQL query analyzer, then enable it in Administrator.
At that point I would think you can import it as an entity in AA and have it appear as a table in the query builder. |
|
|
|
Re: Query Builder Questions
Posted: 24 Jun 08 2:26 AM
|
hi...John
I am getting "There is unclosed String" error while trying to implement a view as a group...
Wat can i do.
Thanx. |
|
|
|
Re: Query Builder Questions
Posted: 25 Jun 08 12:30 PM
|
| Is there a single quote ' somewhere in the query? If so, you need to add a second quote. |
|
|
|