Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #11149

Re: Best way to find out where a field is changed

From "Jamal" <noooospam@example.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Best way to find out where a field is changed
Date 2017-11-16 18:14 -0500
Organization albasani.net
Message-ID <oul64i$6ig$1@news.albasani.net> (permalink)
References <ljg30ddi7e7rmdadn6v057r7khg9ji2fg8@4ax.com>

Show all headers | View raw


>>
On rare occasions a field in an invoice
table contains a different currency than it should contain. <<

What is column type? Is this is in an SQL table or in a DBF file

What do you pass save into the column and what do you see after?

Jamal

"D.J.W. van Kooten"  wrote in message 
news:ljg30ddi7e7rmdadn6v057r7khg9ji2fg8@4ax.com...

We have the following issue. On rare occasions a field in an invoice
table contains a different currency than it should contain. On every
database change, we call a function which creates an SQL query. We
checked every place where this field is changed in the program and all
were followed by a call to this function. The SQL query database
contains one INSERT and multiple UPDATE statements on the specific
record but all show the original currency and not the one we finally
see in the database.

So there must be something we overlooked. I wonder what the best way
would be to find out from where this field is changed. As we use ADS
(in conjunction with separate DBF files) we may be helped with
triggers but I never worked with these. Does anyone have experience
with it?

Dick 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Best way to find out where a field is changed D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2017-11-07 15:32 +0100
  Re: Best way to find out where a field is changed "Karl-Heinz" <invalid@invalid.invalid> - 2017-11-08 15:32 +0100
    Re: Best way to find out where a field is changed D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2017-11-16 23:34 +0100
  Re: Best way to find out where a field is changed "Jamal" <noooospam@example.com> - 2017-11-16 18:14 -0500

csiph-web