Account Options

  1. Sign in
The old Google Groups will be going away soon.
Switch to the new Google Groups.
Google Groups Home
« Groups Home
Jaguar, Oracle, PB7 DataWindow Stored Procedure
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  2 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Tony Brooks  
View profile  
 More options Jun 16 2000, 3:00 am
Newsgroups: powersoft.public.easerver
From: "Tony Brooks" <albro...@freewwweb.com>
Date: 2000/06/16
Subject: Jaguar, Oracle, PB7 DataWindow Stored Procedure
Does Anyone know how to update/insert records in an Oracle 8.04 database
using the Oracle native drivers and a datawindow created based on a stored
procedure?

Background Info:
1) The datawindow is based on a stored procedure and the update properties
for the datawindow
     have NOT been enabled.

2) The  datawindow has three 3 stored procedures associated with it, one
each for update, insert,
     delete.

3) Currently using Jaguar 3.5 on NT Workstation.

5) The stored procedure retrieves, displays, and updates the data fine in
both development and run-
    time environments, but when the a new row is inserted the update is
called from the client I get an
    return of null displayed on the screen and nothing else.

Please help.

--
From the desk of:

Antonio Brooks
Information Technology Consultant


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Suresh Subrmaniam  
View profile  
 More options Jun 16 2000, 3:00 am
Newsgroups: powersoft.public.easerver
From: Suresh Subrmaniam <ssubraman...@psc.gov>
Date: 2000/06/16
Subject: Re: Jaguar, Oracle, PB7 DataWindow Stored Procedure
Hi,

I am using Oracle 7.1 and it worked perfectly for me. I was not inserting
a row, but I was updating a row and updated more than 1 table using
stored procedures. But I have enabled Update option and then set the
stored procedure option

As far I know I think you have set update to true. Otherwise Update event
will not fire. If update is set to true and sp updates are set, I think in the

sqlpreview event it uses the stored procedure. This is my guess.Larry,Dave,Jim

can provide you with more info.

Thanks


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »