Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating Interbase data in VC++
- Thread starter ToKo
- Start date
artokallio
Programmer
Updating is quite possible to do via consumer templates, but it depends greatly on the provider that you are using: most that I have encountered (especially the free ones) do not support updateable rowsets, so you are normally left only with pass-through to the server (=SQL statements).
One particularly problematic area with using plain commands is that you'll need to somehow manage your position: basically you are forced to preserve your primary key value in order to identify the row which you are updating; if you need to change the primary key, you'll have to do it by deletion-insertion procedure, but this can have unexpected repercussions, say due to foreign-key restrictions. With updateable recordsets, a savvy provider tracks the position automatically.
R2
One particularly problematic area with using plain commands is that you'll need to somehow manage your position: basically you are forced to preserve your primary key value in order to identify the row which you are updating; if you need to change the primary key, you'll have to do it by deletion-insertion procedure, but this can have unexpected repercussions, say due to foreign-key restrictions. With updateable recordsets, a savvy provider tracks the position automatically.
R2
- Status