I don't claim to know much about Cache, but typically when you create tables in a database (or whatever Cache may call them), there's a way to update them and add to them "manually". That would be a good place to add your data. Also, I'd imagine that there's an ODBC Connection and an import from Excel facility in Cache, even though it's an object oriented database, and VB should be able to stuff data into it.
Rich McNeil Boston Software Systems 866 653 5105 x 813 www.bostonworkstation.com See us at MUSE booth 318 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Stevenson Sent: Monday, July 09, 2007 12:09 PM To: [email protected] Subject: RE: [Talk] BWS 9.0 & Cache Database TRUE TRUE - The data I will be storing is for reporting purposes - The data will not be placed or accessible from any GE screens. I am hoping to do this so that I can omit the time of having to build the screens and so the I am not under the constraint of the screen refresh rate. Brian Stevenson - Systems Administrator University Health System - Business Information Systems Office: (210) 358 - 9282 Pager: (210) 756 - 0582 Fax: (210) 358 - 9287 _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Charbonnier Sent: Monday, July 09, 2007 10:03 AM To: [email protected] Subject: Re: [Talk] BWS 9.0 & Cache Database If you're going to build your own storage from scratch, then it should be pretty straight-forward. The wizards in Cache will use the List Build property in creating the global, which will automatically map it to an ODBC accessible class method. The hard part (and the contractually "iffy" part) comes when you try and map out the old legacy globals to an ODBC. Sounds like instead of going directly, your moving data into a home-grown global, in which case you can use the stream method to just read out of the legacy global into your own and do all your set and kills there. Please let me know how this turns out for you, as I am always getting questions about this. Since it's a lot of work, my stock answer is "No...not possible. Use DBMS/Chronicles and get out of my cube". Because you know, once you map out REG info, they're just going to want Sched and BAR and MCA and anything else they can think of... Good luck, Peter On 7/9/07, Brian Stevenson <[EMAIL PROTECTED]> wrote: Thom, They would heavily frown upon setting values in their globals - contractually - however they give us an option of creating a custom global in a custom UCI that we can access at our own risk so for what I am trying to accomplish I would design and create the layout of this custom global in this public UCI so that I can access or set at my own risk. Thanks for the link - I will definitely be looking at this since this would be A LOT faster than the alternative. Brian Stevenson - Systems Administrator University Health System - Business Information Systems Office: (210) 358 - 9282 Pager: (210) 756 - 0582 Fax: (210) 358 - 9287 _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thom C. Blackwell Sent: Monday, July 09, 2007 8:36 AM To: [email protected] Subject: RE: [Talk] BWS 9.0 & Cache Database Greetings, I do not profess to have any special knowledge here J According to Intersystems (maker of Cache) - SQL is "built in"? and the below seemed to provide good info on same. http://vista.intersystems.com/csp/docbook/DocBook..UI.Page.cls?KEY=GSQL_conf ig So presumably, this <could be> used as a way of getting data out - I do not know whether or not GE would frown significantly (i.e contractually) upon actually using this approach - or how difficult this would be to actually get usable information - I'm guessing their data structures would be quite complex and figuring out the correct SQL may not be for the faint of heart. I'm pretty sure they'd frown significantly on using this approach to get data into their system - most vendors I've been involved with don't take to kindly to folks putting stuff directly into their tables. Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] On Behalf Of Brian Stevenson Sent: Monday, July 09, 2007 9:20 AM To: [email protected] Subject: RE: [Talk] BWS 9.0 & Cache Database Peter, We do use GE Flowcast 3 (going to 4 soon) but I was wondering if there was a way to access Cache without the screens - They can be so slow... I was thinking of the ODBC connection but am unaware of how this works or if possible. Brian Stevenson - Systems Administrator University Health System - Business Information Systems Office: (210) 358 - 9282 Pager: (210) 756 - 0582 Fax: (210) 358 - 9287 _____ From: [EMAIL PROTECTED] [mailto: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] On Behalf Of Peter Charbonnier Sent: Thursday, July 05, 2007 3:23 PM To: [email protected] Subject: Re: [Talk] BWS 9.0 & Cache Database Brian, The short answer is "yes". Cache programmer mode/terminal text sessions can be emulated with WRQ Reflection, which BWS 9.0 has a connection for. You might be able to use the terminal client included with Cache, but this would be trickier. The long answer involves how you actually intend to read/write to the DB. Cache is a DB and a scripting language and for the most part people store and retrieve data via some 3rd party application (like Epic or GE Flowcast). You can do this because the GUI is already written, and you can just set up a script to send keys based on prompt like with any other app. If you have an "empty" Cache install and want to use BWS to write data into home-made globals...there are better ways to get data into Cache (like with ODBC). ~Peter On 7/5/07, Brian Stevenson <[EMAIL PROTECTED]> wrote: Can BWS access a Cache Databases? Brian Stevenson - Systems Administrator University Health System - Business Information Systems Office: (210) 358 - 9282 Pager: (210) 756 - 0582 Fax: (210) 358 - 9287 _____ CONFIDENTIALITY NOTICE: This communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that any use, dissemination, forwarding, distribution, or copying of the communication is strictly prohibited. Please notify the sender immediately by e-mail if you have received this by mistake and delete this e-mail from your system. (University Health System) _____ CONFIDENTIALITY NOTICE: This communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that any use, dissemination, forwarding, distribution, or copying of the communication is strictly prohibited. Please notify the sender immediately by e-mail if you have received this by mistake and delete this e-mail from your system. (University Health System) _____ CONFIDENTIALITY NOTICE: This communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that any use, dissemination, forwarding, distribution, or copying of the communication is strictly prohibited. Please notify the sender immediately by e-mail if you have received this by mistake and delete this e-mail from your system. (University Health System) _____ CONFIDENTIALITY NOTICE: This communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that any use, dissemination, forwarding, distribution, or copying of the communication is strictly prohibited. Please notify the sender immediately by e-mail if you have received this by mistake and delete this e-mail from your system. (University Health System)
