Strange Problem w/Build() PLEASE HELP!!!

Hi,

I've run into a problem that I hope someone can shed some light on.

I have a large file that I'm appending records to and then building
the indexes. This is the sequence of events.

File opened by procedure
stream (file)

Loop while adding records
append(file)

Done adding records
flush(file)
close(file)
open(file,12h)
build(file)

Problem: The build never takes place! I also check for errors after
each statement with no errors being reported.

If I close the application and restart it I'm able to build the file
with a single call to "build(file)"

Can anyone shed some light on this for me????

Thanks in advance,
Glen

P.S. I'm running XP Pro.

I have run into the same problem before.

Instead of closing and reopening the file, try using the lock command to
lock the file, and then do the build.  This fixed the problem for me.

"Glen" <noreply@noreply.com> wrote in message
 news:4ivg50h3h8l8bbnlbiefcmp2o6ld5m8l3p@
4ax.com...
> Hi,
>
> I've run into a problem that I hope someone can shed some light on.
>
> I have a large file that I'm appending records to and then building
> the indexes. This is the sequence of events.
>
> File opened by procedure
>      stream (file)
>
> Loop while adding records
>       append(file)
>
> Done adding records
>       flush(file)
>       close(file)
>       open(file,12h)
>       build(file)
>
> Problem: The build never takes place! I also check for errors after
> each statement with no errors being reported.
>
> If I close the application and restart it I'm able to build the file
> with a single call to "build(file)"
>
> Can anyone shed some light on this for me????
>
> Thanks in advance,
> Glen
>
> P.S. I'm running XP Pro.
>

If this is a TPS file, try this:

Open(File,12h)
Send(File,'FULLBUILD=ON')
Build(File)


Read the documentation or on-line HELP on
"Driver Strings" for the TPS driver.


Jean Lussier
INFORMACCES - Montreal (Canada)



"Glen" <noreply@noreply.com> wrote in message
 news:4ivg50h3h8l8bbnlbiefcmp2o6ld5m8l3p@
4ax.com...
> Hi,
>
> I've run into a problem that I hope someone can shed some light on.
>
> I have a large file that I'm appending records to and then building
> the indexes. This is the sequence of events.
>
> File opened by procedure
>      stream (file)
>
> Loop while adding records
>       append(file)
>
> Done adding records
>       flush(file)
>       close(file)
>       open(file,12h)
>       build(file)
>
> Problem: The build never takes place! I also check for errors after
> each statement with no errors being reported.
>
> If I close the application and restart it I'm able to build the file
> with a single call to "build(file)"
>
> Can anyone shed some light on this for me????
>
> Thanks in advance,
> Glen
>
> P.S. I'm running XP Pro.

I tried locking the file, no success.... Any other suggestions?


On Wed, 17 Mar 2004 16:51:39 GMT, "David Cadkin" <dcadkin@phycare.com>
wrote:

>I have run into the same problem before.
>
>Instead of closing and reopening the file, try using the lock command to
>lock the file, and then do the build.  This fixed the problem for me.
>
>"Glen" <noreply@noreply.com> wrote in message
> news:4ivg50h3h8l8bbnlbiefcmp2o6ld5m8l3p@
4ax.com... 
>

I've already tried that also, no luck. I'm STUMPED!!!!


On Wed, 17 Mar 2004 13:46:27 -0500, "Jean Lussier"
<jean.lussier@nospam.com> wrote:

>If this is a TPS file, try this:
>
>   Open(File,12h)
>   Send(File,'FULLBUILD=ON')
>   Build(File)
>
>
>Read the documentation or on-line HELP on
>"Driver Strings" for the TPS driver.
>
>
>Jean Lussier
>INFORMACCES - Montreal (Canada)
>
>
>
>"Glen" <noreply@noreply.com> wrote in message
> news:4ivg50h3h8l8bbnlbiefcmp2o6ld5m8l3p@
4ax.com... 
>
>

if you've got duplicate(s) the build will fail silently - check for duplicat
es!