Referencing a database during posting

[Scuba Jon]

Hi all

 

I am working on a project where I post a job. During that post I would like to query a database file and return the results of that query to my post before completing it (the post). The results will be output in the psof$ block of the post with a custom G-code.

 

I have been trying to develop a strategy to do this and have not been completely successful yet.

 

My current plan is to create an .exe file (probably in Access) that I can call from the post (LAUNCH command) and have that .exe file save the data on my computers C-drive in a .txt file. I can then access that .txt file as a buffer file from my post (I think).

 

My question is does anybody know if there is a more direct way to open and retrieve data from database file that doesn’t require all these steps?

 

I have done a little exploring using a Mastercam VBScript to do this but do not see anyway to open a database file with that.

 

I am just in the planning stages of this so my options are still wide open.

 

As always, thanks for your help

[Roger Martin from CNC Software]

Randy,

Not that I've done this, but a quick Google on these keywords 'VBScript database query' brought up some interesting stuff...

A Generic GetRows VBScript Class

 

And Yes, I'd assume that way to get the data over to the PST is to have the "other" side write that data out to a data file that could be accessed within the PST as a Buffer File.

[Colin Gilchrist]

Hi Randy,

 

You might try emailing [email protected]. I think Paul Decelles might have and idea or two.

[Scuba Jon]

Thanks Roger & Colin.

It's going to take me a while to digest that Generic GetRows VBScript Class but on first glance it looks like it could be useful (If not this project then some future one).

 

Anymore suggestions from our educated masses?