Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. raphael75

    trying to call Sybase stored procedure with parameters from PHP

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

    installation errors on AWS Linux AMI

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

    installation errors on AWS Linux AMI

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

    Micros Res 3700 - How/when do entries get added to hist_job_rate_dtl (pay rate history)

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

    Micros 3700 database table listing

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

    Micros Res 3700 - How/when do entries get added to hist_job_rate_dtl (pay rate history)

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

    Does Micros store Cash Tips as a discrete value?

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

    Does Micros store Cash Tips as a discrete value?

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

    Does Micros store Cash Tips as a discrete value?

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

    help with query getting max number per row with multiple rows

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

    help with query getting max number per row with multiple rows

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

    Firefox super slow at adding event listeners

    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!
  13. raphael75

    Firefox super slow at adding event listeners

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

    Firefox super slow at adding event listeners

    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>)
  15. raphael75

    Firefox super slow at adding event listeners

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

    load data from micros sp into table

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

    v_R_sys_menuitem_fam_grp

    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!
  18. raphael75

    load data from micros sp into table

    BTW, it's Sybase 11.0.1.2596
  19. raphael75

    load data from micros sp into table

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

    sales tax on discounted items

    Sorry - it's Micros RES 3700 5.2.

Part and Inventory Search

Back
Top