Calendar - customproperties to sql string ???

Print Page | Close Window

customproperties to sql string ???

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Calendar
Forum Description: Topics Related to Codejock Calendar
URL: http://forum.codejock.com/forum_posts.asp?TID=22416
Printed Date: 18 April 2024 at 10:02pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: customproperties to sql string ???

Posted By: mario
Subject: customproperties to sql string ???
Date 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