customproperties to sql string ???

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Calendar control 13 / VB6
I can enter a value in a field CUSTOMPROPERTIES from calendar control that uses a database in access >> in a string sql, necessary to filter only the records desired to be included in activereport? 
eg. Event.CustomProperties.Property (propName) 
I'd like the syntax to add in a sql string this field result only 

select * from Events WHERE Event.CustomProperties.Property (propName)  = "Mario")

i tried many but nothing .... i can only looping  from all events, but i think the best is filter ..

tnx Mario

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
mario Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21 July 2014 Status: Offline Points: 4	Post Options Post Reply Quote mario Report Post Thanks(0) Quote Reply Topic: customproperties to sql string ??? Posted: 20 September 2014 at 7:09am
	Calendar control 13 / VB6 I can enter a value in a field CUSTOMPROPERTIES from calendar control that uses a database in access >> in a string sql, necessary to filter only the records desired to be included in activereport? eg. Event.CustomProperties.Property (propName) I'd like the syntax to add in a sql string this field result only select * from Events WHERE Event.CustomProperties.Property (propName) = "Mario") i tried many but nothing .... i can only looping from all events, but i think the best is filter .. tnx Mario