VNET properties and comment

[Thomas Flemming]

Hi Ruslan,

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


it seems as if you are doing some string-replacements here?
Im trying to save a filename like c:\myfiles\file.txt in a property.

But when I check in VStudio with SHOW PROPERTIES OF DATASE

the backslashs are missing and it looks like:  c:myfiles?file.txt

What kind of strings can I store in a property actually, which max. length?
What restriction?

Regards,
Tom


Ruslan Zasukhin schrieb:
> 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.
> 
> 

-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/