VIEW in realbasic object model

[Andrew Dempsey]

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
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>