I have a Power Builder aplication connected to Sql Anywhere 12. When several users are logged, sometimes some records are deleted. When just one user is logged, it never happens

asked 06 Aug '12, 12:27

lpazito's gravatar image

lpazito
1111
accept rate: 0%


It sounds like an application problem.

In any event, more information is required (much more information, methinks)

permanent link

answered 06 Aug '12, 16:29

Breck%20Carter's gravatar image

Breck Carter
26.2k430599862
accept rate: 20%

One approach to trying to understand what is happening would be to take a copy of the log file covering a period where the problem has happened and then to use dbtran.exe to translate it into sql statements. Then you can look through for where the records are being deleted and see which user is doing it.

permanent link

answered 07 Aug '12, 09:39

Justin%20Willey's gravatar image

Justin Willey
6.8k110142212
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×3

question asked: 06 Aug '12, 12:27

question was seen: 656 times

last updated: 07 Aug '12, 09:39