[V4MD] recId, Insert and Cursor question

[Ruslan Zasukhin]

On 3/11/04 11:18 AM, "Ivan Smahin" <ismahin at ks.aval.ua> wrote:

> RZ> You should use 2 query for now.
> 
> RZ> In Valentina 2.0 it will be possible to use subquery
> 
> RZ>    INSERT INTO T (f1, ptr)
> RZ>    VALUES ( 'aaa',
> RZ>             (SELECT recID FROM Department WHERE deptName = 'FOO') )
> 
> RZ> Although I am not sure this syntax will works.
> RZ> Ivan?

> Yes, it seems to me this is not standard feature. MS-SQL does not
> allow this trick but Oracle does.

> We support standard approach like
> INSERT INTO T (f1, ptr)
>  ( select 'aaa',  recID FROM Department WHERE deptName = 'FOO')

:-) little strange way actually,
But at least a way.

May be in future it is good idea make as Oracle also.

> Test for this syntax is passed.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------