3 things come to mind as possibilities: 1*you are retrieving an array, but maybe you only have one value? 2*you have a space after testtable 3*I don't know if you checked to see if the data made it into the table itself, but you might want to verify that at the (assuming you're using mysql):
mysql > select * from testtable; and see you you get anything. if there is nothing being successfully inserted into the databse, then it would register empty when you query it ----- Original Message ----- From: murthysuresh To: [email protected] Sent: Thursday, September 04, 2008 10:11 AM Subject: [amibroker] strange error when doing odbc connectivity i just inserted the data. i cannot retrieve it. it gives strange error if( NOT odbcExecuteSQL("INSERT INTO testtable (fieldone,somevalue) VALUES ( 'somevalue','"+Name()+"' )") ) { printf("INSERT failed with following message : " +odbcGetLastError () ); } // this data is now inserted into the databse. i verified it. b=odbcGetArraySQL("SELECT fieldone from testtable "); WriteVal(b); printf(odbcGetLastError() ); i get the following error. it just inserted to the fieldone column. {EMPTY} Invalid field name or field index.
