Odd ADO problem! Please help! 
Author Message
 Odd ADO problem! Please help!

I always seem to get some odd error messages ...

DB/App config: delphi 5 (with last ADO upgrade)/ADO/Access 2000

I'm doing an SaveToFile export into XML files from Access 2000 database.

When I execute this block:
        with qryTemp do begin
            Close; SQL.Clear;
            SQL.Add('SELECT * FROM '+TableName);
            Open;
            SaveToFile(IncludeTrailingBackslash(ExportDir)+TableName+'.xml',
pfXML);
            Close;
          end;

This raises an EOLEException exception for only one table(!):
    "Multiple-step operation generated errors. Check each status value"
and I simply can not find out why :(

Table on which I have problems has an AutoNumber field, one integer field
and one date/time field (those are the keys),
one text (50 chars) field and about 30 double fields.

I use this code in a for-loop where I export more tables and only one table
raises this exception.
It is also raised when I try to export only that problematic table.

Any ideas? Thanks in advace!

--
{[nikica]coding*4[$||:)]}



Sat, 21 Feb 2004 17:00:44 GMT  
 Odd ADO problem! Please help!
Did you use a server-side or client-side cursor ?


Quote:
> I always seem to get some odd error messages ...

> DB/App config: Delphi 5 (with last ADO upgrade)/ADO/Access 2000

> I'm doing an SaveToFile export into XML files from Access 2000 database.

> When I execute this block:
>         with qryTemp do begin
>             Close; SQL.Clear;
>             SQL.Add('SELECT * FROM '+TableName);
>             Open;

SaveToFile(IncludeTrailingBackslash(ExportDir)+TableName+'.xml',
Quote:
> pfXML);
>             Close;
>           end;

> This raises an EOLEException exception for only one table(!):
>     "Multiple-step operation generated errors. Check each status value"
> and I simply can not find out why :(

> Table on which I have problems has an AutoNumber field, one integer field
> and one date/time field (those are the keys),
> one text (50 chars) field and about 30 double fields.

> I use this code in a for-loop where I export more tables and only one
table
> raises this exception.
> It is also raised when I try to export only that problematic table.

> Any ideas? Thanks in advace!

> --
> {[nikica]coding*4[$||:)]}



Sat, 21 Feb 2004 17:10:01 GMT  
 Odd ADO problem! Please help!
I use CursorLocation=clUseClient.
It's a local DB in app's main folder!


Quote:
> Did you use a server-side or client-side cursor ?



> > I always seem to get some odd error messages ...

> > DB/App config: Delphi 5 (with last ADO upgrade)/ADO/Access 2000

> > I'm doing an SaveToFile export into XML files from Access 2000 database.

> > When I execute this block:
> >         with qryTemp do begin
> >             Close; SQL.Clear;
> >             SQL.Add('SELECT * FROM '+TableName);
> >             Open;

> SaveToFile(IncludeTrailingBackslash(ExportDir)+TableName+'.xml',
> > pfXML);
> >             Close;
> >           end;

> > This raises an EOLEException exception for only one table(!):
> >     "Multiple-step operation generated errors. Check each status value"
> > and I simply can not find out why :(

> > Table on which I have problems has an AutoNumber field, one integer
field
> > and one date/time field (those are the keys),
> > one text (50 chars) field and about 30 double fields.

> > I use this code in a for-loop where I export more tables and only one
> table
> > raises this exception.
> > It is also raised when I try to export only that problematic table.

> > Any ideas? Thanks in advace!

> > --
> > {[nikica]coding*4[$||:)]}



Sat, 21 Feb 2004 18:19:55 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Help Very odd Problem

2. ADO help please

3. Help me, PLEASE ! (ADO)

4. ADO and Access - Nagging problems - HELP!

5. Please Please, help me with memo-fields, real problem

6. Please help with this problem!!ARRAY problem

7. Record locking with ADO Express, ADO 2.5 and Access 2000 .mdb files

8. ADO Problems... Help Please!

9. Please help...database problem

10. TCurrencyField-Problem: PLEASE HELP!!!

11. Delphi and Windows 95 Cache - Problems - Please Help!

12. Problem with Insert Method, Please Help...

 

 
Powered by phpBB® Forum Software