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

    wireless UWS4??

    HI guys, Has anyone managed to get the UWS4's working on a wirless network using WPA-PSK? If so what hardware did you use? thanks
  2. kevgais

    Micros UWS4's network printing

    Hi Guys, I would like to utilize our UWS4's to run some other web applications which is not a problem and working fine. But it seems I cannot attach a network printer. does anyone have any experience of this? or achieved it? thanks Kevin
  3. kevgais

    Micros Handheld Terminals Roaming accross revenue centers

    Hi Guys Running Micros 9700 V3. I have a number of handhelds that I wish to roam across multiple revenue centers. The problem is that the guest checks and receipts printers are defined in the device table so that when the handheld could be in another bar but the checks print of in another...
  4. kevgais

    format results into currency

    thank you so much for your help. it seems now though that the order by isn't working correctly as shown below: this is suppose to be sorted in desc order any ideas? thanks again. £97.20 £94.80 £91.50 £885.80 £85.15 £84.75 £84.55 £84.00 £83.30 £8.75 £8.55 £78.40 £77.00 £75.00 £74.65 £74.05...
  5. kevgais

    format results into currency

    Hi Guys, A complete noob here so be gentle. I have this statement (compiled from examples I have found on the web) which works fine, however I want the 'totalsales' column to be formatted into a currency format. set dateformat dmy SELECT convert(varchar,ChitClosedDateTime,103)...
  6. kevgais

    anyone have micros 9700 v3 documentation?

    Soon to be having this installed and wanted to have a read up so know what to expect etc... thanks Kev
  7. kevgais

    micros (9700 2.8) sql

    what are the reason to upgrade to micros v3 from 2.8?
  8. kevgais

    micros (9700 2.8) sql

    i currently use 8700sql method but would like to establish a odbc connection.
  9. kevgais

    micros (9700 2.8) sql

    Hi Guys, I've read the Micros 2.8 9700 supports SQL. Does anyone have experience of using it's SQL as I cannot establish any links to the my Micros database through normal SQL techniques. cheers
  10. kevgais

    images on epson tm-t88iii

    Anyone have experience of upload images to these printers? I've managed to do it using a network interface card and the epson utility but I have another 5O printers that all use the Micros interface card (a smaller rj45). I tried swapping the micros cards with the network card but the printer...
  11. kevgais

    get remote server system times into web page.

    Hi guys, Is there anyway I can get the current server date and time from remote severs I have in worldwide locations. Ideally having this displayed on a webpage? thanks for your thoughts/
  12. kevgais

    broadcast messaging with Micros

    thanks, do you have any furter details? any references on how to create a sim?
  13. kevgais

    broadcast messaging with Micros

    Hi there. Does anyone know if it's possible to send broadcast messages to all terminals of a micros system? the majority of the termials will be UWS 3 but there will be a few UWS4 and PCWS' Manybe there is a 3rd party application that can do this? thanks in advance
  14. kevgais

    SQL'ing into Micros

    thanks, how should excute this script? I normally create .sql files using notepad and run them from nutcracker using 8700sql -eaf export.sql thanks in advance. kevin
  15. kevgais

    Resturant Table control systems

    Hi All, Does anyone have any experince of these systems. Any good recommendations out there? I’m looking for some applications that can help control tables and seats etc.. Many thanks
  16. kevgais

    SQL'ing into Micros

    thanks regilobo. The 8700.log contained no additional information. Just the usual: "Command line: 8700sql -e -a -f 2.sql -t Command file set to 2.sql UPDATE mi_master_def SET number = number FROM mi_ma.txt WHERE number ge 1 le 50 Command error: Invalid syntax for UPDATE command Ending...
  17. kevgais

    SQL'ing into Micros

    Hi regilobo, thanks for the reply. unfortunaly I am still having issues with this. It would appear that 9700 doesn't support the WHERE command when using it with the INPUT command, maybe 9700 does support it but I cannot get it to work. your suggestions of splitting the file is not really an...
  18. kevgais

    Epson Printer TM-T88 III& WS4

    what do options do you have selected in the device table? you have to conifgure the WS4 device and the printer.
  19. kevgais

    SQL'ing into Micros

    thanks regilobo. I already use the input_from statement to update a whole table but what I want to do is UPDATE a range of records say the first 50,000 records. I would imagin the script to look like this. INPUT_FROM data.txt UPDATE * mi_master_def WHERE number >= 1 AND number <= 50000...
  20. kevgais

    SQL'ing into Micros

    sorry, forgot to mention that it is 9700 I'm using.

Part and Inventory Search

Back
Top