![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Thu, Feb 7 2019 6:19 AM | Permanent Link |
sean | We are trying to update a DBISAM table from SQL Server.
OS Windows server 2008 64bit Standard DBISAM ODBC 64bit v4.47 here is the query we are using update RI set ASSETTAG = NDFOOTPRINTS.ND FROM OPENQUERY(INTELLIRW, 'SELECT SERIALNUMBER, ASSETTAG, RACKNAME FROM NEWDB.RACKINFORMATION')RI inner join [PEMIS].dbo.NDFOOTPRINTS on NDFOOTPRINTS.FOOTPRINT = RI.SERIALNUMBER AND NDFOOTPRINTS.RACKNAME = RI.RACKNAME It says it has updated xxx rows, but nothing is updated. Any help would be greatly received |
Wed, Feb 20 2019 11:48 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Sean,
<< here is the query we are using >> Unfortunately, you can't insert into, update, or delete rows from DBISAM tables with the OPENQUERY() pass-through query functionality in SQL Server. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |