delete parameters anymore

Guillermo Casta?o A

Delphi Developer

Tue, 18 May 2004 00:32:49 GMT

Cannot add/delete parameters anymore

Hi, i just notice that i can delete/add parameters in the parameter
editor anymore. The buttons are disabled.
Why is that?
thanks
--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com

Kevin Frever

Delphi Developer

Tue, 18 May 2004 04:56:11 GMT

Re:Cannot add/delete parameters anymore

Guillermo,

There must be parameters in the SQL text before those options are enabled
in the parameter editor.

krf

Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
news:3C066331.F10E0F4E@GrupoMillennium.com...

Quote

> Hi, i just notice that i can delete/add parameters in the parameter
> editor anymore. The buttons are disabled.
> Why is that?
> thanks
> --
> Guillermo Casta?o Acevedo
> Gerente de Sistemas - Grupo Millennium Ltda
> Guiller...@GrupoMillennium.com
> www.GrupoMillennium.com

Guillermo Casta?o

Delphi Developer

Tue, 18 May 2004 03:29:11 GMT

Re:Cannot add/delete parameters anymore

Thanks, i know it. There are already four parameters in the query.

Quote

Kevin Frevert wrote:
> Guillermo,

> There must be parameters in the SQL text before those options are enabled
> in the parameter editor.

> krf

> Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
> news:3C066331.F10E0F4E@GrupoMillennium.com...
> > Hi, i just notice that i can delete/add parameters in the parameter
> > editor anymore. The buttons are disabled.
> > Why is that?
> > thanks
> > --
> > Guillermo Casta?o Acevedo
> > Gerente de Sistemas - Grupo Millennium Ltda
> > Guiller...@GrupoMillennium.com
> > www.GrupoMillennium.com

--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com

Kevin Frever

Delphi Developer

Tue, 18 May 2004 05:31:39 GMT

Re:Cannot add/delete parameters anymore

I knew it wasn't going to be that simple :). Are you using ADO (TADOQuery,
etc) or BDE (TQuery)? I've seen this with ADO when there is something wrong
with the SQL (misspelling, missing comma, whatever) and the parser cannot
determine the parameters, so the editor is blank.

Good luck,
krf

Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
news:3C068C86.FCE44479@GrupoMillennium.com...

Quote

> Thanks, i know it. There are already four parameters in the query.

> Kevin Frevert wrote:

> > Guillermo,

> > There must be parameters in the SQL text before those options are
enabled
> > in the parameter editor.

> > krf

> > Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
> > news:3C066331.F10E0F4E@GrupoMillennium.com...
> > > Hi, i just notice that i can delete/add parameters in the parameter
> > > editor anymore. The buttons are disabled.
> > > Why is that?
> > > thanks
> > > --
> > > Guillermo Casta?o Acevedo
> > > Gerente de Sistemas - Grupo Millennium Ltda
> > > Guiller...@GrupoMillennium.com
> > > www.GrupoMillennium.com

> --
> Guillermo Casta?o Acevedo
> Gerente de Sistemas - Grupo Millennium Ltda
> Guiller...@GrupoMillennium.com
> www.GrupoMillennium.com

Guillermo Casta?o

Delphi Developer

Tue, 18 May 2004 04:41:23 GMT

Re:Cannot add/delete parameters anymore

Using BDE, the odd thing... i've been using Delphi for around 5 years and it's
the first time it happens... the SQL is OK. Very strange...

Quote

Kevin Frevert wrote:
> I knew it wasn't going to be that simple :). Are you using ADO (TADOQuery,
> etc) or BDE (TQuery)? I've seen this with ADO when there is something wrong
> with the SQL (misspelling, missing comma, whatever) and the parser cannot
> determine the parameters, so the editor is blank.

> Good luck,
> krf

> Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
> news:3C068C86.FCE44479@GrupoMillennium.com...
> > Thanks, i know it. There are already four parameters in the query.

> > Kevin Frevert wrote:

> > > Guillermo,

> > > There must be parameters in the SQL text before those options are
> enabled
> > > in the parameter editor.

