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

Author

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

Glen

2004-03-26, 11:01 pm

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.

David Cadkin

2004-03-26, 11:01 pm

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

Jean Lussier

2004-03-26, 11:01 pm

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.

Glen

2004-03-26, 11:01 pm

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

Glen

2004-03-26, 11:01 pm

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

NYCShows

2004-03-26, 11:01 pm

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

Sponsored Links