SQL Question

[Bart Pietercil]

Got it !

This works


update advita_import set user_recid = ( select tbl_users.recid from  
tbl_users where advita_import.employee_id = tbl_users.hr_db_id)
where employee_id = (select hr_db_id from tbl_users where  
advita_import.employee_id = tbl_users.hr_db_id)


still I think this could be written more elegant.
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 ;-)


Thanks Thorsten for putting me on the right track


Bart


On 30 Jan 2009, at 23:48, Bart Pietercil wrote:

> Yep, crashes as well .
>
>
> just working in VStudio Pro from 5/1/2009. I think it is b15
>
> So local db on OSX
>
> Bart
>
>
> On 30 Jan 2009, at 23:42, Thorsten Hohage wrote:
>
>> Hi Bart,
>>
>> On 2009-01-30, at 23:39, Bart Pietercil wrote:
>>
>>> well this crashed VS :-)
>> :-)
>>
>>
>>> update advita_import set user_recid = ( select tbl_users.recid from
>>> tbl_users where advita_import.employee_id = tbl_users.hr_db_id);
>>>
>>> It was accepted by the parser but calling the proc --> crash
>>
>> Did you try to use the statement without the SP around? Just to be
>> sure it works for you?
>>
>>
>>> What version were you using ?
>>
>> VServer 4.0, Kernel 4.0 b12	-	VStudio Pro same version on Mac OS X
>>
>>
>> regards,
>>
>> Thorsten Hohage
>> -- 
>>
>> Valentina Technology Evangelist
>> generic objects  GmbH - Leiter Solution Center Nord
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090130/60cbcce2/attachment.html