I asked this the other day on the database list, but got no response... it
sure looks like there might be some folks on this list who can do a little
experiment for me... (Thanks Neven!)
Just wondering if anybody knows if the problem with parameterised stored
procedures against MS-SQL 7 (described at
http://www.borland.com/devsupport/delphi/faq/FAQ4611D.html) goes away if
you're using ADO.
Cheers,
Kerry
----- Original Message -----
From: Neven MacEwan <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Tuesday, February 01, 2000 11:03 AM
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
