Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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
32.5k5417261050
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.6k137179249
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: 1,819 times

last updated: 07 Aug '12, 09:39