Index
2010-06-02 08:48 – Stephen Russell : My ugly little friend the DBC
2010-06-02 09:08 – Richard Kaye : RE: My ugly little friend the DBC
2010-06-02 09:20 – Stephen Russell : Re: My ugly little friend the DBC
2010-06-02 11:54 – Rick Schummer : RE: My ugly little friend the DBC
2010-06-02 12:00 – Dave Crozier : RE: My ugly little friend the DBC
2010-06-02 12:03 – MB Software Solutions, LLC : Re: My ugly little friend the DBC
2010-06-02 12:13 – Stephen Russell : Re: My ugly little friend the DBC
2010-06-02 12:32 – MB Software Solutions, LLC : Re: My ugly little friend the DBC
2010-06-02 12:37 – Rick Schummer : RE: My ugly little friend the DBC
2010-06-02 12:42 – Stephen Russell : Re: My ugly little friend the DBC
Back to top
My ugly little friend the DBC

Author: Stephen Russell

Posted: 2010-06-02 08:48:25   Link

How would new objects appear in the DBC? At my clients site there are

now a few new entries all with a numeric value, much like a temp table

created via a select statement.

So my frustration is how are these appearing?

My code in place to fix poor data from UPS:

open data e:\shipping shared

Select distinct * from shiptran where shiptime ="" into cursor tempShip

use shiptran in 0

sele shiptran

dele for shiptime=""

appe from tempShip

scan for ......

voodoo here

end scan

*-- Maybe these two lines are missing? I'll look for them tonight

sele tempShip

use

sele shiptran

use

return

I need shipping in the next section of code that has been in place for

5+ years so I leave it open at this time.

Any idea

--

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/AANLkTikVsgTnyexeSWMiVKtZcyCBEuM7SJtH7NziGO1P@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
Back to top
RE: My ugly little friend the DBC

Author: Richard Kaye

Posted: 2010-06-02 09:08:59   Link

What kind of objects?

rk

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

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell

Sent: Wednesday, June 02, 2010 8:48 AM

To: profoxtech@leafe.com

Subject: My ugly little friend the DBC

How would new objects appear in the DBC? At my clients site there are

now a few new entries all with a numeric value, much like a temp table

created via a select statement.

So my frustration is how are these appearing?

My code in place to fix poor data from UPS:

open data e:\shipping shared

Select distinct * from shiptran where shiptime ="" into cursor tempShip

use shiptran in 0

sele shiptran

dele for shiptime=""

appe from tempShip

scan for ......

voodoo here

end scan

*-- Maybe these two lines are missing? I'll look for them tonight

sele tempShip

use

sele shiptran

use

return

I need shipping in the next section of code that has been in place for

5+ years so I leave it open at this time.

_______________________________________________

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/DF1EEF11E586A64FB54A97F22A8BD04406841AB676@ACKBWDDQH1.artfact.local

** 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 Richard Kaye
Back to top
Re: My ugly little friend the DBC

Author: Stephen Russell

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

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
Back to top
RE: My ugly little friend the DBC

Author: Rick Schummer

Posted: 2010-06-02 11:54:59   Link

>> How would new objects appear in the DBC? <<

Most of the time temp tables are created using the CREATE TABLE, but the

developer forgets to use the FREE clause so it is not included in the

current database container.

Rick

White Light Computing, Inc.

www.whitelightcomputing.com

www.swfox.net

www.rickschummer.com

_______________________________________________

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/005f01cb026b$f49801f0$ddc805d0$@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 Rick Schummer
Back to top
RE: My ugly little friend the DBC

Author: Dave Crozier

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

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
Back to top
Re: My ugly little friend the DBC

Author: MB Software Solutions, LLC

Posted: 2010-06-02 12:03:27   Link

Dave Crozier wrote:

> 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,

I think you meant the READWRITE clause (if outputting to a CURSOR).

--

Mike Babcock, MCP

MB Software Solutions, LLC

President, Chief Software Architect

http://mbsoftwaresolutions.com

http://fabmate.com

