Thanks Razzak. That seems to work correctly. I changed the logic in my command file.
Thanks again. Ajay "A. Razzak Memon" <[EMAIL PROTECTED]> Sent by: [email protected] 11/04/2008 05:09 PM Please respond to [email protected] To [email protected] (RBASE-L Mailing List) cc Subject [RBASE-L] - Re: ERROR- invalid cursor state (2645) At 04:45 PM 11/4/2008, [EMAIL PROTECTED] wrote: >Hell list > >I have a command file that was working correctly yesterday but today >when I run the same command file I get an error message "ERROR- >invalid cursor state (2645)" > > >Following is the command line that creates the error. > >GATEWAY EXPORT XLSW bank_inv.xlsx + >SELECT >itemcs,locout,itmout,desout,venout,ivalot,balout,excost,orgcst4 FROM invp01 + >WHERE excost > 0 ORDER BY itemcs,locout,desout + >OPTION COL_NAMES ON + >|TAB_NAME Full_Inventory + >|STYLE ZEBRA + >|SHOW_PROGRESS ON + >|SPECIFICATION_FILE_NAME Bank_Inv.rgw > >The table invp01 is an Non Rbase table accessed using a ODBC connection. Ajay, Make sure that the server table (InvP01) is actually STTACHed. Without knowing all details, you may use the following technique to achieve your goal: -- Start here ... SET ERROR MESSAGE 2038 OFF DROP TABLE tInvP01 SET ERROR MESSAGE 2038 ON PROJECT TEMPORARY tInvP01 FROM InvP01 USING ALL GATEWAY EXPORT XLSW bank_inv.xlsx + SELECT itemcs,locout,itmout,desout,venout,ivalot,balout,excost,orgcst4 + FROM tInvp01 WHERE excost > 0 ORDER BY itemcs,locout,desout + OPTION COL_NAMES ON + |TAB_NAME Full_Inventory + |STYLE ZEBRA + |SHOW_PROGRESS ON + |SPECIFICATION_FILE_NAME Bank_Inv.rgw DROP TABLE tInvP01 RETURN -- End here ... Hope that helps! Very Best R:egards, Razzak. P Please consider the environment before printing this e-mail. Thank you.
