Can someone tell me why I get an error (ORA-00911: invalid character) for the following statement:
strQuery = "SELECT A.SEQ_GMT FROM _SMDBA_._PERSONNEL_ A
WHERE A.CODE = " & user
Set rs1 = conn1.Execute(strQuery)
I believe it's because of the period in the table name. Does anyone know a workaround for this besides changing the name?
strQuery = "SELECT A.SEQ_GMT FROM _SMDBA_._PERSONNEL_ A
WHERE A.CODE = " & user
Set rs1 = conn1.Execute(strQuery)
I believe it's because of the period in the table name. Does anyone know a workaround for this besides changing the name?