RE: My ugly little friend the DBC

Author: Dave Crozier

Posted: 2010-06-02 at 12:00:39

Stephen,

It may be sensible to add the "rewrite" option to the "select ... into

cursor". That way the file will be flushed ut to disk and nothing should be

needed in the dbc container. I must admit I have never come across what you

are experiencing with respect to the entries though. Have you checked for

stored procedures in the container that may be creating thentries?

Dave C

-----Original Message-----

From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf

Of Stephen Russell

Sent: 02 June 2010 14:21

To: ProFox Email List

Subject: Re: My ugly little friend the DBC

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

[excessive quoting removed by server]

_______________________________________________

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/004a01cb026c$c0a56760$41f03620$@co.uk

** 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 Dave Crozier