Article View: borland.public.cppbuilder.database.ado
Article #4163Bound controls and server side cursors
From: Tony
Date: Wed, 06 Mar 2002 12:29
Date: Wed, 06 Mar 2002 12:29
22 lines
1840 bytes
1840 bytes
I need to change a typical data form (name, address, phone etc.) from a client side cursor to server side. The form uses bound controls and a TDBNavigator. The form seems to work OK with server side for Prior record, Next record and Update record but on Insert record it throws the error "Field ID cannot be modified". The ID field is an auto increment field. Do I have to use all action queries and unbound controls to do this with a server side cursor, or is it possible to use bound controls? If so, what is a good technique for adding records? The table I am having trouble with is the detail in a master/detail (Client/Person) relationship. The Person table has the Client table as a DataSource. The query is Select Person.* From Person Where ClientID = :ID Order by LastName Using a client cursor the Person.ID and Person.ClientID fields get filled automatically when an insert is done. With a server cursor they don't seem to.
Technical Details
Message-ID:
<3c860b13_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!attbtf!ip.att.net!usc.edu!howland.erols.net!cyclone2.usenetserver.com!usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,a21c569361c07805 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-03-06 04:30:23 PST From: "Tony" <hse@hill-soft.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Bound controls and server side cursors Date: Wed, 6 Mar 2002 07:29:42 -0500 Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 NNTP-Posting-Host: 165.121.212.183 Message-ID: <3c860b13_2@dnews> X-Trace: dnews 1015417619 165.121.212.183 (6 Mar 2002 04:26:59 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!attbtf!ip.att.net!usc.edu!howland.erols.net!cyclone2.usenetserver.com!usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews