By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Locate same or changed values

P: 2
I would like to write a query to identify when an EFT/Direct Deposit transactions bank account details (BSB, AC) change when the identifier (iD) remains the same, ie

iD DatePaid AmountPaid BSB AC
1 1/1/2010 $5000 012 4444444
1 2/1/2010 $25000 012 4566657


I would also like to identify when different iDs have the same BSB and AC, ie

iD DatePaid AmountPaid BSB AC
1 1/1/2010 $5000 012 4444444
5 2/1/2010 $25000 012 4444444
7 3/1/2010 $5666 111 456789
Dec 14 '11 #1
Share this Question
Share on Google+
3 Replies


100+
P: 1,059
You cannot get a built in solution.

but you can follow some strategy
such as:
1. Forbid deleting payment record. (If you allow its a violation of accounting)
2. Forbid editing payment record.(its a violation of accounting)

Now if they are not a big deal:
then when you delete do not delete the actuation record use another column to figure out whether it is deleted or not.
And When you edit make a record of original account row. create a backup, keep track of the editor.

but if you ask about deleting from original table manually, by manually I mean using other database client like phpmyadmin, mysql_client or other things then nothing to say
Dec 14 '11 #2

P: 2
The Id maybe someones name. So what i am trying to do is identify when a customers bank account is changed at the individual transaction level. The bank account is allowed to be changed, however i want to identify it when it occurs as a potential fraud check.

Also for internal fraud purposes i want to identify if two customers have the same bank account.
Dec 14 '11 #3

100+
P: 1,059
Well in that case when you get a request to change the bank account, or when you receive a new transaction request a update then take an immediate look at previous transactions, if you found a new Bank account make a record to other table from where you can verify
Dec 14 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.