>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 >endif > >>