Improve company productivity with a Business Account.Sign Up

x
?
Solved

id_data_dictionary purpose or function

Posted on 2014-03-21
6
Medium Priority
?
166 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 1000 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 47

Assisted Solution

by:aikimark
aikimark earned 1000 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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
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…
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

607 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