dbTalk Databases Forums  

Vanishing table!

comp.databases.paradox comp.databases.paradox


Discuss Vanishing table! in the comp.databases.paradox forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JoeSpareBedroom
 
Posts: n/a

Default Vanishing table! - 07-17-2006 , 01:49 PM






Using PdoxDOS 4.5 with XP Pro

I created a table, filled it with data (from a csv file), and noticed
immediately that it didn't exist. "What?", you ask. I also had an Explorer
window open to the folder in which I was creating tables. I noticed that the
table I created wasn't in the file list, even after refreshing the list. The
table was still on the Pdox screen, and I could page through it (didn't try
editing it). But, when I cleared the Pdox screen (ALT-F8) and then tried to
view the table again, Pdox couldn't find it.

Interesting. I created it again, and had the same problem. Exited Paradox,
restarted the machine, and the problem's gone for now. Obviously, it will be
back, but why? Does Pdox 4.5 require a files or buffers setting when run in
XP?




Reply With Quote
  #2  
Old   
Larry DiGiovanni
 
Posts: n/a

Default Re: Vanishing table! - 07-17-2006 , 08:30 PM






JoeSpareBedroom wrote:

Quote:
I created a table, filled it with data (from a csv file), and noticed
immediately that it didn't exist.
Never heard of anything like that.

On a guess, either you'd made it in a different directory, or there was an
active PRIVTABLES with that name, and the table you created went to the
private directory instead of the working directory. Then the Alt-F8 cleared
that setting.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.



Reply With Quote
  #3  
Old   
Steve Urbach
 
Posts: n/a

Default Re: Vanishing table! - 07-17-2006 , 08:42 PM



Is write behind disk cache disabled on your machine.

Also,
Try a mini-script PAL command
SaveTables
This should force a write.

This used to happen to me back with Paradox 2 doing repeated imports.
The table would not write to disk until I first did a Reset command or
a TMD.

Steve U

On Mon, 17 Jul 2006 18:49:10 GMT, "JoeSpareBedroom"
<dishborealis (AT) yahoo (DOT) com> wrote:

Quote:
Using PdoxDOS 4.5 with XP Pro

I created a table, filled it with data (from a csv file), and noticed
immediately that it didn't exist. "What?", you ask. I also had an Explorer
window open to the folder in which I was creating tables. I noticed that the
table I created wasn't in the file list, even after refreshing the list. The
table was still on the Pdox screen, and I could page through it (didn't try
editing it). But, when I cleared the Pdox screen (ALT-F8) and then tried to
view the table again, Pdox couldn't find it.

Interesting. I created it again, and had the same problem. Exited Paradox,
restarted the machine, and the problem's gone for now. Obviously, it will be
back, but why? Does Pdox 4.5 require a files or buffers setting when run in
XP?



Reply With Quote
  #4  
Old   
JoeSpareBedroom
 
Posts: n/a

Default Re: Vanishing table! - 07-18-2006 , 06:57 AM



Good idea - I'll know if it works in a few minutes.

"Steve Urbach" <dragonsclaw (AT) NOTmindspring (DOT) com> wrote

Quote:
Is write behind disk cache disabled on your machine.

Also,
Try a mini-script PAL command
SaveTables
This should force a write.

This used to happen to me back with Paradox 2 doing repeated imports.
The table would not write to disk until I first did a Reset command or
a TMD.

Steve U

On Mon, 17 Jul 2006 18:49:10 GMT, "JoeSpareBedroom"
dishborealis (AT) yahoo (DOT) com> wrote:

Using PdoxDOS 4.5 with XP Pro

I created a table, filled it with data (from a csv file), and noticed
immediately that it didn't exist. "What?", you ask. I also had an Explorer
window open to the folder in which I was creating tables. I noticed that
the
table I created wasn't in the file list, even after refreshing the list.
The
table was still on the Pdox screen, and I could page through it (didn't
try
editing it). But, when I cleared the Pdox screen (ALT-F8) and then tried
to
view the table again, Pdox couldn't find it.

Interesting. I created it again, and had the same problem. Exited Paradox,
restarted the machine, and the problem's gone for now. Obviously, it will
be
back, but why? Does Pdox 4.5 require a files or buffers setting when run
in
XP?





Reply With Quote
  #5  
Old   
Michael Kennedy
 
Posts: n/a

Default Re: Vanishing table! - 07-18-2006 , 08:24 AM



What name did you assign to the new table?

If you used something like ENTRY1, or perhaps ANSWER, CHANGED, etc, then
they'll go into the PRIVATE Folder, and will be deleted automatically when
PDox closes down.

As Larry said, if you have assigned a list of your own table-names to be in
"Private", then any table created with any of these names will be there
also - but probably won't be deleted when PDox closes.

In Explorer, you must watch BOTH the ACTUAL Working folder being used, and
the ACTUAL Private folder being used (which may not be the same as the one
requested!!)..

- Mike



"JoeSpareBedroom" <dishborealis (AT) yahoo (DOT) com> wrote

Quote:
Using PdoxDOS 4.5 with XP Pro

I created a table, filled it with data (from a csv file), and noticed
immediately that it didn't exist. "What?", you ask. I also had an Explorer
window open to the folder in which I was creating tables. I noticed that
the table I created wasn't in the file list, even after refreshing the
list. The table was still on the Pdox screen, and I could page through it
(didn't try editing it). But, when I cleared the Pdox screen (ALT-F8) and
then tried to view the table again, Pdox couldn't find it.

Interesting. I created it again, and had the same problem. Exited Paradox,
restarted the machine, and the problem's gone for now. Obviously, it will
be back, but why? Does Pdox 4.5 require a files or buffers setting when
run in XP?






Reply With Quote
  #6  
Old   
Steve Urbach
 
Posts: n/a

Default Re: Vanishing table! - 07-18-2006 , 10:03 AM




On Tue, 18 Jul 2006 14:24:49 +0100, "Michael Kennedy"
<Info (AT) KennedySoftware (DOT) ie> wrote:

Quote:
What name did you assign to the new table?

If you used something like ENTRY1, or perhaps ANSWER, CHANGED, etc, then
they'll go into the PRIVATE Folder, and will be deleted automatically when
PDox closes down.
Just to expand on this: Tables declared Private with "Privtables" do
NOT get deleted or emptied at the end of a Paradox Session.
They also do not *Appear* on paradox file lists after a Reset or New
Session start until a new Privtables declaration.
Also tables declared PRIVATE will supercede (and hide) the Public
(shared) version with the same name.

Quote:
As Larry said, if you have assigned a list of your own table-names to be in
"Private", then any table created with any of these names will be there
also - but probably won't be deleted when PDox closes.

In Explorer, you must watch BOTH the ACTUAL Working folder being used, and
the ACTUAL Private folder being used (which may not be the same as the one
requested!!)..

- Mike


Steve U


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.