×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Simphony - SIM Interface how to connect to Database?

Simphony - SIM Interface how to connect to Database?

Simphony - SIM Interface how to connect to Database?

(OP)
Currently we work with RES 3700 and we have a SIM Interface that connects to the database to verify the employee's cash sale.

Migrating to Simphony, I would like to know the recommended way to connect to the Database. I understand that development can be done with .NET but I would like to know if it can be done from the SIM File to consult the Sale in cash or a Specific Tender Media. In this case it would be the CAPS CheckPostingDB database.


Thanks in advance for your comments.

RE: Simphony - SIM Interface how to connect to Database?

(OP)
Thank you very much for your answer. By any chance do you know of any manual that documents this variable a little more?

I searched and found this in the manual:
Oracle® MICROS Simphony
System Interface Module (SIM) Manual
Release 19.2.x
F32376-05

DATASTORE
Description
This system variable contains the .net object reference to the extensibility datastore.
7-28 ISL System Variables
Type/Size
object
Syntax
@DataStore
Remarks
• This system variable is Read-Only.
Please consult the .net extensibility documentation for methods and properties
available on this object.

From what I understand it has to do with extensibility in .net

On the other hand, I looked for more about the variable in this forum and codes like these caught my attention:

html = @DataStore.ReadExtensionApplicationContentTextByNameKey( @OpsContext.RvcID, @ApplicationName, "html" )
dbObject = @DataStore.ReadTenderMediaByNum(tmednum)
extDataVal = @DataStore.ReadExtensionDataValue("TENDER_MEDIA", DataExtName, dbObject.TendMedID.Value)

or

var ItemizerNames : object = new System.Collections.ArrayList()
var DiscountItemizersObj : object = @DataStore.ReadPropertyDescriptors().DiscountItemizers

So I would like to see what methods can be executed.

RE: Simphony - SIM Interface how to connect to Database?

(OP)
Sure, my email is issamich@hotmail.com

Thanks!!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close