Source procedure in a multi tenant app

[peterH]

Hi all,
In my multi tenant app I set the sql connection string in the web handler proc so the user hits the right db, no problem here.

But then I've got this (clarion) source proc that does some calc + updates using pure sql. Should I set the connection string here as well before issuing the sql statements? My guts say yes but I'm not quite sure I understand why 

Anyone?

Peter

[kevin plummer]

no as long as you have set it in the correct place in the web handler (process link embed) then the connection is set until that thread dies. If you were running the source procedure on its own thread then yes you would need to set it.

[peterH]

Thanks, Kevin.

[Rene Simons]

Hi Kevin,
That is a nice aspect you point out:"on its own thread".
How would i do that?
Thanks,
René

[peterH]

Start()