by Norman Tomli » Tue, 28 Jan 1997 04:00:00
I am going to be writting a application that will need to update a database
that's going to be in the US and needs updating from Canada. I want to be
able to do the updates over the internet so we won't have to pay for Long
Distance charges on the modem. What would be the best/fastest way of doing
this?
I have Delphi Dev.
Norm..
1. getNumResultCols, any better ways?
Hi Oracle/OCI gurus,
What's the best way to know NumResultCols of a query in OCI ?
One naive way is to use the following sequential loop:
BOOL bError = FALSE;
int nNumResultCols = 0;
for (int pos = 1; pos < MAX_NUMBER_OF_ITEMS; pos++) {
rc = odescr(&cda, pos, ...);
if (rc == 1007) break;
if (rc < 0) {
// handle error
bError = TRUE;
break;
}
}
if (!bError) {
nNumResultCols = pos - 1;
}
The drawback of the above loop is the inefficiency. odescr() OCI call
goes to the server every time you call it. If there are large # of
columns in a query, it would be really inefficient.
One way I can think of to improve the efficiency is to call
odescr() with a 'pos' picked in binary-searching fashion.
Is there a better way to do it ?
--
James Chen, at Interweave Software, Inc.
3. good ways to use recordsets without autocommit?
4. Listboxes and Checkboxes combined
5. Any better ways to manage programs?
6. ORACLE FINANCIAL CONTRACTS IN CALIFORNIA
7. Best ways of Debugging a Stored Proc...
8. problem using BCP to import data
9. RFI - Best ways to sync data across platforms
10. dropdownlists and grids, which ways is the best?
11. Better ways to talk than DB-lib
12. Batch insertion from .net, better ways?
13. RFI - Best ways to sync data across platforms