' Execute the commands loCommand.CommandType = CommandType.StoredProcedure loCommand.CommandText = "ExecScript" loCommand.Parameters.Add("myScript", OleDbType.Char).Value = loStringBuilderHeaderList.ToString loCommand.ExecuteNonQuery()I still have the same result. There is a complaint on the PHD() line. Here is the exact message followed by the list of commands:
File 'phd.prg' does not exist. EXECSCRIPT("SET SAFETY OFF") EXECSCRIPT("SET EXCLUSIVE OFF") EXECSCRIPT("CLOSE ALL") EXECSCRIPT("USE d:\www\foxpro\Thread IN 0") EXECSCRIPT("SELECT Thread") EXECSCRIPT("SET LIBRARY TO D:\WWW\PHDBASE ADDITIVE") EXECSCRIPT("PHD('MSGLEVEL NONE')") EXECSCRIPT("PHD('IXAUTO OFF')") EXECSCRIPT("USE d:\www\foxpro\Thread IN 0") EXECSCRIPT("SELECT Thread") EXECSCRIPT("SEEK 1238754 ORDER TAG Numero") EXECSCRIPT("SCATTER MEMVAR MEMO") EXECSCRIPT("USE (d:\www\foxpro\THR2007.DBF) IN 0") EXECSCRIPT("SELECT(THR2007)") EXECSCRIPT("APPEND BLANK") EXECSCRIPT("GATHER MEMVAR MEMO") EXECSCRIPT("PHD('IXADD')") EXECSCRIPT("USE IN (THR2007)")The path to PHDBase is specified. But, the error comes from the next line.