Aware IM User Forums

I never use MySQL

I only use MS-SQL or Maria DB as they support Sequences and MySQL does not

The practice I use these days is to only ever create the initial DefaultApplication in BASDB ALL other Business Spaces are in their own DB. Additionally, as I run Aware V6, V8.5, V8.8 and V9 on my laptop, I PostFix every Business Spaces with the Aware IM Version... ie... Suppose my app is called MyS...

OMG! Thanx nhofkes for your reply.... That was not the issue as my EDIT was the last Action in the Process.... but... It was one of those situations where the more you learn the more you forget. The one thing I did not check… I was calling a process to Add New rather than Add Reference… Duh! 🥴 Fixed...

This has cropped up many times over the years and has probably been answered but I have not been able to find a suitable solution or have forgotten . So, imagine you have a BO Form with a Reference Query on the form in with you can Add, Edit or Delete child records. If you EDIT that BO Form directly...

Dunno about Surface ARM/Snapdragon....

But I can say, Aware running on a M2 Macbook Air and Windows 11 under Parallels is fantastic. Just saying

Ok... Seems like I have fixed it.... I added -set `exif:Orientation` `1` to the magik mogrify command and it seems to have corrected the problem. ie.... EXECUTE PROGRAM 'magick mogrify -set `exif:Orientation` `1` -format jpg C:\TempImage\'+FILE_NAME(PictureItemForAnswers.Picture)+'.'+FILE_EXTENSION(...

I have a Report that displays a number of Photos. I am using ImageMajck to orientate the Portrait and Landscape photos correctly. I the BO Form they look like this..... sw_4.jpeg The Photos are stored in the filesystem and when I look at the files at the path location they a oriented correctly. Howe...

I have also been wrestling with the Export to Excel. In the end I resorted to copy and paste direct from the Grid into Excel. It works, Kendo supports this and it keeps the correct formatting. Its not an elegant solution, but it is a work-around DM me and happy to share. Haven't got time to build a...

Thanx guys.

Resorted to a mixture of Stored Procedure and Python script....

Turned out to be a much better solution and faster.

Am using Aware IM V8.8 Here is the issue.... I have a BO that currently has about 70,000 records in it across 4 years worth of data. When the data is displayed to the User, they will typically want to filter that data down to a single month. The data for 1 Month is between 3,000 and 4,000 rows. We t...

Ironical I know but..... I have never used or never needed to use the EXEC_SPF capability in Aware...... Until this last weekend... Spent hours trying to get a complex Query to work without joy.... but then a light came on... Maybe I could do this with a Stored Procedure returning a Value.... Dig ou...

AIDIC2024.png Dear Aware IM Developers, For those who were unable to attend the recent Aware IM Developers International Conference in Tampa, Florida, the complete contents of the Conference is now available for purchase. The Conference Package is packed full of valuable Aware IM related informatio...

Yes, the Conference package will be available for purchase hopefully around the end of next week.

I have been travelling with work since the conference and will arrive home this coming weekend so will
then have time to finalize all of the content.

I will notify all here as soon as it is available.

Never used Triggers.

Bruce, do you put the COMMIT TRANSACTION in the BO Rule and then call the SP process or do you put the COMMIT TRANSACTION as the first action on the SP Process…. Or doesn’t it matter?

Indeed that would be a great improvement