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