Re: [amibroker] An example UPDATE

[Tomasz Janeczko]

odbcExecuteSQL("UPDATE testtable SET fieldone = '" + somevalue + "' WHERE Symbol='MSFT'"); Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: Joe Landry To: amibroker@yahoogroups.com Sent: Saturday, August 12, 2006 12:30 AM Subject: [amibroker] An example UPDATE Hi Tomasz - looks like the odbcSQLExecute statement will UPDATE and DELETE table records.  Would you take a couple of minutes and write an example of an UPDATE for us.   Say one where the key field <  symbol >    is a ticker like ticker = "XOM";       or "INTC". and not current ticker as provided by   Name()  ....   Thanks JOE    odbcExecuteSQL( "sql statement" ) - executes SQL statement This function returns 1 (True) on success, 0 (False) on failure. This function takes string parameter containing valid SQL statement such as INSERT, UPDATE, DELETE, etc, and as such allows write operations on the database. It is not intended to be used with SELECT statements or other statements (stored procedure calls) returning recordsets as it returns only true/false on success/failure. Example: odbcExecuteSQL("INSERT INTO testtable (fieldone,symbol) VALUES ( 'somevalue','"+Name()+"' )"); __._,_.___ 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 other support material please check also: http://www.amibroker.com/support.html YAHOO! GROUPS LINKS  Visit your group "amibroker" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. __,_._,___