Re: Datawindow does not have UPDATE capabilities
Chris Pollach
1) What is the specific error?
2) Could this be a Table rights issue for update?
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
"Dave Hauze" <david...@steeldynamics.com> wrote in message
news:4a16b1af@forums-1-dub...
> PB 11.5.1 Build 4011
> Windows XP SP3
>
> We're getting an error on a datawindow saying it does not have update
> capabilities when running DW_1.UPDATE().
>
> The datawindow does have a join it, however the update properties window
> has the proper fields from only one table selected, and the proper table
> is selected, as is the primary key. We've tried all combinations of where
> clause for update/delete and key modification. When the join is removed,
> the table updates just fine.
>
> Here's the select and attached is the screenshot of the update
> properties - only one field is from the second (joined) table:
>
> SELECT rs.customerid,
> rs.parentcustomerid,
> rs.requiredtons,
> rs.rebaterate,
> rs.rebateperiod,
> rs.gracedays,
> rs.status,
> rs.uc,
> rs.dc,
> rs.um,
> rs.dm,
> rs.startdate
> FROM rebatesetup rs
> INNER JOIN customer c
> ON rs.customerid = c.cus_customer_id
>
>
> As you can see this is a very simply datawindow and very straight forward.
> I have MANY datawindows with multiple joins where we only save data to one
> of the tables and they all work fine. I've also verified in the code there
> is nothing that alters the update properties of the datawindow. We've even
> recreated the datawindow from scratch and still have the problem. And
> again, removing the join fixes the problem. Any ideas as to why this is
> occuring when we don't have the same problem in other multiple table join
> updatable DW's?
>
> --
> Dave Hauze
>
>
Jerry Siegel [TeamSybase]
dw_1.datawindow.syntax and look at it in the debugger.
--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
"Dave Hauze" <david...@steeldynamics.com> wrote in message
news:4a16d446@forums-1-dub...
> One more thing, when in the DW Painter, you can update data and save it
> (which requires the same update settings to work), so it does allow us to
> save, just not at runtime.
>
> --
> Dave Hauze
> "Chris Pollach" <cpol...@travel-net.com> wrote in message
> news:4a16b39e$1@forums-1-dub...
Dave Hauze
(which requires the same update settings to work), so it does allow us to
save, just not at runtime.
--
Dave Hauze
"Chris Pollach" <cpol...@travel-net.com> wrote in message
news:4a16b39e$1@forums-1-dub...
Dave Hauze
their code. They used a "framework" of sorts developed internally. The
function that retrieves the data window does a SetSQLSelect which overwrites
the update settings. So, I passed some code to him to re-add the update
settings. Unfortunately, I cannot figure out why it's even doing the
SetSQLSelect, it's just setting the SQL to whatever the original SQL is. I
need to talk to the developer of the framework... But you as I figured it
was something happening at runtime, and indeed it was... Thanks for your
responses.
--
Dave Hauze
"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:4a16d5ab$1@forums-1-dub...
Jerry Siegel [TeamSybase]
the WHERE clause. In such cases I have captured the original SQL in an
instance variable in the constructor event and modified as needed from that
base rather than whatever may be current.
--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
"Dave Hauze" <david...@steeldynamics.com> wrote in message
news:4a16ee43$1@forums-1-dub...
Chris Pollach
Wow ... there's one for the books! :-)
"Dave Hauze" <david...@steeldynamics.com> wrote in message
news:4a16ee43$1@forums-1-dub...