|  | 
| Column COnstrain | 
| Post Reply   | 
| Author | |
| barianto   Groupie     Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |  Post Options  Thanks(0)  Quote  Reply  Topic: Column COnstrain 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)  Quote  Reply  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 | |
|  | |
| barianto   Groupie     Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |  Post Options  Thanks(0)  Quote  Reply  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? | |
|  | |
| sserge   Moderator Group   Joined: 01 December 2004 Status: Offline Points: 1297 |  Post Options  Thanks(0)  Quote  Reply  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 | |
|  | |
| barianto   Groupie     Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |  Post Options  Thanks(0)  Quote  Reply  Posted: 02 May 2006 at 6:11am | 
| 
   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 |