http://twitter.com/mbabcock16

_______________________________________________

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/4C0680CF.3030803@mbsoftwaresolutions.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 MB Software Solutions, LLC
Back to top
Re: My ugly little friend the DBC

Author: Stephen Russell

Posted: 2010-06-02 12:13:38   Link

On Wed, Jun 2, 2010 at 10:54 AM, Rick Schummer

<profox@whitelightcomputing.com> wrote:

>>> How would new objects appear in the DBC? <<

>

> Most of the time temp tables are created using the CREATE TABLE, but the

> developer forgets to use the FREE clause so it is not included in the

> current database container.

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

Thanks. "Free" sounds like something I never used in my code. Is it

VFP6 or a newer version?

I saw the rewrite parts below adn I'll get to the bottom of it.

Still think that I am not closing it out in a use statement as well.

--

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/AANLkTimZ5xB5RsHtgQpW2Ab76dxconqdxazHbkw-ZEvE@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
Back to top
Re: My ugly little friend the DBC

Author: MB Software Solutions, LLC

Posted: 2010-06-02 12:32:44   Link

Stephen Russell wrote:

> On Wed, Jun 2, 2010 at 10:54 AM, Rick Schummer

> <profox@whitelightcomputing.com> wrote:

>>>> How would new objects appear in the DBC? <<

>> Most of the time temp tables are created using the CREATE TABLE, but the

>> developer forgets to use the FREE clause so it is not included in the

>> current database container.

> ----------------

>

> Thanks. "Free" sounds like something I never used in my code. Is it

> VFP6 or a newer version?

>

> I saw the rewrite parts below adn I'll get to the bottom of it.

>

> Still think that I am not closing it out in a use statement as well.

I can recall FREE being in there since AT LEAST VFP6...and I'd bet VFP5

too. They most likely created that clause at the same time that they

created the DBC container. VFP3?

--

Mike Babcock, MCP

MB Software Solutions, LLC

President, Chief Software Architect

http://mbsoftwaresolutions.com

http://fabmate.com

http://twitter.com/mbabcock16

_______________________________________________

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/4C0687AC.9020707@mbsoftwaresolutions.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 MB Software Solutions, LLC
Back to top
RE: My ugly little friend the DBC

Author: Rick Schummer

Posted: 2010-06-02 12:37:39   Link

>> Thanks. "Free" sounds like something I never used in my code. Is it

VFP6 or a newer version?<<

According to Hacker's Guide to Visual FoxPro 6.0 it is in the CREATE TABLE

syntax. I believe it was in VFP 3.0.

Rick

White Light Computing, Inc.

www.whitelightcomputing.com

www.swfox.net

www.rickschummer.com

_______________________________________________

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/007001cb0271$eab3e810$c01bb830$@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 Rick Schummer
Back to top
Re: My ugly little friend the DBC

Author: Stephen Russell

Posted: 2010-06-02 12:42:07   Link

On Wed, Jun 2, 2010 at 11:32 AM, MB Software Solutions, LLC

<mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:

> Stephen Russell wrote:

>> On Wed, Jun 2, 2010 at 10:54 AM, Rick Schummer

>> <profox@whitelightcomputing.com> wrote:

>>>>> How would new objects appear in the DBC? <<

>>> Most of the time temp tables are created using the CREATE TABLE, but the

>>> developer forgets to use the FREE clause so it is not included in the

>>> current database container.

>> ----------------

>>

>> Thanks.  "Free" sounds like something I never used in my code.  Is it

>> VFP6 or a newer version?

>>

>> I saw the rewrite parts below adn I'll get to the bottom of it.

>>

>> Still think that I am not closing it out in a use statement as well.

>

>

> I can recall FREE being in there since AT LEAST VFP6...and I'd bet VFP5

> too.  They most likely created that clause at the same time that they

> created the DBC container.  VFP3?

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

Thanks to both of you . I will see if that does the job tonight.

--

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/AANLkTino_0PUfcnhMGKTeJP62WVBYjoyvyUFAXpRmczW@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