VNET properties and comment

[Ruslan Zasukhin]

On 10/28/09 7:21 PM, "Thomas Flemming" <tf at ttqv.com> wrote:


> mDB.SqlExecute("SET PROPERTY myprop OF TABLE [" & mTbl.Name & "] to
> 'myvalue';")

I think THIS works fine.
After 

    db.Close()

You must be able open db in Vstudio and see your new property in the Schema
Editor.

Also in the SQL Editor you must be able do

    SHOW PROPERTIES OF TABLE name

And see system properties and YOUR.


**************
> Dim qr As IVQueryResult
> qr = mDB.SqlQuery("GET PROPERTY myprop OF TABLE [" & mTbl.Name & "]")
> 
 
> but somehow, this doesnt work.

> Where in the IVQueryResult is the value?

In the VCursor

> Dont you have a small sample, how to use this correctly ;-)  ?

I think more simple to use SqlSelect()

Dim curs As VCursor
curs = mDB.SqlSelect("GET PROPERTY myprop OF TABLE [" & mTbl.Name & "]")

You should get cursor with ONE record and ONE FIELD

  prop_val = curs.Field( "myprop" ).value

Something like this.


-- 
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]