> > I've been browsing the ml about mysql-like LIMIT function to > > return for > > example only the 10 to 40 resultsets. I came to the > > conclusion that it was > > not possible 2 years ago unless by using cursors or the fetch > > function. > > So is there a brand new great function with 7.4 that can do > > that easily > > NO > > > or will i have to test for hours and sending tons of mail to get > > my stuff work ? > > I hope, not > > Elke > SAP Labs Berlin > > >
// Thanks Elke If there is nothing new, i guess the fetch function would be the best. The problem with it is that i don't know if i can fetch a row and send it in the resultset i will return to my application... Usually i use fetch only to get a single value and to send it out with an out parameter. So i've been thinking of creating a temp table and sending my data parameters by parameters in the temp table. The problem is I don't know if a temp table sticks to the session and nobody can see it or write in it ? It would be better for me. If not, has anybody got a simple example of a query returning a set of resultset, let's say from #10 to #50 ? I guess fetch is not good for this since it doesn't return a resultset but parameters... HELP ! -- Marc-Olivier Meunier Ing�nieur Projet BKLINK MVH-IRIS 14, rue Rougemont 75009 Paris _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
