work with temp tables in sql server

[alimrb]

i am redeveloping an accounting system from vb6 and sql server in fmp. in vb i create sql server temp tables and work with them ( Insert Into #DocItem( ItemRow ,AsstantCode ,DetailCode, DetailCode2, DetailCode3, [Value], Article , ItemAttachMent , ArzCode , Amount , ArzValue ) Values ...) now in fmp when execute such sql in my scripts, an error dialog arised :"Invalid Object Name '#DocItems'".