I believe you must turn on B-Tree key option. This creates a sister DB file
of the KSAM type, thus allowing partial key look up. I am not sure if the
ODBC linkage will automatically know this or not. Of course any time you
change the Turbo DB you must detach and re-attach the Turbo DB to the SQL
environment.

James

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of ALBERT KARMAN
Sent: Monday, December 27, 1999 12:34 PM
To: [log in to unmask]
Subject: Request for info


Good day to my fellow listers---hope all had terrific holidays, and
coal-lumps were kept to a minimum....!

Here's my question.  I've got an IMAGE db accessed by Minisoft's ODBC/32
product, and the developer is looking to provide for partial key
retrieval on the PC side.  Maybe it's brain cramps, possible
over-nogging, but what's involved (without TPI) to provide that
functionality?  I don't have sorted chains, or anything so '20 minutes
ago'!

Yours in /iX,

Al Karman
IT Consultant
Administrative Management Group
847.870.9288
[log in to unmask]

-----Original Message-----
From: Jim Phillips [mailto:[log in to unmask]]
Sent: Monday, December 27, 1999 10:37 AM
To: [log in to unmask]
Subject: OT: Monday Humor

The list seems kind of slow today, so here is some humo(u)r for those of
us
still working during the holidays.


A certain little girl, when asked her name, would reply, "I'm Mr.
Sugarbrown's daughter." Her mother told her this was wrong, she must
say,
"I'm Jane Sugarbrown."

The minister spoke to her in Sunday School, and said, "Aren't you Mr.
Sugarbrown's daughter?"

She replied, "I thought I was, but mother says I'm not."



Jim Phillips                            Manager of Information Systems
E-Mail: [log in to unmask]     Therm-O-Link, Inc.
Phone: (330) 527-2124                   P. O. Box 285
  Fax: (330) 527-2123                   Garrettsville, Ohio  44231