Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Column COnstrain
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Column COnstrain

 Post Reply Post Reply
Author
Message
barianto View Drop Down
Groupie
Groupie
Avatar

Joined: 01 May 2006
Location: Indonesia
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote barianto Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297
Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
barianto View Drop Down
Groupie
Groupie
Avatar

Joined: 01 May 2006
Location: Indonesia
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote barianto Quote  Post ReplyReply Direct Link To This Post 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?




Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297
Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
barianto View Drop Down
Groupie
Groupie
Avatar

Joined: 01 May 2006
Location: Indonesia
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote barianto Quote  Post ReplyReply Direct Link To This Post Posted: 02 May 2006 at 6:11am
got the message, gonna try it out

Thanks, sserge
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.203 seconds.