Solved

ActiveX  ADO Shape WTL

Posted on 2002-04-22
13
271 Views
Last Modified: 2013-11-25
hi
i have a problem, a big one
i build an active x control that receive from a vb programm a shape recordset
like this


STDMETHODIMP CXGrid::putref_DataSource(IDispatch *newVal){
long i;
BSTR bstrColumnTitle;
CString sColumnTitle;
DataTypeEnum pDT;
m_rsDataSource=CComQIPtr< ADORecordset >( newVal);
CComPtr<ADORecordset> rsLevel2;
ADOFields* pFields;
ADOField* pField;
m_rsDataSource->get_Fields (&pFields);
long count;
pFields->get_Count (&count);
for(i=0;i<count;i++)
{
     pFields->get_Item(CComVariant((long)i),&pField);     pField->get_Name(&bstrColumnTitle);
     pField->get_Type(&pDT);
     if(pDT==adChapter)
     {
//     rsLeve2=CComPtr<ADORecordset>(pField);
     }
     else
     {
     sColumnTitle=bstrColumnTitle;
     InsertColumn(i,bstrColumnTitle,0,200);
     }
}
return S_OK;
}

i need to know how to load rsLevel2 with the child recordset provided by the shape conection

thank you in advance for your help






0
Comment
Question by:ValentinRozescu
  • 6
  • 4
  • 2
  • +1
13 Comments
 
LVL 49

Expert Comment

by:DanRollins
ID: 6961267
I can't tell from the code... What data do you want to be in rsLevel2?


In general, you will need to Open a recordset, passing in a table name or other SQL SELECT statement.

-- Dan
0
 
LVL 1

Author Comment

by:ValentinRozescu
ID: 6962028
my recordset is open and I can 'browse' it
my problem is that I can't read the child recordset from the data shape provider
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 6962165
I don't see anywhere that you try to access the data or do a MoveNext or other data access operations.

>>I can't read the child recordset from the data shape provider

I don't know what the child recordset is.

-- Dan
0
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.

 
LVL 1

Author Comment

by:ValentinRozescu
ID: 6962179
i use this and it worked:
rsLeve2=CComQIPtr<ADORecordset>(vValue.pdispVal);

thanks for all the comments
0
 
LVL 11

Expert Comment

by:griessh
ID: 7122141
Dear ValentinRozescu

I think you forgot this question. I will ask Community Support to close it unless you finalize it within 7 days. You can always request to keep this question open. But remember, experts can only help you if you provide feedback to their questions.
Unless there is objection or further activity,  I will suggest to

     "refund the points and PAQ at zero points"

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
======
Werner
0
 
LVL 1

Author Comment

by:ValentinRozescu
ID: 7123881
hi griessh
what can I do now?
no one answer to my question exept myself
how can I close the question?
0
 
LVL 11

Expert Comment

by:griessh
ID: 7124449
Valentin

First of all thanks for coming back! That just shows ud that you care.
It sounds like you wouldn't have a problem with closing this question. I think Dan gave some valuable advice worth to be kept around and you offered your own solution. Therefore I suggested to refund your points. Just wait those 7 days and one of the moderators will probably follow my recommendation ...

======
Werner
0
 
LVL 1

Author Comment

by:ValentinRozescu
ID: 7124474
hmmm... of course i care
EE is a valuable resource for me.
what do you mean by 'refund my points'?
0
 
LVL 11

Expert Comment

by:griessh
ID: 7124539
"Refund"? If you don't get an answer, you will get the points back you offered. Right now they are in a kind of account used to 'pay' the experts. Since you don't have to pay anybody, you'll get them back!

=======
Werner
0
 
LVL 1

Author Comment

by:ValentinRozescu
ID: 7124583
good idea
but, how can i do that?
if i put 0 in "1. Increase points to: " edit box i rceive, obviously: "You cannot decrease the value of a question once posted."

0
 
LVL 11

Expert Comment

by:griessh
ID: 7128245
As I said already ... just wait those 7 days, they will give your points back.
0
 
LVL 1

Author Comment

by:ValentinRozescu
ID: 7129123
ok
thanks again
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 200 total points
ID: 7138074
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need to impress with my knowledge of .NET 5 89
Dialogbox API leak? 18 93
What .NET website keeps me current? 9 68
How to LOAD up a .NET Framework website with data? 2 54
When writing generic code, using template meta-programming techniques, it is sometimes useful to know if a type is convertible to another type. A good example of when this might be is if you are writing diagnostic instrumentation for code to generat…
This article shows you how to optimize memory allocations in C++ using placement new. Applicable especially to usecases dealing with creation of large number of objects. A brief on problem: Lets take example problem for simplicity: - I have a G…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.

815 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

12 Experts available now in Live!

Get 1:1 Help Now