V6.1 - Quote tables

Yahoo Archive
1
I believe that the QuoteDetails will also have been deleted.

--- On Wed, 6/10/09, apt876sp1 <atucker@...> wrote:


From: apt876sp1 <atucker@...>
Subject: [Vantage] Re: V6.1 - Quote tables
To: vantage@yahoogroups.com
Date: Wednesday, June 10, 2009, 9:25 AM








Perhaps you could query the Quote Detail table compared with the Quote Head table to find quote numbers for which you details and no matching headings.

Allen tucker

--- In vantage@yahoogroup
s.com, "randyduly" <randy.duly@ ...> wrote:
>
> I have some corrupted Quote Tables and I am trying to create a report that show what quote # are missing from the QuoteHed table. I know I can create a report that shows all QuoteNum whether they have been quoted or not. But how do you show if the Quote has been deleted? I don't see a deleted flag.
>
> Thanks in advance.
>
> Randy
>



















[Non-text portions of this message have been removed]
2
I have some corrupted Quote Tables and I am trying to create a report that show what quote # are missing from the QuoteHed table. I know I can create a report that shows all QuoteNum whether they have been quoted or not. But how do you show if the Quote has been deleted? I don't see a deleted flag.

Thanks in advance.

Randy
3
you never will...unfortunately...and that goes for any record in the
system, not just quotes.

once deleted, no way to trace it. We never "delete" anything we always
put notes in the memo fields as to why it won't be used.



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of randyduly
Sent: Wednesday, June 10, 2009 7:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] V6.1 - Quote tables





I have some corrupted Quote Tables and I am trying to create a report
that show what quote # are missing from the QuoteHed table. I know I can
create a report that shows all QuoteNum whether they have been quoted or
not. But how do you show if the Quote has been deleted? I don't see a
deleted flag.

Thanks in advance.

Randy






[Non-text portions of this message have been removed]
4
 Possibly use a 'routine/query' where you increment QuoteNumber by '1' in a loop, checking for the existence of that QuoteNum in the QuoteHed table - if it does not exist (.recordCount = 0 or similar) then add that number to the list ( starting the loop with your lowest known Quote Number).

--- On Wed, 6/10/09, randyduly <randy.duly@...> wrote:


From: randyduly <randy.duly@...>
Subject: [Vantage] V6.1 - Quote tables
To: vantage@yahoogroups.com
Date: Wednesday, June 10, 2009, 8:38 AM








I have some corrupted Quote Tables and I am trying to create a report that show what quote # are missing from the QuoteHed table. I know I can create a report that shows all QuoteNum whether they have been quoted or not. But how do you show if the Quote has been deleted? I don't see a deleted flag.

Thanks in advance.

Randy



















[Non-text portions of this message have been removed]
5
Perhaps you could query the Quote Detail table compared with the Quote Head table to find quote numbers for which you details and no matching headings.

Allen tucker

--- In vantage@yahoogroup
s.com, "randyduly" <randy.duly@...> wrote:
>
> I have some corrupted Quote Tables and I am trying to create a report that show what quote # are missing from the QuoteHed table. I know I can create a report that shows all QuoteNum whether they have been quoted or not. But how do you show if the Quote has been deleted? I don't see a deleted flag.
>
> Thanks in advance.
>
> Randy
>