Welcome to the zone between ISAM and SQL Databases
The refresh method never works on TQuerys (though I thought it would work on
a TTable if you select an index). I wont go into why here but remember that
ANSII SQL 'hides' the inplementation of indexes, these are 'exposed' by ODBC
drivers for backward compatibility with ISAM Databases
A Few pointers
- Use TQuery not TTable, why make SQL look like dBase
- ADO solves the refresh problem on Queries
hope this helps
Regards
Neven
----- Original Message -----
From: Donovan J. Edye <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Tuesday, 1 February 2000 09:57
Subject: [DUG]: [Q] SQ7 & D5 using BDE....
> G'Day All,
>
> I have a TDatabase connected via an alias to a MS-SQL7 database. I then
have
> a TTable connected to the database. The table has a primary key of Field1,
> Field2, Field3, Field4. However as soon as I call the refresh method for
the
> TTable I get the folowing error:
>
> Table does not support this operation because it is not uniquely indexed.
> Now my PK is unique, so what am I missing here??
>
> TIA
>
> ------------------------------------------------------------------------
> --Donovan
> Donovan J. Edye [www.edye.wattle.id.au]
> Namadgi Systems, Delphi Developer
> Web: www.namsys.com.au E-Mail: [EMAIL PROTECTED]
> Voice: +61 2 6285-3460 Fax: +61 2 6285-3459
> TVisualBasic = Class(None);
> ------------------------------------------------------------------------
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
