Thread: updatable result sets
I have updatable result sets working with the 7.4.1 driver against a 7.3 backend, but I've noticed that when inserting a record, it appears as the last record in the result set even if a sort order was specified. Likewise, if ORDER BY NAME was specified and the name field has changed, it stays in the same place in the set. Is there any way to make these records appear in order without re-reading the data by creating the result set over again? -- ____________________________________________________________ Glenn Holmer gholmer@weycogroup.com Programmer/Analyst phone: 414-908-1809 Weyco Group, Inc. fax: 414-908-1601
Glenn, How would you propose we do this ? Dave On Wed, 2004-03-17 at 11:20, Glenn Holmer wrote: > I have updatable result sets working with the 7.4.1 driver against > a 7.3 backend, but I've noticed that when inserting a record, it > appears as the last record in the result set even if a sort order > was specified. Likewise, if ORDER BY NAME was specified and the > name field has changed, it stays in the same place in the set. > > Is there any way to make these records appear in order without > re-reading the data by creating the result set over again? -- Dave Cramer 519 939 0336 ICQ # 14675561
Dave Cramer wrote: > Glenn, > > How would you propose we do this ? > > Dave > On Wed, 2004-03-17 at 11:20, Glenn Holmer wrote: > >>I have updatable result sets working with the 7.4.1 driver against >>a 7.3 backend, but I've noticed that when inserting a record, it >>appears as the last record in the result set even if a sort order >>was specified. Likewise, if ORDER BY NAME was specified and the >>name field has changed, it stays in the same place in the set. >> >>Is there any way to make these records appear in order without >>re-reading the data by creating the result set over again? OK, that's what I thought :) -- ____________________________________________________________ Glenn Holmer gholmer@weycogroup.com Programmer/Analyst phone: 414-908-1809 Weyco Group, Inc. fax: 414-908-1601