I'm trying to run a stored procedure on a Sybase 11.0.1.2596 database (Micros RES 3700) in a PHP file using PDO and dblib as the driver. I can call a procedure with no parameters with no problems using something like:
call custom.show_clocked_in_employees
This works perfectly. However, if the...
I was trying to install ase160 on an AWS linux AMI instance, and I got these errors when running ./setup.bin:
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the...
Thank you so much! I'm not a Sybase expert so please bear with me. If I'm reading this right, this fires when an update is made in job_rate_def?
Does it grab the data from job_rate_def and immediately insert it into hist_job_rate_dtl?
It looks like it also copies data from...
Serenitee, you can also use a 3rd-party program if you need more functionality than what Sybase Central provides. I use a program called RazorSQL. It has a lot of features, one of which is the ability to search for tables and columns within tables. There are over 1000 tables in our version of...
I'm trying to figure out how & when data gets added to the hist_job_rate_dtl table. I thought maybe it was copied there from the job_rate_def table when the end of night runs for rows where the rate_effective_datetime matches the current date, but that doesn't appear to be it.
Does it come from...
Update on this - we sent the SIM that creates the popup in the screenshot to one of our 3rd-party micros people, and he said it is storing the calculated value of (cash tips - tips paid) in shift_emp_ttl.tips_decl_ttl. It does not also store each discrete value somewhere. I'm trying to find out...
micros.time_card_dtl.tip_decl_amt and micros.shift_emp_ttl.tips_decl_ttl both show the calculated amount, not the cash tips amount. In other words, in the screenshot example, they both contain 25.81, not 10.00.
We have Micros Res 5.2.
When our servers clock out they see a screen that looks like the image in the attachment. I'm trying to find out if Micros stores the Cash Tips value the server enters as a discrete value somewhere in its labyrinth of tables, or if it only stores the Net Tips value.
I...
I was able to get it working like this:
select
es.id,
es.escalation_id,
es.escalation_user_id,
max(es.`level`) as 'cur_level',
es.dt_added,
es.status_type_id
from
ABCD.t_escalation_status es
where
(escalation_id, `level`) in (
select escalation_id, max(`level`) from...
I was able to find a fix for this in a different forum. They suggested that I add the event listeners to the form itself and then route the event to the appropriate function based on the event type. It worked! It is SO much faster now!
In addition, it does a querySelectorAll to get an array of all the textboxes, and then loops through them all with the 4 addEventListener lines noted above.
It uses plain old javascript, no frameworks. It adds each of these event listeners to each text box:
focus
blur
keyup
keydown
It uses:
el.addEventListener(<event type>, <js function call>, <true/false>)
I have a website on our Intranet that is used by our accounting dept for financial planning. The site has about 20 tabs, and each tab has about 572 <input type="text"> boxes. When the pages load, the program adds event listeners to each textbox. On Firefox, this takes about 48 seconds, but in...
I was able to create a php script that uses dbisql to grab the contents of micros.sp_R_sys_menuitem_fam_grp and save it in a csv. I then was able to load the data into our MySQL database and query it there. It took forever to grab the data (3.2GB!) but it worked.
After that, I copied the...
Is it possible to call micros.sp_R_sys_menuitem_fam_grp and pass in a date range? It returns like 2 years of data when I run it and takes forever to run. Thanks!
I would like to load data from the micros.sp_R_sys_menuitem_fam_grp stored procedure into a temporary table so I can run some queries on it. I tried:
select
*
into
#t_test_sp
from
micros.sp_R_sys_menuitem_fam_grp();
but I get this error:
COMMIT/ROLLBACK not allowed within atomic operation...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.