Micros Res 3700 POS Configurator

[cageking1]

Is there anyway to automate any of the functions of the POS Configurator application? It seems to me that all it is doing is making updates to the database but when I try to replicate this using SQL statements I break things.

More specifically, my client wants the ability to dynamically update the check trailer to provide bounce-back coupons that change depending on the day and meal time (lunch or dinner).

I know that this is all located in the trlr_def table and that it can be modified in the Sales->Descriptors->Trailers tab. But when I try to change an image in the trailert with a SQL statement it breaks the database and I have to roll back. I have no problem changing the text lines but for some reason the image lines are having an issue.

 

[jd11111]

Can you post your SQL statements? That might help determine what the problem is.

Also, what do you mean "breaks the database"? Exactly what happens?

 

[cageking1]

I'm just trying to update a particular line in the check trailer descriptor:

SELECT * FROM trlr_def
UPDATE line_01='~~logo.bmp'
WHERE name='Check Trailer'

I'm not sitting at my my desk right now so there might be some syntax errors in what I just typed but this is basically what I am doing. The SQL command executes just fine and I can see the updated record in the database. However the image is not being changed on the receipt when it is printed and when I go to try and change the image back using the POS Configurator it crashes. Yet when I try to do the same thing except with a text line like so:

SELECT * FROM trlr_def
UPDATE line_02='Changed text line here'
WHERE name='Check Trailer'

That works just fine, doesn't crash POS configurator, and prints like it should on the receipt.

 

[DrZogg]

If it is during an event that you want to change the trailer, you need a SIM. Look here

http://www.tek-tips.com/viewthread.cfm?qid=1637533

Get rid if the SELECT and try

UPDATE micros.trlr_def
SET line_02 = 'Changed text line here'
WHERE name='Check Trailer';

 

[cageking1]

DrZogg - That line is actually what I am using, but when I try to do it with an image is breaks. Text is fine.

 

[DrZogg]

Hi,

works without crashing for me. I changed the default ~~res3000logo.bmp to ~~res4000logo.bmp . Was logged in as DBA.

UPDATE micros.trlr_def
SET line_02 = '~~res4000logo.bmp'
WHERE trlr_seq = 2 ;
commit;

 

[cageking1]

DrZogg - Would you mind trying as both the Custom and Micros user and let me know if that works for you? Thanks so much!

 

[DrZogg]

Hi,
Update worked fine as custom user also.