Re: My ugly little friend the DBC

Author: Stephen Russell

Posted: 2010-06-02 at 09:20:55

On Wed, Jun 2, 2010 at 8:08 AM, Richard Kaye <RKaye@artfact.com> wrote:

> What kind of objects?

---------------

Looks like a table but there is nothing there. This is all long

distance talking to COO at site who could type into the command window

for me. I'll see first hand later today when I swing by. :(

Flow of info is:

1) Transactions are inserted into shiptran all day long.

2) EOD I clean up string data to appear to be a date that VFP can use,

a time of day to make customers feel better. This was just added for

UPS data

3) Past shipping cost and price into SO, mark SO as shipped. Not

changed with UPS change.

4) Process Invoice operation that has been in place since 99. Still

untouched.

So the what did I do to change this? #2 :)

I am questioning why a phantom reference to a select distinct * from

myTable would leave remnants in a dbc? This makes no sense to me. I

have no code in create view or alter view or create table. I think

that the select INTO is the culprit.

--

Stephen Russell

Sr. Production Systems Programmer

CIMSgts

901.246-0159 cell

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/AANLkTimlEGx2GD4xj3YipTWN3w7dcudjg8a2R2bIBMMV@mail.gmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2010 Stephen Russell