Discussion:
Integration Manager - GP10
(too old to reply)
Mick Egan
2008-12-11 22:34:04 UTC
Permalink
I want to remove the data from the source records and applied the following
to the after query on the source integration:
query.deletesourcerecords()

The following is returned:
Deleting data in a linked table is not supported by this ISAM.
Internal Error in Microsoft JET Database Engine.
Source: Microsoft JET Database Engine.

But when adding "query.deletesourcefile()" this works.

I have tested on IM SP2 and SP3.
Mariano Gomez
2008-12-12 19:30:01 UTC
Permalink
Mick,

The DeleteSourceRecords method allows you to delete the source records from a
simple ODBC query that was used for an integration. If your source records
are a text file, this will not work and your only option will be to use
query.deletesourcefile().

To fix this issue, change your source query to use a simple ODBC query
rather than a text file directly. You can retrieve all records in your text
file by still using a simple ODBC query.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
Post by Mick Egan
I want to remove the data from the source records and applied the following
query.deletesourcerecords()
Deleting data in a linked table is not supported by this ISAM.
Internal Error in Microsoft JET Database Engine.
Source: Microsoft JET Database Engine.
But when adding "query.deletesourcefile()" this works.
I have tested on IM SP2 and SP3.
Mick Egan
2008-12-13 05:00:01 UTC
Permalink
Mariano,

Thanks, I will give that a go, sounds logical.

Mick
Post by Mariano Gomez
Mick,
The DeleteSourceRecords method allows you to delete the source records from a
simple ODBC query that was used for an integration. If your source records
are a text file, this will not work and your only option will be to use
query.deletesourcefile().
To fix this issue, change your source query to use a simple ODBC query
rather than a text file directly. You can retrieve all records in your text
file by still using a simple ODBC query.
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
Post by Mick Egan
I want to remove the data from the source records and applied the following
query.deletesourcerecords()
Deleting data in a linked table is not supported by this ISAM.
Internal Error in Microsoft JET Database Engine.
Source: Microsoft JET Database Engine.
But when adding "query.deletesourcefile()" this works.
I have tested on IM SP2 and SP3.
Mick Egan
2008-12-15 21:44:16 UTC
Permalink
Mariano,

I add the Text ODBC, but still get an error that you cannot delete a linked
table when "query.deletesourcerecords()"

Mick
Post by Mariano Gomez
Mick,
The DeleteSourceRecords method allows you to delete the source records from a
simple ODBC query that was used for an integration. If your source records
are a text file, this will not work and your only option will be to use
query.deletesourcefile().
To fix this issue, change your source query to use a simple ODBC query
rather than a text file directly. You can retrieve all records in your text
file by still using a simple ODBC query.
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
Post by Mick Egan
I want to remove the data from the source records and applied the following
query.deletesourcerecords()
Deleting data in a linked table is not supported by this ISAM.
Internal Error in Microsoft JET Database Engine.
Source: Microsoft JET Database Engine.
But when adding "query.deletesourcefile()" this works.
I have tested on IM SP2 and SP3.
Loading...