The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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.8k422580826
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.5k104135200
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: 606 times

last updated: 07 Aug '12, 09:39