VNET properties and comment

[Thomas Flemming]

 > hth
Yes :-)
Thanks, Tom


Bart Pietercil schrieb:
> 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
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> __________ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version 4572 (20091104) __________
> 
> E-Mail wurde geprüft mit ESET NOD32 Antivirus.
> 
> http://www.eset.com
> 
> 
> 
> 

-- 
/****************************************
**   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!
***************************************/