[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== CLEAR_TABLE & LEFTOVER KEYS (OpenInsight Specific) ====
=== At 20 JUN 2001 05:11:32PM S Bell wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
When you do a Clear_Table from the command line why

are the record keys still left behind?
</QUOTE>
----

=== At 20 JUN 2001 07:02PM Donald Bakke wrote:  ===

<QUOTE>Sam,



This can mean that a relational index exists against this table. Are the records empty?



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 21 JUN 2001 08:12AM S Bell wrote:  ===

<QUOTE>Hi Donold,



My frist name is Steve.



There are is no indexes and yes the records are empty.

</QUOTE>

----

=== At 21 JUN 2001 10:53AM Donald Bakke wrote:  ===

<QUOTE>Steve,



Sorry about the first name. We know a Sam Bell who uses Revelation tools and just assumed it was you.



There still might be a relational index [i]pointing[/i] to this table.



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]



[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 21 JUN 2001 11:24AM S Bell wrote:  ===

<QUOTE>I've been testing doing some read/write to this file

and when I do this sort of thing I'm used to doing a

recered count befor and after. I did a clear_table to

start over and now I'm not sure what to do because I 

have keys leftover that should'nt be there with the

next batch of rec. Also I do a Query it cuts off at

64xx or 65xx rec and I don't know what I've got.



?????????

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=F272B88D7611E47785256A71007469AC|View this thread on the  forum...]]