Aware IM User Forums

humm, I am trying to respond to how you CAN use a stored procedure with Aware creating the where clause, but wordpress is giving me an error, "potential unsafe operation". but simply, use Aware the create the Where clause and pass that to the stored procedure

Bruce

My 0.02 cents worth. Aware is great! I keep looking to see what other options are available and while there is a plethora of no / low code options, they all have some serious shortcomings compared to Aware. So many require a REST module for database access. So many can help me build the app fast, bu...

What flavor of SQL are you using? Does it support triggers? If so, you can write a delete trigger.

Bruce

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...