469,927 Members | 1,877 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

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 5067

"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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

61 posts views Thread by Toby Austin | last post: by
3 posts views Thread by Terrence Brannon | last post: by
4 posts views Thread by maricel | last post: by
4 posts views Thread by Simone Battagliero | last post: by
117 posts views Thread by phil-news-nospam | last post: by
7 posts views Thread by Kamal | last post: by
5 posts views Thread by jrod11 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.