CANT UPDATE STANDALONE SDE TABLE in ARcPADI have code that is running fine from a Geodatabase...there is a standalone table that is related to a FC....I am using a SQL statment to write to this table and create historical records.My problem starts when I move the data to SDE and try and do the same....I simply imported the Geodatabase into my SDE...the FC point is in a dataset with the relationship class, and the standalone table is at the root. Now the SQL statement below errors saying cant find table1. Could the . (periods) in the code below be causing the problem?2. Could the fact that the data is not in the same dataset be the problem?This works with the GeodatabasesSQL = "INSERT INTO OUFALLS_HISTORICAL (INSPECT_BY, UNIQUE_ID1, UNIQUE_ID, OF_RECWTR, INSPECT_YR, GRATE_, CONDTN, AXF_TIMESTAMP, AXF_STATUS) VALUES ('" & varcbo_User & "', '" & vartxtUniqueID & "', '" & vartxtUniqueID & "', '" & varreceivewater & "', '" & vardate & "', '" & vargrate & "', '" & varcondition & "', getDate(), 1)" I try this with the SDE data and it wont work....sSQL = "INSERT INTO MG_SDE.MG_GENERAL.outfalls_historical (INSPECT_BY, UNIQUE_ID1, UNIQUE_ID, OF_RECWTR, INSPECT_YR, GRATE_, CONDTN, AXF_TIMESTAMP, AXF_STATUS) VALUES ('" & varcbo_User & "', '" & vartxtUniqueID & "', '" & vartxtUniqueID & "', '" & varreceivewater & "', '" & vardate & "', '" & vargrate & "', '" & varcondition & "', getDate(), 1)" MG_SDE.MG_GENERAL.outfalls_historical has . which must be messing it up?Do I need to change the name of the standalone table, and remove the . ?
