Kerry
That 'bug' seems to just be a naming problem - nothing serious
I use parameterised queries all the time - the bugbear is setting all the
datatype on the parameters
Regards
----- Original Message -----
From: Kerry Sainsbury <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Tuesday, 1 February 2000 11:16
Subject: Re: [DUG]: [Q] SQ7 & D5 using BDE....
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
