Re: Open Dialog on SELECT - SQL

• Previous message: Kumar: "Open Dialog on SELECT - SQL"
• In reply to: Kumar: "Open Dialog on SELECT - SQL"
• Messages sorted by: [ date ] [ thread ]

Date: Tue, 10 Aug 2004 15:49:22 +0200

Kumar,

I've recently come across a puzzeling behaviour:
sometimes a table opened with a specific alias

If ! used(m.tcBlaBlx)
    select 0
    Use (m.tcblabla) alias (m.tcBlaBlx) again
endif

is opened with another alias(). If queried and protocolled
in the program, non-printable ASCI is returned by alias(),
in the debugger watch shows the value of dbf() for alias()
in the watch window. Probably debugger follow up mistake.

A directly following select() to that alias fails.
The table is single user only on the local machine.
I see it under W2k (Not under NT4) and VFP6 quite regularly
(maybe 6-9 out of .24 Million uses, it is a long running data
converting/mining app) even if I regularly garbage collect.
VFP9 has shown the error as well, but only twice in a test
scenario where I'ld expect 5-6 errors.

Try not only to open the dbf() but check the alias, if you are
refering to it in the SELECT-SQL.

HTH

thomas

"Kumar" <Kumar@discussions.microsoft.com> schrieb im Newsbeitrag
news:9675FE4A-1668-4DD5-988E-C1E0CC4E3265@microsoft.com...
> I occassionally (and randomly) get the open dialog on a certain SELECT-SQL
> statment. I've added a check to confirm the file exists and even open
the
> DBF before the select statement.
> I still keep getting the dialog occassionally. Has anyone else
encountered
> this? If so, were you able to fix / get-around it ?
>
> Any help would be appreciated.....
>
> Thanks.
> K

• Previous message: Kumar: "Open Dialog on SELECT - SQL"
• In reply to: Kumar: "Open Dialog on SELECT - SQL"
• Messages sorted by: [ date ] [ thread ]