INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

(OP)
i am trying to update a datawindow via stored procedure update.

The stored has no input or output parameter.

When i call the update method, pb crashes.

any idea?

i am using pb 11.5 (also tried 12-12.5 ) and sqlserver 2012 sp1
thanks in advance for any help

RE: PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

Have you run a database trace?

Matt

"Nature forges everything on the anvil of time"
www.anvil-of-time.com

RE: PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

Is there any information provided when the crash occurs?
Like error numbers, text, etc..

Can you please post the PowerBuilder code where you execute the Stored Procedure?

RE: PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

(OP)
1- No i don't run a datbase trace - i did not use it befor - i will try to do it
2- no any information provided when the crach occurs
header oe message "sybase powerbuilder 11.5
detail of message sybase powerbuilder 11.5 hasstopped working
shown in next image (i ut it AT LEFT of image)

then this message close and another meesage displayed with Debug and close program (I put it at right of imagel

this topic is similar to


https://archive.sap.com/discussions/thread/3654465 (but dw is not working at all) and

0n6CHA.181@forums.sybase.com%3E;jsessionid=FF13371308839946FAAE9540552E1F4D" target="_blank">http://forums.sybase.com/nntp-archive/action/artic...

RE: PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

(OP)

Hi mbalent
I run database trace with following events

Exception under Errors and Warnings
RPC: Completed under Stored Procedures
RPC: Starting under Stored Procedures
SQL: BatchCompleted under TSQL
SQL: BatchStarting under TSQL
and I run my app
there are generated rows whwn i run mu pb app
also when i retrieve rows into dw there are more rows in db trace
now i edit one record (no more rows in trace)
then when i press button that had script dw_1.update()

powerbuilder crache with no rows in db trace

thanks

RE: PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

Hi powerbuilde,

Did you find a solution? We have similar issue...
We are trying to update a datawindow via stored procedure, not via update but insert.

The first insert always work. When we try to insert once again, PB crashes.

The stored proc has input parameters only (and it's probably not related).

We get to the SQLPreview, and it looks fine, but the store proc is not called (no trace in SQL Profiler).

thanks

RE: PB crash when calling datawindow update via Stored Procedure??PB 11.5-12-12.5 and

(OP)
Hi DDeenniiss (MIS)
No no solution found yet

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close