Now I see it
sele(fname)
without the space it returns 0
The people at the plant are doing something to change the current alias and
delete file fails because the table is staying open.
Tracy
> -----Original Message-----
> From: John J. Mihaljevic
> Sent: Monday, October 16, 2006 3:14 PM
>
> > I'm having trouble getting my head wrapped around how this
> > works on one machine but not other
> > select (fname)
> > use
> > dele file &fname
> >
> > If the variable fname has the format "tmp12345.dbf" the
> > select won't work, but the delete will.
> > If the variable fname has the format "tmp12345" the select
> > will work, but the delete won't.
>
> The variable fname has the format "tmp12345.dbf." Here's an example:
>
> fname="sbp"+right(sys(3),5)+".dbf"
>
> The Select works on both machines. Here's an example of that:
>
> sele fingoods.part_no, fingoods.rate, fingoods.line,
> fingoods.bar_diam, fingoods.bar_length,;
> 0000000 as sold_mtd, 0000000 as sold_qtd,
> 0000000 as sold_ytd;
> from fingoods;
> orde by fingoods.part_no;
> into dbf &fname
>
> The Delete works every time on my machine, but not on the
> machine in our
> plant:
>
> sele(fname)
> use
> dele file &fname
>
> John
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** 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.
