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.
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.
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.
>> 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.
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.
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
_______________________________________________
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.
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.
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
_______________________________________________
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.
>> 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.
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.