General question on Database behaviour/SQL

[Florian Bogeschdorfer]

Hi Ruslan!

Another question. This syntax produces a cursor I can not write to:

"SELECT * FROM KUNDENtable,KUNDENKARTENtable WHERE  KD_ID !=0  AND
CRD_KD_ID=KD_ID "

Of course and I know. But what if I need to change data from this cursor in
KUNDENtable only? Actually I do not need any field from KUNDENKARTENtable -
it is just a search criteria in this case - if KUNDE has a CARD (is linked
to KUNDENKARTENtable).
Is there another SQL way to get a read/write cursor?

If I want to change all resulting records I KUNDENtable and as it is
read-only - what would be a common approach to change the records?

Step through the records with a loop and change them with "UPDATE
KUNDENtable ..."? But then the cursor won't reflect the changes.

Actually I build a selection with the above SQL and the user steps through
the address mask and makes changes here and there (in KUNDENtable only)

And advice?

TIA

Florian Bogeschdorfer
——————————————————————————————
e-mail  fb at memedia.de 
fon(E)  +34 680 75 19 77 (nur bei Aufenthalt in Spanien)
fon(D)  +49 173 58 44 26 0 (nur bei Aufenthalt außerhalb Spaniens)
skype   florian.bogeschdorfer
skype.in  +49 561 98 77 84 0
——————————————————————————————
m e m e d i a
Agentur für Neue Medien
Weinbauernstraße 12a
D-81539 München 

e-mail  info at memedia.de
fon     089 – 899 480 9 – 48 
fax     089 – 899 480 9 – 49
—————————————————————————————