Show Bid Request
Create Crosstab Recordset from Normal Recordset
Bid Request Id: 68457
|
|
|
|
Posted by: |
giannis73 (3 ratings)
(Software buyer rating 10 )
|
|
Non-action Ratio: |
Very Good - 0.00%
|
Buyer Security Verifications: |
Good
|
|
Approved on: |
Jun 15, 2003
9:34:20 AM EDT
|
|
Bidding Closes: |
Jun 29, 2003
5:50:09 AM EDT
|
|
Viewed (by coders): |
249 times
|
|
|
|
|
Description:
I have a vb 6 project and an access 2000 database and I create a crosstab recordset (transform statement ) by executing a crosstab query on the database that returns a ado recordset.
I need now a function in vb 6 that will accept as parameters a standard ado recordset that will return a crosstab recordset
by manipulating the normal recordset that is passed in. I need this because I want to create the crosstab recordset without making a connection to the database.
This function will have also parameters passed in that will represent the Row Value , the Column Value and The Measure Value ) . The function would look something like this :
Private Function CreateCrossTabRecordset (NormalRst as adodb.recordset, ArrayRowValues() as string, ColumnField as string, ValueField as string,AggregationType As String) ) as adodb.recordset
dim TempRst as adodb.recordset
'''''''Create Crosstab Recordset
set CreateCrossTabRecordset = TempRst
End Function.
Note :The parameters that are passed in correspond to field names that are inside the original ado recordset.
I have included a sample demo showing how I perform this function now and how I would like it to perform.
Specifications :
The parameter AraryRowValues passed into the function will be a string array because the row values may be more than one. The elements of the array will correspond to field names from the original recordset
The parameter Column field will represent a string corresponding to a field name from the original recordset and will create
the field value of the new crosstb recordset.
The parameter Value Field will represent a string corresponding to a field name from the original recordset and will be use
as the value field in the new crosstab recordset.
The parameter AggregationType will represent a string and possible values will be :
Sum
Min
Max
Average
Count
According to the value supplied in the function the recordset will perform the appropriate aggregation.
Deliverables:
1 .I need a function in the sample Project that I have included so that when I press the button ''How i would like it to work"
the results returned to the datagrid are the same as as if I pressed the button ''How it works now.''.
2.Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
3. Complete ownership and distribution copyrights to all work purchased.
Platform:
Windows 98,2000,xp
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$100 (USD)
|
Jun 17, 2003
6:17:29 AM EDT
|
9.85
(Excellent)
|
|
|
Dear SIr,
Here is the corrected Project.
It works with 'normal', disconnected, recordsets, and does'nt need to reconnect to make the crosstab recordset out of it.
Regards,
Zlatko.
|
|
|
Attached File
|
|
|
|
|
|