Solved

id_data_dictionary purpose or function

Posted on 2014-03-21
6
134 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

If you haven’t already, I encourage you to read the first article (http://www.experts-exchange.com/articles/18680/An-Introduction-to-R-Programming-and-R-Studio.html) in my series to gain a basic foundation of R and R Studio.  You will also find the …
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
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 …
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.

806 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