VNET properties and comment

[Bart Pietercil]

Hi Thomas,

I think you need to escape a string that contains backslashes when you  
submit it through sql.
You have a few alternatives

use valescape function (can't recall directly the correct function  
name, look in the WIKI)
use parameters (look in the WIKI for the correct syntax))

hth

Bart Pietercil
CTO Cognosis NV



On 04 Nov 2009, at 13:15, Thomas Flemming wrote:

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