Column COnstrain
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=4103
Printed Date: 30 April 2025 at 1:51pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Column COnstrain
Posted By: barianto
Subject: Column COnstrain
Date Posted: 01 May 2006 at 7:15am
|
how to achieve column constrain using constrain from database which could be only one row or ten row?
|
Replies:
Posted By: sserge
Date Posted: 01 May 2006 at 6:12pm
It's not clear what do you mean by such descriptions of the constraint. Please try to clarify it in more details.
--
WBR,
Serge
|
Posted By: barianto
Date Posted: 01 May 2006 at 9:08pm
Sorry, english isn't my native language
i like to add column constrain to reportcolumn, something like your sample on "report sample - tasklist form". I cut the sample here :
Enum TaskImportance
taskImportanceNormal
taskImportanceHigh
taskImportanceLow
End Enum
Enum TaskStatus
taskStatusNotStarted
taskStatusInProgress
taskStatusCompleted
taskStatusWaiting
taskStatusDeferred
End Enum
...........
...........
...........
sub Form_load()
..............
..............
Set Column = wndReportControl.Columns.Add(COLUMN_IMPORTANCE, "Importants", 18, False)
Column.Icon = 2
Column.EditOptions.Constraints.Add "Low", taskImportanceLow
Column.EditOptions.Constraints.Add "Normal", taskImportanceNormal
Column.EditOptions.Constraints.Add "High", taskImportanceHigh
Column.EditOptions.AllowEdit = False
Column.EditOptions.ConstraintEdit = True
Column.EditOptions.AddComboButton
Set Column = wndReportControl.Columns.Add(COLUMN_ATTACHMENT, "Attachments", 18, False)
Column.Icon = 5
Set Column = wndReportControl.Columns.Add(COLUMN_STATUS, "Status", 100, True)
Column.EditOptions.Constraints.Add "Not Started", taskStatusNotStarted
Column.EditOptions.Constraints.Add "In Progress", taskStatusInProgress
Column.EditOptions.Constraints.Add "Completed", taskStatusCompleted
Column.EditOptions.Constraints.Add "Waiting on someone else", taskStatusWaiting
Column.EditOptions.Constraints.Add "Deferred", taskStatusDeferred
Column.EditOptions.ConstraintEdit = True
Column.EditOptions.AddComboButton
.......
.......
i want the column constrain came from database (mssql, mysql, etc).
can i achieve that?
|
Posted By: sserge
Date Posted: 02 May 2006 at 5:38am
A constraint is just a pair of text and long values (there in sample a long is represented with enumeration for easier reading).
You can keep those values somewhere in your database table, read it by yourself and add to the constraints collection in a loop.
--
WBR,
Serge
|
Posted By: barianto
Date Posted: 02 May 2006 at 6:11am
got the message, gonna try it out
Thanks, sserge
|
|