🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4163

Bound controls and server side cursors

#4163
From: Tony
Date: Wed, 06 Mar 2002 12:29
22 lines
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!dnews

Show 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