Can you call a Servoy method from a vbscript?

[Anne Verrinder]

The subject says it all ... is this possible?

[Jan Blok]

No it is not, but what do you want to accomplice?

[Anne Verrinder]

Hi Jan,

We would like to be able to trigger a Servoy method from an Access app. Have a 126-table database (in MSSQL Server), with a partial Access GUI. GUI for 35 of these tables is being done in Servoy (and possibly the Access GUI will be redone also). So for now, we'd like to be able to have Access trigger a method in the Servoy solution. Hope that makes sense.

Thanks!

Anne

[Jan Blok]

The only thing you could do is place a value in a (special) table in access and look it up using a custom query in Servoy (and trigger method if the column has special value indicating somthing has to happen)

[Anne Verrinder]

Thanks, Jan.

We're already using that method for other things (what's in Servoy used to be in FileMaker), and FMP would write a 'request' record in a "transit" table, and trigger a vbscript to tell the Access side to pick it up; Access would use ActiveX to tell FMP a "result" record was there. Worked great with the plug-in.

Since a user who initiates the request for info will be the same one who needs the result, I guess we can teach them to use ALT-TAB to go back to Servoy and use a "pick it up" method to check for the the result once they've created or selected what they want in Access and the "result" record is there in the transit table.

Thanks Jan! This is better than poking around looking for something that isn't going to happen. We'll make it work.

Anne