<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Got it !<div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal 'Lucida Grande'; ">This works</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal 'Lucida Grande'; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal 'Lucida Grande'; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal 'Lucida Grande'; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal 'Lucida Grande'; ">update advita_import set user_recid = ( select tbl_users.recid from tbl_users where advita_import.employee_id = tbl_users.hr_db_id) </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal 'Lucida Grande'; ">where employee_id = (select hr_db_id from tbl_users where advita_import.employee_id = tbl_users.hr_db_id)</div><div><br></div><div><br></div><div>still I think this could be written more elegant. </div><div>Let's ask Ivan (I owe him already so much beer I'm fearing for his health) in the morning. I'm sure he'll come up with something nice ;-)</div><div><br></div><div><br></div><div>Thanks Thorsten for putting me on the right track</div><div><br></div><div><br></div><div>Bart</div></div></div><div><br></div><div><br><div><div>On 30 Jan 2009, at 23:48, Bart Pietercil wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Yep, crashes as well .<br><br><br>just working in VStudio Pro from 5/1/2009. I think it is b15<br><br>So local db on OSX<br><br>Bart<br><br><br>On 30 Jan 2009, at 23:42, Thorsten Hohage wrote:<br><br><blockquote type="cite">Hi Bart,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">On 2009-01-30, at 23:39, Bart Pietercil wrote:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">well this crashed VS :-)<br></blockquote></blockquote><blockquote type="cite">:-)<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">update advita_import set user_recid = ( select tbl_users.recid from<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">tbl_users where advita_import.employee_id = tbl_users.hr_db_id);<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">It was accepted by the parser but calling the proc --> crash<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Did you try to use the statement without the SP around? Just to be<br></blockquote><blockquote type="cite">sure it works for you?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">What version were you using ?<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">VServer 4.0, Kernel 4.0 b12<span class="Apple-tab-span" style="white-space:pre"> </span>-<span class="Apple-tab-span" style="white-space:pre"> </span>VStudio Pro same version on Mac OS X<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">regards,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Thorsten Hohage<br></blockquote><blockquote type="cite">-- <br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Valentina Technology Evangelist<br></blockquote><blockquote type="cite">generic objects GmbH - Leiter Solution Center Nord<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">Valentina mailing list<br></blockquote><blockquote type="cite"><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br></blockquote><blockquote type="cite"><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></blockquote><br>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></div></blockquote></div><br></div></body></html>