1. there are lots of rows in that table. 2. i removed the space after testtable but does not change the result 3. following is the row count.
mysql> desc testtable; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | somevalue | varchar(20) | YES | | NULL | | | fieldone | varchar(20) | YES | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.03 sec) mysql> select count(*) from testtable ; +----------+ | count(*) | +----------+ | 2571 | +----------+ 1 row in set (0.00 sec) --- In [email protected], "Chris DePuy" <[EMAIL PROTECTED]> wrote: > > 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. >
