Re: [NF] Find table where last record was added

m: ProFox [mailto:profox-boun...@mail.leafe.com] On Behalf Of Kevin J > Cully > Sent: 06 June 2017 21:46 > To: 'ProFox Email List' <profox@leafe.com> > Subject: [NF] Find table where last record was added > > Hello all, > > I'm trying to (partially) reverse engineer how

RE: [NF] Find table where last record was added

...@mail.leafe.com] On Behalf Of Kevin J Cully Sent: 06 June 2017 21:46 To: 'ProFox Email List' <profox@leafe.com> Subject: [NF] Find table where last record was added Hello all, I'm trying to (partially) reverse engineer how an ERP system is working. It uses M$ SQL Server and it has hu

Re: [NF] Find table where last record was added

In Dev: 1. Run a query that gives you the row counts of all the tables in your schema. Save the results. 2. Enter your new records. 3. Re-run the your query from 1 and compare record counts to see which tsble(s) grew. --- StripMime Report -- processed MIME parts --- multipart/alternative

RE: [NF] Find table where last record was added

: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, June 06, 2017 4:55 PM To: profox@leafe.com Subject: Re: [NF] Find table where last record was added ODBC has logging facilities, so you could do it for your connection only. On Tue, Jun 6, 2017 at 4:54 PM, Ted Roche <te

Re: [NF] Find table where last record was added

ODBC has logging facilities, so you could do it for your connection only. On Tue, Jun 6, 2017 at 4:54 PM, Ted Roche wrote: > Is it possible you can turn on a log, make your change, turn it off, > and read the log? > > On Tue, Jun 6, 2017 at 4:46 PM, Kevin J Cully

Re: [NF] Find table where last record was added

Is it possible you can turn on a log, make your change, turn it off, and read the log? On Tue, Jun 6, 2017 at 4:46 PM, Kevin J Cully wrote: > Hello all, > > I'm trying to (partially) reverse engineer how an ERP system is working. It > uses M$ SQL Server and it has