× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



What is the preferred SQL alternative to native database I/O in the following 
scenario? Read a header record and if a flag is on, read all the corresponding 
detail records for the header record and for those detail records whose flag is 
on, process the record and update it's flag.

Since SQL does not allow an update to a cursor for joined tables, do I create 
two cursors and update the detail record through its separate cursor or do I 
create one cursor for joining the two tables and update the detail record with 
a separate in-line SQL update statement or is there a better way to handle this 
type of processing using embedded SQL?

TIA,

Jake

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.