Re: [amibroker] strange error when doing odbc connectivity

["Chris DePuy" <cdepuy@xxxxxxxxx>]

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

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___