Aware IM User Forums

I am confused. Is it working right or do you still have a problem.

Also, not sure why you need to access a view vs. an Aware BO with shortcuts to other tables.

If a query's text view looks something like this: EXEC_SP "readSomeData" RETURNS myBO then the data is view only. You do not have access to the rows when the user clicks on them or in an Operation with Records. When you need a view (or just an SP to create the columns you need displayed, you need to...

That is what I use 99% of the time. When I forget it replaces what is displayed. Am I the only one who wants this?

Bruce

lets see. how many days until January? Wait, with the international date line, will it be released a day earlier or later than I expect?


Bruce

Wonder if they wil tie it to the next Aware conference???

Bruce

Aware is very rich with FUNCTIONS. They are at the end of the user guide and there are quite a few handling date and time.

If you want the year try SESSIONVARS.currentYear = YEAR(CURRENT_DATE)


Bruce

Right now we have display message and display question but there is no easy way to style them dynamically. I would love to see a procedure similar to what I had in EXT-JS. Would look like: DisplayMessageBox(Icon Type [Error - Warning or Info], 'Title', titleClass, 'body', bodyClass). Yes, I can crea...

I wonder why Aware does not create these automatically, just to be more compatible with outside tools. Thank you for this solution. Anthony At a guess part of the reason is that it would be a very inconsistent implementation and hard to do in a bidirectional way. The management of peer multiple rel...

What aware does that is different from many other tools is that foreign keys are not defined in the database. Most reporting tools will, by default, use foreign keys to read data from multiple tables. It is easy, and will not break aware for you to manually create foreign keys. In aware the "many" t...

Of course, living in FLA, I would be VERY happy to have the next conference in the Sunny State of FL

Bruce

And, of course, there is another way. Assuming that you can modify the external table. Do the following 0). Rename the external table 1). Create a BO in Aware with the name of the external table and all the columns, When you go to test (or publish) it will create an empty table 2). Select all of the...

And, there is always another way. You can create a VIEW in SQL that combines columns from the aware table(s) and the external one. Depending on the columns you need, you can create a BO in aware with all the result columns then when you want to access / view the data you could write a stored procedu...

Since you have had no answers, I figure I would just spit ball here....

1). Can you enter the name in []. i.e. [index]?

2). Can you create a calculated field in the table that references the "Index" column?

3). Can you create a view where you rename the "index" column?


Bruce

When I click on the red pin, I see the following. It is one attribute in the BO used in the query but I do not need the date. How do I control which attribute is displayed in the popup box?

Thanks
Bruce

How can I conditionally change the color of the pins when creating a google map? Right now they are all a nice bright red.

Thanks
Bruce