Column COnstrain |
Post Reply |
Author | |
barianto
Groupie Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |
Post Options
Thanks(0)
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 |
Post Options
Thanks(0)
|
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 |
Post Options
Thanks(0)
|
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 |
Post Options
Thanks(0)
|
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 |
Post Options
Thanks(0)
|
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 |