Awesome... That is what I need, it really helps a lot. I will give it a try. I assume I will have to do D.Close or K.close whatever datastation I open at the top , close it at a step level.
Thanks a lot. Ranjit -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thom C. Blackwell Sent: Wednesday, January 16, 2008 9:52 AM To: [email protected] Subject: RE: [Talk] Access Database and Rules Scripting Greetings, You are correct, the DataStation (well the D instance of the DataStation object) accesses one table - just like it would access one text file, one Excel WorkSheet, one PDF file etc. One approach may be to write an Access Query that returns all the values needed and then access the Query from the DataStation which you can do. However if this is not possible, then you need multiple instances of the DataStation. To do this you would have the following statements placed at the very top of the script in the VBA editor Dim K as new DataStation Dim J as New DataStation Etc... You don't have to use a single letter btw. Could have MyTable1 as new DataStation but as you'll see, this could get cumbersome :) However, there are some letters NOT to use: R, D, W, F Then to open a table you would use: k.Open ... J.Open And fields from each would be named: K("MyField"), J("MyField") The WorkStation's UI does not support "creating and using" these multiple instances graphically, so there will be code editing involved here. The only really tricky bit is managing the "end of file" detection within the created DataStation objects because the Rule command's EOF / Not EOF detection is tied to the D instance of the DataStation. So you'd have to detect this in code: If K.EOF then End if Or perhaps when you are at the end of D's table, that's what matters, since you'd also be at the end of K and J? Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com Sign up for my weekly webinar! 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. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bendapudi, Ranjit Sent: Wednesday, January 16, 2008 10:38 AM To: [email protected] Subject: [Talk] Access Database and Rules Scripting Hello all, Is it true that we can open an Access database and can access only one table via File Open function in DataStation? Because every time I open Access file in Datastation it saves only the last selected table name in the bds file. I have multiple tables in my access database and at various Steps in my Rules based script I need to access different tables. I can do ADODB connection to this access Db but don't know how to pass record sets objects to the rules and conditions. Any help or advice is appreciated . Thank you Ranjit Bendapudi FCGIS [EMAIL PROTECTED] (615)-507-8054 This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient. Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. This email may contain material that is confidential, privileged, and/or attorney work product for the sole use of the intended recipient. Any review, reliance, or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
