Following is the test query

...
tableName | field Name             |
          | CHECK as TO someName   |
...

Start your Paradox for Windows. Choose Help|About. Press I. Internal
build will be displayed. Then there will be words "lego:" followed
by a date. If that date is from 1994, you are OK. But if you installed
Delphi or latest release of Novel Office or Quatro Pro, that date
might be from 1995. That's the version of IDAPI the BUG is in. Here
is how it goes...

In above query we have used word "TO". It is not a key word. I called
Borland's Tech Support line paying $2/min and they confirmed it's not.

Above query works fine. But if your "lego" date (i.e. IDAPI build) meets
above criteria, you will get an error message saying "AS must be followed
by a name of field in the ANSWER table". Whether you some thing after
TO or not, DOES NOT MATTER.

Called Borland many times about it but the guys there wouldn't believe
me as it works on any copy of Paradox. Finally I asked them to try it
on a machine which had DELPHI installed on it after Paradox and thus
had a "lego:" date of Feb/95. It was confirmed and registered.

regards,
--nasir

: Following is the test query

: ...
: tableName | field Name             |
:           | CHECK as TO someName   |
: ...

: Start your Paradox for Windows. Choose Help|About. Press I. Internal
: build will be displayed. Then there will be words "lego:" followed
: by a date. If that date is from 1994, you are OK. But if you installed
: Delphi or latest release of Novel Office or Quatro Pro, that date
: might be from 1995. That's the version of IDAPI the BUG is in. Here
: is how it goes...

: In above query we have used word "TO". It is not a key word. I called
: Borland's Tech Support line paying $2/min and they confirmed it's not.

I hope they are sure about that.  Can someone check Paradox Informant?  I
think they discussed query changes recently and some query keywords were
NOT documented.  

: Above query works fine. But if your "lego" date (i.e. IDAPI build) meets
: above criteria, you will get an error message saying "AS must be followed
: by a name of field in the ANSWER table". Whether you some thing after
: TO or not, DOES NOT MATTER.

: Called Borland many times about it but the guys there wouldn't believe
: me as it works on any copy of Paradox. Finally I asked them to try it
: on a machine which had DELPHI installed on it after Paradox and thus
: had a "lego:" date of Feb/95. It was confirmed and registered.

However, if you DON'T have the Feb/95 IDAPI lego date, expect some ODBC
drivers to go KAPUT with no errors.  Happened to me with Intersolv ODBC
drivers for Btrieve.  No Feb/95 IDAPI, no data.

--
=========================================================================
Kasey K. S. Chang (a guy)             | Paradox for Windows Programmer

URL> http://userwww.sfsu.edu/~kschang | X-COM Guru   General PC expert
--------------------------------------+----------------------------------
Editor of XCOM and XCOM2 UN-official Strategy Guide -- FREE!  (See URL)