![]() |
Column COnstrain |
Post Reply ![]() |
Author | |
barianto ![]() Groupie ![]() ![]() Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |
![]() ![]() ![]() ![]() ![]() 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?
|
|
![]() |
|
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
It's not clear what do you mean by such descriptions of the constraint. Please try to clarify it in more details.
-- WBR, Serge |
|
![]() |
|
barianto ![]() Groupie ![]() ![]() Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |
![]() ![]() ![]() ![]() ![]() |
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? |
|
![]() |
|
sserge ![]() Moderator Group ![]() Joined: 01 December 2004 Status: Offline Points: 1297 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
barianto ![]() Groupie ![]() ![]() Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |
![]() ![]() ![]() ![]() ![]() |
got the message, gonna try it out
Thanks, sserge |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |