Search found 20 matches

by MarkP
Tue Jul 19, 2022 5:52 am
Forum: Problem reports
Topic: Can someone tell me where the IDGEN value in SQL Server can be found?
Replies: 4
Views: 2439

Re: Can someone tell me where the IDGEN value in SQL Server can be found?

Fantastic, thanks Jaymer. That worked. All you need to do then is right click on it and select Properties, tick the Restart box and then the Restart number field becomes editable to let you input any number you like. And since each database has its own BAS_iDGEN Sequence you can fix an individual da...
by MarkP
Mon Jul 18, 2022 6:54 am
Forum: Problem reports
Topic: Can someone tell me where the IDGEN value in SQL Server can be found?
Replies: 4
Views: 2439

Can someone tell me where the IDGEN value in SQL Server can be found?

Hi all, Urgent!! I'm getting duplicate index errors and I see from previous posts that I need to re-set the IDGEN value to a higher number. But... I cant find BAS_IDGEN or just IDGEN anywhere in my SQL Server databases. Not even BASDB or BASDBTEST. Can anyone tell me where it is actually located so ...
by MarkP
Thu Jun 30, 2022 6:36 am
Forum: Problem reports
Topic: Query List not displaying any Records - Version 8.7 upgrade
Replies: 3
Views: 2313

Re: Query List not displaying any Records - Version 8.7 upgrade

Hi Jaymer

Yes I have checked that and they all have Full Access as far as the Agronomist Object is concerned.
At least my workaround is doing the job for now so it is not a show stopper.
by MarkP
Wed Jun 29, 2022 2:04 am
Forum: Problem reports
Topic: Query List not displaying any Records - Version 8.7 upgrade
Replies: 3
Views: 2313

Re: Query List not displaying any Records - Version 8.7 upgrade

Just an update on this... This is a multi tenant database design. What I found after experimenting was that if I logged in just as admin with administrator rights I could see the list ok and also as a drop down list on the farm records. So I disabled the business rule which is recommended if you wat...
by MarkP
Tue Jun 28, 2022 11:15 pm
Forum: Problem reports
Topic: Query List not displaying any Records - Version 8.7 upgrade
Replies: 3
Views: 2313

Query List not displaying any Records - Version 8.7 upgrade

Hi everyone, I seem to be having an issue with a particular Query List after upgrading from Version 8.6 to 8.7. I have a list of Agronomists who are linked to specific Farms using a Peer to Peer reference. My Agronomist List which just shows a list of Agronomist names all worked fine under 8.6. And ...
by MarkP
Tue Mar 29, 2022 8:05 am
Forum: Problem reports
Topic: Bug in Group Totalling in Ver 8.6?
Replies: 2
Views: 2206

Re: Bug in Group Totalling in Ver 8.6?

Thx Jaymer, I originally had the fields as text type and then changed them to numeric. However, it appears that if you already have totalling fields defined in reports and queries against these field names, Aware doesnt re-set them to recognize the change. Once I re-saved the queries and reports a s...
by MarkP
Tue Mar 29, 2022 2:20 am
Forum: Problem reports
Topic: Bug in Group Totalling in Ver 8.6?
Replies: 2
Views: 2206

Bug in Group Totalling in Ver 8.6?

Hi everyone, Has anyone tried creating a new report in version 8.6 with Group totalling or Report totalling using <<SUM ...>>? Total Fields within reports created in my app using version 8.5 still work fine under 8.6 but any new reports created under 8.6 which include group/report totalling fields d...
by MarkP
Mon Oct 25, 2021 1:41 am
Forum: General discussion and questions about Aware IM
Topic: Error Message when trying to add new Attribute to BO
Replies: 6
Views: 2086

Re: Error Message when trying to add new Attribute to BO

Hi PointsWell, You are a genius! Looked through the XML code and found this in the FromEmailAddress attribute: ErrorResolved.jpg So removed the attribute direct from the tree as per your suggestion and then I was able to re-create it successfully as a new attribute. Thanks so much for your help. MarkP
by MarkP
Mon Oct 25, 2021 1:04 am
Forum: General discussion and questions about Aware IM
Topic: Error Message when trying to add new Attribute to BO
Replies: 6
Views: 2086

Re: Error Message when trying to add new Attribute to BO

Hi PointsWell, No its not a member of a BOG. I think what happened was that I was working in the attributes area one day and accidentally pressed the wrong keyboard keys together which may have resulted in some sort of Ctrl Key or Shift key plus other keys being pressed simultaneously. i.e. Ctrl N o...
by MarkP
Fri Oct 22, 2021 6:30 am
Forum: General discussion and questions about Aware IM
Topic: Error Message when trying to add new Attribute to BO
Replies: 6
Views: 2086

Re: Error Message when trying to add new Attribute to BO

There should be 1 BO called Sites in it.
If you try to modify this BO you will get the error.

Does this BO not exist?
by MarkP
Fri Oct 22, 2021 4:23 am
Forum: General discussion and questions about Aware IM
Topic: Error Message when trying to add new Attribute to BO
Replies: 6
Views: 2086

Error Message when trying to add new Attribute to BO

Hi everyone, I am trying to add a new attribute to an existing BO. but when I try to save the changes I get this error message: Aware Error Message.jpg It doesnt matter what type of attribute I try to add, it always gives me the same message. I dont have any image attributes or embedded images withi...
by MarkP
Wed Jul 14, 2021 12:12 am
Forum: General discussion and questions about Aware IM
Topic: Version 8.6 breaks android?
Replies: 3
Views: 1521

Re: Version 8.6 breaks android?

Thanks very much Jaymer. I have a full paid version - not trial so I just thought at least Tablet level support was included and the Mobile add-on was only relevant to mobile phones. Your suggestion worked a treat. So I will probably have to go back to Aware on this. BTW I really appreciate all of t...
by MarkP
Tue Jul 13, 2021 5:31 am
Forum: General discussion and questions about Aware IM
Topic: Version 8.6 breaks android?
Replies: 3
Views: 1521

Version 8.6 breaks android?

Hi Guys,

I have updated to Version 8.6 and now when I try to launch my app on an Android tablet, I am getting
"Feature is not supported in this product" errors.
Worked fine under 8.5
Happens at login when I try to submit the form.

Any ideas?

Markp
by MarkP
Mon Jul 05, 2021 11:11 pm
Forum: General discussion and questions about Aware IM
Topic: Removing DOWNLOAD DOCUMENT Message
Replies: 1
Views: 12111

Removing DOWNLOAD DOCUMENT Message

Hi everyone, I am running a process to download multiple report documents based on user selections. To do this I am using the DOWNLOAD DOCUMENT Action. This is working perfectly as per the image below: DocumentOutput.jpg The problem is that for every document downloaded, Aware pops up a message box ...
by MarkP
Thu Jun 10, 2021 1:19 am
Forum: General discussion and questions about Aware IM
Topic: EXEC_SP Call not working
Replies: 5
Views: 3098

Re: EXEC_SP Call not working

Thanks UnionSystems That got rid of the error messages - but unfortunately it killed the whole approach of trying to use a SELECT DISTINCT sql clause to build a unique customer name list as the ID field is always unique. :cry: I've worked out a different process approach on how to build the list - s...