Re: [amibroker] An example UPDATE

[Joe Landry]

Hi Tomasz:   Thank for taking time out from what must be a very busy schedule.  I just saw the work on Forex.  The breadth of the product continues to impress me.   I know this was simple but I couldn't get it and this removes one more hurdle.  It does read like the DML statements in the tutorials  - as it should since Access is processing this.  It's the syntax of the single quote, double quote and the + signs that was (and still is) throwing me off.    Where could I learn more about this or is this specific to the way you wrote the function?      Best personal regards Joe ----- Original Message ----- From: Tomasz Janeczko To: amibroker@yahoogroups.com Sent: Saturday, August 12, 2006 5:53 AM Subject: Re: [amibroker] An example UPDATE 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. __,_._,___