myconn=sqlstringconnect("driver={Tally ODBC driver};server=local;port=9000") wait wind myconn && showing 1 if myconn<0 wait wind 'error ' nowa retu else wait wind 'Connected' nowa endif myresult=sqlexec(myconn,'select ledger.$name, ledger.$parent from ledger',[mycursor]) wait wind myresult && Showing 1 and brow the data perfect as MEMO field. if myresult<0 wait wind 'Result Error' else sele mycursor && this is showing all the data brow endif myresult=sqlexec(myconn,'insert into ledger (ledger.$name, ledger.$parent) values ([Apple],[Sundry Debtors])) wait wind myresult && Showing 1 but not inserting the data into ledger table. if myresult<0 wait wind 'Result Error' nowa else wait wind 'Record inserted ' nowa endif myresult=sqlexec(myconn,'select ledger.$name, ledger.$parent from ledger',[mycursor]) wait wind myresult && Showing 1 but not showing the records i inserted above. if myresult<0 wait wind 'Result Error' else sele mycursor && this is showing all the data brow endifi think this ODBC connection accept data only in XML format.