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.
