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 amibroker@xxxxxxxxxps.com,
"Chris DePuy" <cdepuy@xxx> 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: amibroker@xxxxxxxxxps.com
> 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.
>