Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #11149
| 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> |
>> 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
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