Aware IM User Forums

Where is asks: "Expansion of rows"


Bruce

I have finally figured out the best way to run SQL Server on a mac (either Intel or M1 based) in Docker and have Aware connect to it. This configuration keeps all the permanent data outside of the Docker container (so easy to copy backups of databases to / from the local file system. Happy to share ...

I could be wrong (usually am) but I thought the ONLY user interaction a rule can have is a REPORT ERROR. Anything else has to be in a process.

So, why not have this line of code call a process to run the EXEC_SCRIPT? Yea, I know thats 1 extra line of code and an additional process....

Bruce

I know you want to keep the SQL all in your Aware app, but let me suggest that is a mistake. 1st, you mention that if fields change your SQL might break, but if fields change your aware program will compile fine but break when the user trys to run the SP. 2nd, Since it is not a stored procedure, it ...

While I have not tried this. I would assume the install folder would be different for each aware server (one points to Aware and AwareTest, other points to Aware2 and Aware2Test) and, assuming that the BSV that they share have an external database (data and datatest) there should be no problems with...

The same way I can't just pop a Sencha component into Aware since it is based on the Kendu framework. I can't pop a Kendu component into a react framework. However, web components are standalone. Yes, they are just HTML, css (and perhaps some JS). but they exist on their own and do not need a framew...

The only plus is that Kendu is a framework that contains components (some very nice ones!). Shoelace is framework agnostic components. So, for instance, if I have a text field, the ability to point to a shoelace input field and use some of the attributes to customize the the behavior would be nice. ...

The shiny new version has 2 ways of logging on. the OLD way (.html) and the NEW way (.jsp). Besides a slightly different look, what are the advantages / differences between the two?

Thanks

Bruce

BobK wrote: ↑Fri Jan 27, 2023 8:16 pm Out of curiosity, how would you do that in SQL?

Update BO set Arrival = DateADD(mi, dateDiff(mi, oldPickup, pickup), Arrival)

Bruce

I have 2 attributes, Pickup and Arrival. Both are timestamp fields. They have BOTH been computed previously. For example, pickup 9:00 AM, arrival 9:45AM. Now the user wants to enter a new pickup time and I need to change the arrival time by the DELTA of the original pickup time and the new one. So i...

It is good that you are getting that error. Otherwise you might want to play with an old version where some BOs / attributes were NOT defined and if Aware deleted them, you would lose some data! Aware is unique in the fact as you make changes that affect the underlying database structure, when you g...

Since I purchased fontAwesome, they sent me an email telling me about their integration with shoelace. Shoelace is a bunch of web components that are framework agnostic. so it got me thinking... How hard would it be for the next version (9?) to integrate with web components. So, for instance, if I a...

pg 117 of the user guide has an example of the CHANGED prefix. It looks like: If Transaction FROM Account.Transactions WAS CHANGED AND ChangedTransaction.State WAS CHANGED TO ‘Approved’ Then Account.Balance = SUM FinancialTransaction.Amount WHERE (FinancialTransaction IN Account.Transactions AND Fin...

not sure exactally what you are looking for:

Do you want to have a query where the code looks like
EXEC_SP "QueryToReturnAwareBOData" RETURN myBO


If so, and myBO is an external DB that you created as an external db table, then that is easy.

Bruce

ah ha! Twitter spaces is NOT in the browser. Have to use a mobile device. GOT IT!

Bruce