Search results for query: *

I am using Micros 9700. I need to have the trailers print in a Journal Printers. Does this option exist? If that is not an option is there an option to print the guest check in the Journal Printer? I think if that happens the trailers will print on the Journal too. Right now I have no way of...

Thanks Bo, I probably will end up doing that but it would be good if there is a way to apply Equal Pay programmatically. Can you tell me how to disable Equal Pay? I am sure you know this but I found that one way to undo the Equal Pay is to split the check and move all the items in the second...

There is this feature in Aloha, called Equal Pay. In the payment screen you hit the Equal Pay key, you select the number 2 and the amount to pay is split in 2. You can select one of the payments and pay cash etc. for it. All is well. Now suppose that you have your special mode of payment...

Thank you guys. That was very helpful.

I have a table like this: DECLARE @operator_activity TABLE ( account_id INT, operator_id INT, num_trans INT ) I need to find the max value of num_trans for each account and also the corresponding operator_id. So I write something like this: DECLARE @operator_activity TABLE (...

Thanks guys, both your queries are instructional.

I have this table: DECLARE @transactions TABLE (account_id INT, amount INT) INSERT INTO @transactions VALUES (1, 1) INSERT INTO @transactions VALUES (1, 2) INSERT INTO @transactions VALUES (1, 3) INSERT INTO @transactions VALUES (2, 2) INSERT INTO @transactions VALUES (2, 2) I want to write a...

Thanks George. That is an wonderful trick.

I have a table like this: Declare @transactions Table(tran_id Integer, account_id Integer, tran_date datetime) Insert Into @transactions Values(1, 1, '2006-06-08 08:00:00') Insert Into @transactions Values(2, 1, '2006-06-08 14:00:00') Insert Into @transactions Values(3, 2, '2006-06-09...

Thank you guys. The LEFT OUTER JOIN did it. For future readers of this thread I think it is worth mentioning that the join is way faster if the 2 tables are ordered by the join attribute. In that case the optimizer can perform a MERGE JOIN. I discovered this the hard way.

That works but it is a bit slow. Table2 has 500,000 rows. Table1 has 20,000,000 rows. I could use all speed ups that I can get.

Yes, they have the same primary_key.

I have 2 tables, table_1 and table_2. Table 1 has all the rows of table_2 and some more. I need to find the rows in table 1 that are not in table 2. All I could think of is to use a cursor. There has to be another way, right?

Yes Shankar, part of the information that I need to hide is licensing information. I will certainly encrypt it but the keys will be in code. This program is going to be distributed in a country where piracy is rampant. There are kids who wouldn't mind spending months of their life figuring out...

I have an application which uses a SQL Server Express database. There are tables in the database that contain information I do not want users of the application to be able to see or be able to change. However since I do not have control over the database file, the user can simply install a copy...

The latest mention in the Radiant website is some press releases from 2001. Meanwhile they still continue to offer a POS for Gas stations, but it doesn't have the same name. I may know more in the future when I get an actual terminal.

One of my functions at my job is to integrate our product to different POS systems. Micros, Aloha, the usual. I have followed the forum and I have learned lots of useful info about those systems. Lately I was asked to integrate to Radiant Lighthouse systems. The first thing I did was to come and...

Thanks Adam. Your information is valuable because it lets me know that there are 4695 that are set up as keyboard wedge. My terminal is not set up as keyboard wedge. I did the Notepad test but nothng happens. I do not know if the difference is because some versions of 4695 came with keyboard...

I have a program that reads a card throught the Magnetic Stripe Reader (MSR). I am having a problem with an old IBM 4695 terminal, running Windows NT SP6. My program can read both keyboard wedge MSR and OPOS MSR. But IBM 4695 seems not to have a keyboard wedge. I was thinking that I could use...

Yes, it is fixed in 5.3.17. They released this on January 31, but I was able to test it today. I can confirm that it works fine. Thanks everybody for their help.