The forum will be down for maintenance at some point from Friday, August 24 at 19:00 EDT until Sunday, August 26 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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
27.8k476633912
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
7.1k121155225
accept rate: 21%

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: 853 times

last updated: 07 Aug '12, 09:39