Board index » delphi » Error inserting on D6 Ent and SQL 7

Guillermo Casta?o A

Delphi Developer
Thu, 20 May 2004 04:55:12 GMT

Error inserting on D6 Ent and SQL 7

Hi, i'm having this odd error:
Multiple step operation generated errors. Check each status value.
When i try to post info to a SQL 7 table using a TADOQuery.
what can it be? All my other forms.queries works perfectly.
thanks
--
Guillermo Casta?o Acevedo
Gerente de Sistemas - Grupo Millennium Ltda
Guiller...@GrupoMillennium.com
www.GrupoMillennium.com
 
Greg Nixo

Delphi Developer
Thu, 20 May 2004 17:26:32 GMT

Re:Error inserting on D6 Ent and SQL 7


Do you change any TFileds in the Datasources OnStateChange because I found
that sometimes caused strange errrors when doing and insert and I moved them
to OnNewRow and the problem went away. (This worked ok when I used the BDE)

"Guillermo Casta?o A" <Guiller...@GrupoMillennium.com> wrote in message
news:3C0943B0.AF4716FC@GrupoMillennium.com...

Quote
> Hi, i'm having this odd error:
> Multiple step operation generated errors. Check each status value.
> When i try to post info to a SQL 7 table using a TADOQuery.
> what can it be? All my other forms.queries works perfectly.
> thanks
> --
> Guillermo Casta?o Acevedo
> Gerente de Sistemas - Grupo Millennium Ltda
> Guiller...@GrupoMillennium.com
> www.GrupoMillennium.com

Guillermo Casta?o

Delphi Developer
Fri, 21 May 2004 01:12:40 GMT

Re:Error inserting on D6 Ent and SQL 7


Nop, i have no code in the Datasource events at all... Only on the dataset
(TADOQuery).
thanks

Quote
Greg Nixon wrote:
> Do you change any TFileds in the Datasources OnStateChange because I found
> that sometimes caused strange errrors when doing and insert and I moved them
> to OnNewRow and the problem went away. (This worked ok when I used the BDE)

> "Guillermo Casta?o A" <Guiller...@GrupoMillennium.com> wrote in message
> news:3C0943B0.AF4716FC@GrupoMillennium.com...
> > Hi, i'm having this odd error:
> > Multiple step operation generated errors. Check each status value.
> > When i try to post info to a SQL 7 table using a TADOQuery.
> > what can it be? All my other forms.queries works perfectly.
> > 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
David B.

Delphi Developer
Fri, 21 May 2004 03:04:15 GMT

Re:Error inserting on D6 Ent and SQL 7


Guillermo

Check for primary key in your table

Regards

   David  B.E      supp...@agrosoft.co.il
   (Delphi is behind the power of things.................)

Guillermo Casta?o

Delphi Developer
Fri, 21 May 2004 07:36:12 GMT

Re:Error inserting on D6 Ent and SQL 7


You were right, one of the PK fields was smallint and i was trying to
assing it a too large number. Changing it to integer fixes the problem.
thanks a lot

Quote
"David B.E" wrote:
> Guillermo

> Check for primary key in your table

> Regards

>    David  B.E      supp...@agrosoft.co.il
>    (Delphi is behind the power of things.................)

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

Other Threads

1. Doing SQL on non-persistent data ? (D6 Ent)

2. Porting Problems D5 Ent -> D6 Pro

3. Registering D6 Ent 4 times

4. D6 Ent: Best TCP/IP Component

5. D6(Ent) IDE problems when using multiple automation projects

6. What IB6 with D6 Ent e Pro?

7. D6 Ent update #2 blew up dbExpress....

8. [D6 Ent / DbExprress+ Oracle 9i]

9. dbExpress for ADO vs. D6 Ent ADO components

10. components i D6 ENT