Re: Queries

Dale E. Reed Jr. ( (no email) )
Wed, 28 Jan 1998 09:08:05 -0800

Elon Richards wrote:
>
> The reason why the SQL statement executed without error at your end and not at
> ours is because of the field NASIdentifier. Our NAS reports this field as
> NASIPAddress. Therefore we changed the fieldname in the RadAttributes table as
> well as in the Calls table. Hence the field NASIdentifier does not exist in our
> database. How can we get the query to use the name as defined in the dictionary???

You should have simply changed the Dictionary name from NASIPAddress to
NASIdentifier rather than changing the table. The query uses the
names from the Dictionary and matches them to the fields in the table
automatically.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com