N,
> 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
MS-SQL7 --> BDE --> TDataBase --> TTable.Refreh does work once you have set
TTable.IndexFieldNames
> - Use TQuery not TTable, why make SQL look like dBase
But isnt a TTable merely a SQL statement with no WHERE clause??
------------------------------------------------------------------------
--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);
------------------------------------------------------------------------
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Neven MacEwan
> Sent: Tuesday, 1 February 2000 09:04
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: [Q] SQ7 & D5 using BDE....
>
>
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
