Re: Re: Help with Visual Basic "INSERT" statement

On Wed, 29 Aug 2001 00:18:06 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> quoth:

>
>"Teresa Redmond" <pixelmeow_at_aol.com> wrote in message
>news:1t1ootsldoa4099nh6nl1qme5cbj1lrnl2_at_4ax.com...
>> Hi, all:
>>
>> I am using Visual Basic 6 to connect to an Oracle 8i database and add
>> records. I have a sequence defined, main_pkey, which increments the
>> pkey field of the main table. I have this code, using RDO, in VB,
>> which updates the table main:
>>
>> ...
>> rs.rdoColumns("pkey").Value = main_pkey.nextval
>> rs.rdoColumns("title").Value = Decode(i).First.Title
>> rs.rdoColumns("onlink").Value = Decode(i).First.OnLink
>> rs.rdoColumns("northbc").Value = Decode(i).First.NorthBC
>> ...
>>
>> Now, as you probably know, that first line doesn't work. Does
>> *anyone* here know how I can do this???
>>
>> Thanks in advance,
>>
>> --
>> Teresa Redmond
>> Associate Software Engineer
>> Anteon Corporation
>> tredmond_at_anteon.com
>
>Put the pkey assignment in a before insert for each row trigger. This group
>is flooded with examples of that trigger, and examples are also in the
>Oracle Application Developers Guide.
>Please use this group as a *last* resort, not as a *first* resort.
>I know everyone exposed to Microsux products doesn't read manuals, this
>won't buy you anything when using Oracle.
>
>Regards,
>
>Sybrand Bakker,
>Senior Oracle DBA

Thank you for your kind and considerate answer to my question. Thank you also for assuming that I have not turned over every piece of information I could find on a wide range of newsgroups and message boards. Thank you for assuming that I haven't lurked in this group reading subject lines and looking for the answer to my question before I posted. I have seen no subject lines that dealt with Visual Basic and RDO accessing Oracle over the Oracle Client. I also see that your kind and considerate answer has nothing to do with what I asked: how do I increment my sequence in Visual Basic, using RDO, via the example above.

It is obvious that you do not *know* as much as you think you do. You may want to consider that when in future you are dealing with other knowledgable people. You may also want to remember that you always get back what you give.

Good day to you, sir.

-- 
Teresa Redmond
Associate Software Engineer
Anteon Corporation
tredmond_at_anteon.com