VIEW in realbasic object model

[Andrew Dempsey]

Interesting!
------------------------------------------------
Andrew Dempsey
andrew at andrewdempsey.com



On Nov 7, 2010, at 7:59 PM, Ruslan Zasukhin wrote:

> On 11/7/10 4:38 PM, "Andrew Dempsey" <andrew at andrewdempsey.com> wrote:
> 
> Hi Guys,
> 
> Well, about 10 years ago I was sure that Valentina will not have views,
> because I did plan to have inheritance, as much more powerful feature.
> 
> Later we decide, since we are Object-Relational DBMS, then we need support
> all common RDBMS features plus something more.
> 
> 
>> Thanks Ivan for your fast response.
>> 
>> I was curious to see whether I could modify a previous app I had put together
>> that used the API approach, to be able to take custom SQL statements from the
>> user and implement them... without having to redo much of my existing code.
>> 
>> The functional equivalent of an SQL View seems to be a VCursor, and the
>> VCursor is nice to work with in the API.  So I will do some re-writing of my
>> code and see where it goes.
>> 
>> ------------------------------------------------
>> Andrew Dempsey
>> andrew at andrewdempsey.com
>> 
>> 
>> 
>> On Nov 7, 2010, at 2:23 PM, Ivan Smahin wrote:
>> 
>>> Hello Andrew,
>>> 
>>> Sunday, November 7, 2010, 2:03:05 PM, you wrote:
>>> 
>>>> Can anyone help me on how I create/access a VIEW in the RealStudio object
>>>> model?
>>> 
>>>> I had hoped I could create it using an SQL expression, such as for example
>>> 
>>>> call DB.SQLExecute("CREATE VIEW myCheckedItems AS SELECT * FROM
>>>> checkedItems WHERE ptrUserAccount = 1")
>>> 
>>> Yes, correct.
>>> 
>>>> and then access it using the object model.  But I am not sure what
>>>> to access it as.  I tried DB.Table("myCheckedItems") but that
>>>> returned nil, and I am not sure what will work. As well as how to
>>>> create the view in the first place using the object model, not the sql
>>>> model.
>>> 
>>> Currently there is no way to get access to views via API.
>>> 
>>> But  internally  there are not sort of tables but sort of stored queries
>>> instead.  So you can not do much with it even having ability to get some
>>> object reference.
>>> In other words there are kind of objects from sql-world.
>>> 
>>> May I ask you to describe why do you need it in this way?
>>> 
>>> 
>>> -- 
>>> Best regards,
>>> Ivan Smahin 
>>> Senior Software Engineer
>>> Paradigma Software, Inc
>>> Valentina - The Ultra-Fast Database
>>> http://www.valentina-db.com
> 
> 
> -- 
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>