On Friday, March 02, 2012 4:54:35 pm Ed Leafe wrote:
> On Mar 2, 2012, at 6:42 PM, Adrian Klaver wrote:
> > The query passed to the cursor would do the processing on the server and
> > return the filtered down results back to Dabo. Temporary tables exist
> > for the life of the connection generally, so they would be available to
> > each DataSet cursor.
>
> I must have misunderstood your post. When you said to substitute DataSet
> (local) for TempTable (remote), I thought that you meant to pull the temp
> table into a Dabo dataset, and then query against that.
Yea, I could have been clearer. I think of DataSets as temporary tables when
working with them. So what I was actually trying to say was a temporary
table(DataSet) over a temporary table(database). I made this leap in my mind
without explaining it to my fingers as I typed:(
So in the case Ricardo shows something like(warning pseudo code):
cur=tempCursor("select *
into #TempTable
from someBigTable
left join someOtherTable
on someConditions
where someRestraints")
cur1=tempCursor("select someField, someOtherField, sum(someValue) as 'Total'
from #TempTable
group by someField, someOtherField
order by someField, someOtherField")
cur2=tempCursor("select *
from #TempTable
left join #OtherTempTableFromSomeOtherPreviousQuery
on SomeConditions
where someOtherRestraints")
Where #OtherTempTableFromSomeOtherPreviousQuery was set up previously.
>
>
> -- Ed Leafe
--
Adrian Klaver
[email protected]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
