Search results for query: *

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...

Turned out the /tmp directory didn't exist. I created it and I was able to install.

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...

...2116 53 2016-01-07 21:13:12.000000 2320 2016-01-07 15:13:38.933000 If I do this: select * from micros.job_rate_def jrd where jrd.emp_seq = 2116 it returns: emp_seq job_seq pay_reason_seq override_reg_pay_rate...

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 have data that looks like this: id escalation_id escalation_user_id level dt_added status_type_id 126 92 390 0 12/02/15 01:52 PM 4 127 93 390 0 12/02/15 01:53 PM 4 128 93 77 1 12/02/15 01:57 PM 1 129 94 390 0 12/02/15 01:58 PM 4 130 94 77 1 12/02/15 02:19 PM 2 131 93 77 2 12/02/15 02:20 PM 1...

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...

...these lines: SET @start_business_date = COALESCE(@start_business_date,DATE([highlight #CC0000]business_date_start[/highlight])); -- YEARS(NOW(*),-10) SET @end_business_date = COALESCE(@end_business_date,DATE([highlight #CC0000]business_date_end[/highlight])); -- YEARS(NOW(*),10) and if...

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!

BTW, it's Sybase 11.0.1.2596

...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 Is...

Sorry - it's Micros RES 3700 5.2.