> > > krf

> > > Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
> > > news:3C066331.F10E0F4E@GrupoMillennium.com...
> > > > Hi, i just notice that i can delete/add parameters in the parameter
> > > > editor anymore. The buttons are disabled.
> > > > Why is that?
> > > > thanks
> > > > --
> > > > Guillermo Casta?o Acevedo
> > > > Gerente de Sistemas - Grupo Millennium Ltda
> > > > Guiller...@GrupoMillennium.com
> > > > www.GrupoMillennium.com

> > --
> > Guillermo Casta?o Acevedo
> > Gerente de Sistemas - Grupo Millennium Ltda
> > Guiller...@GrupoMillennium.com
> > www.GrupoMillennium.com

--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com

Kevin Frever

Delphi Developer

Tue, 18 May 2004 07:01:05 GMT

Re:Cannot add/delete parameters anymore

Yes, that is odd. I can reproduce this. My TQuery.Params editor options
(insert, delete) are disabled too? I'm doing a lot with ADO now and haven't
done anything new with the BDE for some time. Is this a bug (TStoredProc
seems to work fine)?

krf

Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
news:3C069D72.A17D3B42@GrupoMillennium.com...

Quote

> Using BDE, the odd thing... i've been using Delphi for around 5 years and
it's
> the first time it happens... the SQL is OK. Very strange...

Guillermo Casta?o

Delphi Developer

Tue, 18 May 2004 06:33:40 GMT

Re:Cannot add/delete parameters anymore

Nice to hear you have the same problem... not for you but because it must be a
bug.
I'm using D6 enterprise, in D5 Ent all worked OK.
What Delphi version are you using?

Quote

Kevin Frevert wrote:
> Yes, that is odd. I can reproduce this. My TQuery.Params editor options
> (insert, delete) are disabled too? I'm doing a lot with ADO now and haven't
> done anything new with the BDE for some time. Is this a bug (TStoredProc
> seems to work fine)?

> krf

> Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
> news:3C069D72.A17D3B42@GrupoMillennium.com...
> > Using BDE, the odd thing... i've been using Delphi for around 5 years and
> it's
> > the first time it happens... the SQL is OK. Very strange...

--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com

Kevin Frever

Delphi Developer

Tue, 18 May 2004 23:13:07 GMT

Re:Cannot add/delete parameters anymore

D6 Enterprise. It's not a big deal for me, but maybe for some this could be
an inconvenience.

krf

Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
news:3C06B7C4.B1CEA0B5@GrupoMillennium.com...

Quote

> Nice to hear you have the same problem... not for you but because it must
be a
> bug.
> I'm using D6 enterprise, in D5 Ent all worked OK.
> What Delphi version are you using?

Guillermo Casta?o

Delphi Developer

Tue, 18 May 2004 21:53:23 GMT

Re:Cannot add/delete parameters anymore

Not a big deal to me neither... but strange anyway

Quote

Kevin Frevert wrote:
> D6 Enterprise. It's not a big deal for me, but maybe for some this could be
> an inconvenience.

> krf

> Guillermo Casta?o A <Guiller...@GrupoMillennium.com> wrote in message
> news:3C06B7C4.B1CEA0B5@GrupoMillennium.com...
> > Nice to hear you have the same problem... not for you but because it must
> be a
> > bug.
> > I'm using D6 enterprise, in D5 Ent all worked OK.
> > What Delphi version are you using?

--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com

Other Threads

1. Cannot connect to newsgroup anymore! URGENT

2. Application cannot connect anymore

3. BDE CANNOT HANDLE BLOBS ANYMORE

4. Delphi Outlook add-in using ExchExt cannot add menu item

5. adding a TQuery parameter add runtime

6. I'm stuck and need advise - cannot fix Record/Key Deleted

7. I'm stuck and need advise - cannot fix Record/Key Deleted

8. Cannot delete or edit record using Delphi 2.01, Personal Oracle, ODBC

9. Cannot Delete from TRichEdit

10. I'm stuck and need advise - cannot fix Record/Key Deleted