Re: loading data from spread sheet to oracle database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: onedaywhen (onedaywhen_at_fmail.co.uk)
Date: 02/11/04 

Date: 11 Feb 2004 01:36:53 -0800

The preferred convention is to specify in the SELECT clause the
columns you require, rather than use SELECT * . There are all kinds of
good reasons for this (e.g. with no names to go on the DBMS must
consult a data dictionary and thereby increase execution time, adding
a further column with a constraint to the table will break your app,
you are taking it on faith the columns will appear in the correct
order but what if you port to a new version or another DBMS, etc)
which you probably don't think apply to your app, but I thought I
should point this out. 

--
ravinookala <<ravinookala.11fys4@excelforum-nospam.com>> wrote in message news:<ravinookala.11fys4@excelforum-nospam.com>...
> Hi
> 
> Thank you very much for your help.
> 
> It is not necessary to select the field names in the record set.
> If it is so, my programme will become hardcoded.
> I have done it dynamic as under and working fine.
> 
> intFieldsCount = RS.Fields.Count
> v_rowcount = Range("A1").CurrentRegion.Rows.Count - 1
> With RS
> For i = 0 To v_rowcount - 1
> RS.AddNew
> For j = 0 To intFieldsCount - 1
> If IsEmpty(ActiveCell.Offset(0, j)) = True Then
> .Fields(j).Value = Null
> Else
> .Fields(j).Value = Trim(ActiveCell.Offset(0, j))
> End If
> On Error Resume Next
> Next j
> RS.Update
> ActiveCell.Offset(1, 0).Select
> Next i
> End With
> 
> Ravi Nookala
> 
> 
> ---
> Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: Creating a multi-tier client/server application
    ... I was really hoping to avoid an entirely web-based app, ... Some reasons for them would be (in no ... what the user interface should work/look like. ... you've never had to deal with use cases, consider yourself a lucky, ...
    (comp.lang.python)
  • Re: Good Reasons to port asp.NET VB.NET app to C#
    ... I am not asking anyone to help me to lie. ... reasons to port to C# besides personal preference. ... So I get that the answer is “ it's more of a personal preference thing”, ... > Either keep the app in VB.NET or port ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
    ... application logic change for different reasons. ... If it is a COTS, then usually the vendor also owns the app such that ... they do most of the app changes, ...
    (comp.object)
  • Re: Creating a multi-tier client/server application
    ... I was really hoping to avoid an entirely web-based app, ... Some reasons for them would be (in no ... Of course you need to have some - hopefully accurate - functional specs. ...
    (comp.lang.python)
  • Re: Good Reasons to port asp.NET VB.NET app to C#
    ... I am not asking anyone to help me to lie. ... > reasons to port to C# besides personal preference. ... > So I get that the answer is " it's more of a personal preference thing", ... >> switching the app to C#. ...
    (microsoft.public.dotnet.framework.aspnet)