VIEW in realbasic object model

[Ruslan Zasukhin]

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]