micros SIM help - void event

[jd11111]

I am working on a sim and need to script a database update when a specific discount is voided.

The sim is currently querying the database to confirm that a number hasn't been used, posts a discount on the check and then updates the database to mark that record as used.

Now I need the sim to update the record back to unused if the discount is voided from the check. How to script this event in ISL?

 

[azrobert]

I think jd11111 is on the right track....
I took out the connection string and am still connecting to
the Micros db....
any one find the close command ?

Robert

 

[azrobert]

It was the close command that was needed
it is:

DLLCALL_CDECL h_sql, sqlCloseConnection()

in case anyone needs it

 

[jd11111]

azrobert - so you did get it working?

 

[azrobert]

I am able to connect to my hosted sql server database and retrieve information from inside a sim. I am not doing anything with it yet.... I have several plans.... I would like to write a sim to handle my gift cards (currently on a separate terminal in each location), develop a guest loyalty program, and handle house accounts chain wide.

This was kind of the missing piece of the puzzle for me after years of looking LOL

I have been sending data with applications I have written to my sql database for years, things like payroll info, sales info but have never been able to access outside data from within Micros till now.

long story short yes, I kind of got it working in my context. I am not very strong in sim took a Micros training class in Vegas years ago but never developed much myself besides the stock sims that our dealer developed so I have a long way to go.

 

[azrobert]

Any one have any experience working with a recordset retreived with MDSSysUtilsProxy.dll inside a sim ?

Thanks