Solved

id_data_dictionary purpose or function

Posted on 2014-03-21
6
130 Views
Last Modified: 2014-03-24
Hello,
Could someone tell me what this line of code is doing? Escpecially the "id_dictionary_data" part.

rsdata.Filter = "id_dictionary_data = " & Trim(Str(CboHeaderFields.ItemData(CboHeaderFields.ListIndex)))
0
Comment
Question by:tesla764
  • 3
  • 2
6 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 250 total points
ID: 39946077
Its filtering the recordset to only show values where the "id_dictionary_data" column's value is equal to whatever value is in the CboHeaderFields.ListIndex variable. See http://msdn.microsoft.com/en-us/library/ee275540(v=bts.10).aspx for more info.
0
 

Author Comment

by:tesla764
ID: 39946099
Do you know where I can get more info on the id_dictionary_data?
0
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 250 total points
ID: 39946370
more info on the id_dictionary_data?
id_dictionary_data is a field in the rsdata record source.  You are filtering records.

Correction on the kaufmed comment...you are looking at the CboHeaderFields.ItemData value of the currently selected item in the combobox.  ItemData is a long integer value, so I would expect that id_dictionary_data is a long integer data type.  Also, this statement does not add any delimiters around the value, so it isn't expecting a string or date data type.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 39946405
It's just a column name, so I would start with the query that populates the recordset.
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 39946442
@aikimark

Thanks for the catch. A bit too fast on the copy there  = )
0
 

Author Closing Comment

by:tesla764
ID: 39950691
Thanks, that is very helpful.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now