Windows script control

[xoggoth]

Client has an technical Access application with various algorithms in VBA. He wants a system where users can type in and run their own algorithms. Seemed like a piece of cake with Windows Script Control. However I find it only runs single line statements

eg with language as vbscript
if x=1 then y=2

is ok but

if x=1 then
y=2
endif
gives 'Statement expected'

There is no such limitation according to MS's help - it should run any valid vbscript. Anyone else had a problem?

Cheers

 

[hyperD]

Client has an technical Access application with various algorithms in VBA. He wants a system where users can type in and run their own algorithms. Seemed like a piece of cake with Windows Script Control. However I find it only runs single line statements

eg with language as vbscript
if x=1 then y=2

is ok but

if x=1 then
y=2
endif
gives 'Statement expected'

There is no such limitation according to MS's help - it should run any valid vbscript. Anyone else had a problem?

Cheers

Just come across this in a hungover stupor... is it

End If rather than endif?

 

[xoggoth]

Damn!!! I am so used to lazily typing a single word in VB or VBA and it gets auto changed to two.

Actually this did occurr to me earlier (honest) and thought I must remove this thread before somebody sees it and I look like a complete @rse.

Too late!!!!
Again!!!!!!!!!!!!!!!!!!

Anyway, cheers HD

 

[hyperD]

Jeez... I must code some more when I'm hungover - it seems to work...!

...that's about the first answer in years I've given that's been correct.

Mind you xoggoth...all that process engineering we've done in the past must have fuzzled our brains somewhat... I have done the very same thing as you have done - with all these different languages and syntaxes...I've even put that in using C# (a devil's language if I've ever seen one...hopefully Chico can exorcise that into oblivion)