[amibroker] Re: strange error when doing odbc connectivity

["murthysuresh" <money@xxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx, "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@xxxxxxxxxxxxxxx 
>   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.
>



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

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/