[amibroker] strange error when doing odbc connectivity

["murthysuresh" <money@xxxxxxxxxxxxxx>]

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.
 




------------------------------------

Please note that this group is for discussion between users only.

To get support from AmiBroker please send an e-mail directly to 
SUPPORT {at} amibroker.com

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/