http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 02 May 2026 00:51:58 +0000 Tue, 02 May 2006 06:11:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=4103 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12575&title=column-constrain#12575 Author: barianto
Subject: 4103
Posted: 02 May 2006 at 6:11am

got the message, gonna try it out

Thanks, sserge
]]> Tue, 02 May 2006 06:11:26 +0000 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12575&title=column-constrain#12575 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12574&title=column-constrain#12574 Author: sserge
Subject: 4103
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
]]> Tue, 02 May 2006 05:38:40 +0000 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12574&title=column-constrain#12574 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12568&title=column-constrain#12568 Author: barianto
Subject: 4103
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?




]]> Mon, 01 May 2006 21:08:01 +0000 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12568&title=column-constrain#12568 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12565&title=column-constrain#12565 Author: sserge
Subject: 4103
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
]]> Mon, 01 May 2006 18:12:11 +0000 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12565&title=column-constrain#12565 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12547&title=column-constrain#12547 Author: barianto
Subject: 4103
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?]]> Mon, 01 May 2006 07:15:50 +0000 http://forum.codejock.com/forum_posts.asp?TID=4103&PID=12547&title=column-constrain#12547