Remote DataBase Update - Best Way

Remote DataBase Update - Best Way

Post 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

I have Delphi Dev.



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;
  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.

2. Rename Folders

3. good ways to use recordsets without autocommit?

4. Listboxes and Checkboxes combined

5. Any better ways to manage programs?


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