SQL Server statement with subselect is invalid -


Hey, I'm using iBATIS with SQL Server compact version 3.5 and try to make a subcategory

  INSERT (ID, ID_FM) SELECT # ID #, f.ID fROM form f WHERE ID_PROCESS = '10804'  

SqlCeException ( SSCE_M_QP_PARAMETERNOTALLOWED ).

The symbol ' @ ' is in the wrong place, I think it is #ID # which is unexpected in SELECT # ID # not the name of the column That is the value that should be put in FORMINSTANCE. How can I fix this?

ty

if # part of the column name ...

  Login Accreditation (ID, ID_FORM) SELECT [# ID #], f.ID If you want to select a dynamic column on the position # 1, it's not that I really do This is what you are up, but by any means), you may be away with:  
  Please enter accreditation (ID, ID_FAM) when the @ID = 'Foo' then foo when @ID = 'bar' THEN times ELSE L'END, FID F F F WHERE Aidi_ PROCESS = '10804'  

Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -