SQL Server 2012 Express Edition,
limited functions in rules and actions in V4, excuse why? this happens?
Starting the same version: 4.1.68 until the last V4.1.82
Windows 8 Pro
Not sure what you mean. You need to explain more. What functions in rules are limited? There should not be any limited functions in rules and actions with sql express 2012.
Tell us what is happening and what your expecting. Which rules are not working and which actions are not working.
Excuse me for my bad English.
I see limitations in the following rule and Action.
I hope the image speak better than my English
What are you trying to do with that action and rule?
I am trying to select a certain group of customers for different discounts:
for example: FCA Group 1 customers have 95% discount
Customers FCA Group 2 have 85% discounts
Customers FCA Group 3 have 65% discount
Just to remind you that these rules and actions work correctly in SQL SERVER 2008
but when I updated to SQL SERVER 2012 version simply ceased to function
So you made no changes at all in SambaPOS you just upgraded to SQL server 2012?
yes, it was just upgrade to SQL 2012.
I tried to install earlier versions of the V4 where I had created the actions and rules, but still not succeeded.
Some automation also simply disappeared, Such as:
Note ticket
move
cancel
select Card
and more…
Did you go to Samba Market and make sure More Ticket Actions is activated and installed? Also go to Settings > Program Settings > Maintenance and click Rebuild Default buttons.
Not sure if {ENTITY NAME:Cliente} Starts FCA1 is correct but I could be wrong it just looks odd to me. Of course I do not know much about your setup other than what you have shown us so far.
Thank you, the question of the buttons of automation returned to work perfectly.
Thank U.
As the issue of group discounts, still without solution.
a few minutes to transfer the database to another PC with SQL 2008 this was fine with the same version of SambaPOS.
but not in SQL 2012 this worked.
Customers in this case are the official of the University.
divided into three categories for wages.
1- The Staff of the rectory of the university (high wages) 65% Discounts
2- The university teachers (average salary) 85% Discounts
3- The Staff cleaning, gardeners, drivers and other more … University (low wages) 95% Off
The government of my country pays the rest for them.
There is a state of the budget for that university.
This was the setting Unica I could do to automate discounts
and trace the employees.
I do not know if this is the way right? but it worked like this:
If I Was functioned as the SQL 2008 already could appear discounts below.
Try taking the action out of the rule. Saving it then opening and adding the action again.
hello kendash, I deleted the rule action saved and repeat all over again, still does not work.
I prefer to work with Windows 8, because it is lighter than the Win7, but SQL 2008 is not well compatible with the Win8, so I prefer to install Win 8.1 + SQL 2012
there other rules and kids that I can use to obtain the same function of discounts?
There must be something that went wrong because SQL express 2012 does not limit rule functions.
Check your mappings for your rules make sure everything is mapped.
Try disabling Toggle Calculation setting for calculation template.
Emre, as I disabled the Toggle Calculation, but still not solved the problem.
I can send to you guys a copy of my database?
Put a Show Message Action in your Rule so that is displays a message to ensure that the Rule is firing.
This works fine with Win8.1 x64, SQL Express 2014, SambaPOS 4.1.82
Delete the Rule, Logout, Login, rebuild the Rule, Logout, Login.
Also, do you have a Rule to handle removal of Entity or Change of Entity to reset the Discount? If not, you should make one, for example…
Then use Sort Rules to ensure the “remove” Rule fires before the Discount Rule…
What Is Entity Type Name? Cliente or Clientes