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: 04 December 2024 at 2:19pm
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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net