473,325 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

table API

bdj
Hello!
With Designer (and other tools) you can generate table-API's.

When is a good idea to use it? I assume that it only make sense when have to
modify an single row by an
Forms/Report or other end-user-application (for example web-interfaces) -
right?

Where to read more about it?

Greetings
Bjørn
Jul 19 '05 #1
3 5208

"bdj" <B.********@gmx.net> wrote in message
news:41*********************@dread11.news.tele.dk. ..
| Hello!
| With Designer (and other tools) you can generate table-API's.
|
| When is a good idea to use it? I assume that it only make sense when have
to
| modify an single row by an
| Forms/Report or other end-user-application (for example web-interfaces) -
| right?
|
| Where to read more about it?
|
| Greetings
| Bjørn
|
|

i've come to be quite an advocate of TAPI's the more applications i've had
to maintain

TAPI's generated by tools are of course very rudimentary -- but as you fold
in appropriate business rules, having a single procedure that maintains a
table greatly simplifies maintenance and development -- and debugging. on
many projects that i've been called in on to support/maintain/enhance i've
had to spend most of my time searching code to find out what procedures are
accessing a certain table. if it's all in a single package, you've got a
nice clean structure to work with.

++ mcs
Jul 19 '05 #2
bdj
Hi!
But what about performance when you have to manipulate more than one row
quickly?
Greetings
Bjørn
"Mark C. Stock" <mcstockX@Xenquery .com> skrev i en meddelelse
news:ap********************@comcast.com...

"bdj" <B.********@gmx.net> wrote in message
news:41*********************@dread11.news.tele.dk. ..
| Hello!
| With Designer (and other tools) you can generate table-API's.
|
| When is a good idea to use it? I assume that it only make sense when
have
to
| modify an single row by an
| Forms/Report or other end-user-application (for example
web-interfaces) -
| right?
|
| Where to read more about it?
|
| Greetings
| Bjørn
|
|

i've come to be quite an advocate of TAPI's the more applications i've had
to maintain

TAPI's generated by tools are of course very rudimentary -- but as you
fold
in appropriate business rules, having a single procedure that maintains a
table greatly simplifies maintenance and development -- and debugging. on
many projects that i've been called in on to support/maintain/enhance i've
had to spend most of my time searching code to find out what procedures
are
accessing a certain table. if it's all in a single package, you've got a
nice clean structure to work with.

++ mcs

Jul 19 '05 #3

"bdj" <B.********@gmx.net> wrote in message
news:41*********************@dread11.news.tele.dk. ..
| Hi!
| But what about performance when you have to manipulate more than one row
| quickly?
| Greetings
| Bjørn
| "Mark C. Stock" <mcstockX@Xenquery .com> skrev i en meddelelse
| news:ap********************@comcast.com...
| >
| > "bdj" <B.********@gmx.net> wrote in message
| > news:41*********************@dread11.news.tele.dk. ..
| > | Hello!
| > | With Designer (and other tools) you can generate table-API's.
| > |
| > | When is a good idea to use it? I assume that it only make sense when
| > have
| > to
| > | modify an single row by an
| > | Forms/Report or other end-user-application (for example
| > web-interfaces) -
| > | right?
| > |
| > | Where to read more about it?
| > |
| > | Greetings
| > | Bjørn
| > |
| > |
| >
| > i've come to be quite an advocate of TAPI's the more applications i've
had
| > to maintain
| >
| > TAPI's generated by tools are of course very rudimentary -- but as you
| > fold
| > in appropriate business rules, having a single procedure that maintains
a
| > table greatly simplifies maintenance and development -- and debugging.
on
| > many projects that i've been called in on to support/maintain/enhance
i've
| > had to spend most of my time searching code to find out what procedures
| > are
| > accessing a certain table. if it's all in a single package, you've got a
| > nice clean structure to work with.
| >
| > ++ mcs
| >
| >
|
|

not an issue -- you just write the appropriate procedure/function that
manipulates the appropriate rows

++ mcs
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Gaz | last post by:
Hi, I need to have a table nested within another table. The tables are alongside each other visually speaking, and the nested table (on the right) can vary in size. My problem is that when the...
61
by: Toby Austin | last post by:
I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...
3
by: Terrence Brannon | last post by:
I don't know what Postgres considers a relation and had no intention of creating one when piping my schema to it... I always DROP TABLE before CREATE TABLE, so here are the ERRORS emitted when...
4
by: maricel | last post by:
I have the following base table structure - DDL: CREATE TABLE "ADMINISTRATOR"."T1" ( "C1" INTEGER NOT NULL ) IN "TEST_TS" ; ALTER TABLE "ADMINISTRATOR"."T1" ADD PRIMARY KEY
4
by: Simone Battagliero | last post by:
I wrote a program which inserts and finds elements in an hash table. Each element of the table is a dinamic list, which holds all elements having the same hash value (calculated by an int...
117
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of...
76
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal...
7
by: Kamal | last post by:
Hello all, I have a very simple html table with collapsible rows and sorting capabilities. The collapsible row is hidden with css rule (display:none). When one clicks in the left of the...
5
by: wugon.net | last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad query performance Env: db2 LUW V8 + FP14 Problem : We have history data from 2005/01/01 ~ 2007/05/xx in single big...
5
by: jrod11 | last post by:
hi, I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.