Constraint |
Post Reply |
Author | |
barianto
Groupie Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |
Post Options
Thanks(0)
Posted: 18 May 2006 at 3:19am |
Column.EditOptions.Constraints.Add "", 0
second parameter constraint Add has to be long. If i want to connect constraint with database, including data is coming from database which has type string (it got to be string) what is the solution?? eq. Column.EditOptions.Constraints.Add "Mercedez Baby Benz", "C001" "C001" are code for "Mercedez Baby Benz" In another word, how to keep another data into reportcolumn constrain other than "caption"? I hope you understand with what i want, my english is really poor... |
|
sserge
Moderator Group Joined: 01 December 2004 Status: Offline Points: 1297 |
Post Options
Thanks(0)
|
Hi,
-- WBR, Serge |
|
barianto
Groupie Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |
Post Options
Thanks(0)
|
Thanks,
if my database are large, do you think it's will causing perfomance loss to my appplication? or will it break VB 64kb limit? |
|
sserge
Moderator Group Joined: 01 December 2004 Status: Offline Points: 1297 |
Post Options
Thanks(0)
|
Not sure, it depends on amount of your codes, on how would you access them, etc.
To eliminate all possible performance losses which could raise with this solution, I can propose you one more way: - you create a new database table (or view) which will have all string codes listed with integer ID for every of them; table structure like "CodeID; CodeString" - then you just put an ID of your code in the constraint and load it every time when needed from the database in a very simple and fast query. -- WBR, Serge |
|
barianto
Groupie Joined: 01 May 2006 Location: Indonesia Status: Offline Points: 41 |
Post Options
Thanks(0)
|
Well before ask this forum i'm using the method :), but it's really bother me to create new field just to overcome this matter.
But for a moment, i will stick with it. Btw, sserge would you please take a look at my question in this sub forum with thread subject "DETECT ROW.ITEM" i really need "suitable" solution in matter otherwise application i make with reportcolumn object is look not so good at that matter. Tks any way |
|
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 |