|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Avoid common pitfalls of incorporating spreadsheets into Java apps. Read about it in the free white paper: “Five Biggest Blunders when Building Spreadsheet Applications in Java” Download Now! |
|
#1
|
|||
|
|||
|
sticky ado question
What I'm trying to do is use data shaping on a connectionless recordset to group on a field for a report.
It's simple enough to pull off if you're using a connected recordset, because those have a command object, but my disconnected recordset has no command object, so how am I supposed to do the data shaping? |
|
#2
|
|||
|
|||
|
more info
here's some code I'm trying to use:
********************************************* With cmdDyn .ActiveConnection = connDyn .CommandType = adCmdText .CommandText = " SHAPE APPEND(" _ & " NEW adInteger as unit, " _ & " NEW adBSTR as clerk_id, " _ & " NEW adInteger as unit, " _ & " NEW adDouble as prod_time, " _ & " NEW adInteger as claims_worked, " _ & " NEW adDouble as clms_hr, " _ & " NEW adInteger as corrected, " _ & " NEW adInteger as reviewed, " _ & " NEW adInteger as flds_hr) as command1" _ & " COMPUTE command1 by 'unit'" End With Set rsDyn = CreateObject("adodb.recordset") rsDyn.Open cmdDyn ******************************************** I've tried with and without the APPEND in the shape command, but I get a syntax error on the rsDyn.Open line either way. Is it not obvious what I'm trying to do? |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > sticky ado question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|