Print Page | Close Window

fSupplierFilter Error

Printed From: Almyta Systems
Category: Almyta Control System (ACS) and ABC Inventory
Forum Name: Installation, Updates, Technical Issues
Forum Discription: Dedicated to any technical issues of the application.
URL: http://www.almyta.com/forum/forum_posts.asp?TID=5663
Printed Date: 14 Jul 2020 at 11:17pm
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com


Topic: fSupplierFilter Error
Posted By: jrozek
Subject: fSupplierFilter Error
Date Posted: 31 Jan 2014 at 6:37am
Good Morning.  

I receive an error when I try to filter my assets by Asset Type. 
Pulling the error logs, I see the following:

Syntax error in string in query expression '((Asset.DC = 0) And ([AstTypID]="2)) ORDER BY Asset.AssetTag;'.

Note: Computer-Name-user.adm, Assets:fSupplierFilter

Error #3075.

I'm pretty sure I see where the problem is---it looks like a double quotation is missing in the [AstTypeID]. However, I cannot find where this expression is to fix it.

Can anyone provide assistance?  Thanks!



Replies:
Posted By: jrozek
Date Posted: 04 Feb 2014 at 12:16pm
Hello?

Anyone?


Posted By: Debra
Date Posted: 04 Feb 2014 at 2:14pm
Yes, the bug it there. I have just checked it. What version are you using?


Posted By: Debra
Date Posted: 05 Feb 2014 at 7:23am

you can close Almyta, download this file

http://www.almyta.com/downloads/acs_static.zip" rel="nofollow - http://www.almyta.com/downloads/acs_static.zip

and unzip into C:\AlmytaSystems folder.

This will fix the problem.



Posted By: jrozek
Date Posted: 05 Feb 2014 at 10:00am
Great!  Thank you!  Perfect!


Posted By: jrozek
Date Posted: 11 Feb 2014 at 10:28am
I am having this same error again.  We had to replace the machine this was on, so I installed on a new machine.

I copied your accdb file into the c:\almytasystems directory, but when I try to filter by asset type, it is once again giving me the "3075 error:"

Syntax error in string in query expression '((Asset.DC=0) And ([AstTypeID]="1))ORDER BY Asset.Asset.tag;'




Posted By: jrozek
Date Posted: 18 Feb 2014 at 8:02am
Not sure if anyone saw this?  


Posted By: Debra
Date Posted: 19 Feb 2014 at 6:35am
If you have version 37Z or older, you can update your software manually.
Close all instances of Almyta Control on the PC.
Download this file http://www.almyta.com/downloads/zipped_upd_312_37Z.exe" rel="nofollow - http://www.almyta.com/downloads/zipped_upd_312_37Z.exe into C:\almytaSystems folder.
Run the file or change the extension from .EXE to .ZIP and unzip manually.
Start Almyta Company Selector, high-light your company, click Maintain, click Update Now.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 - http://www.webwizforums.com
Copyright ©2001-2011 Web Wiz Ltd. - http://www.webwiz.co.uk