[amibroker] An example UPDATE

[Joe Landry]

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 SPONSORED LINKS Investment management software Real estate investment software Investment property software Software support Real estate investment analysis software 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. __,_._,___

BEGIN:VCARD
VERSION:2.1
N:Landry;Joe
FN:Joe
ORG:Houston Investors Association
TITLE:VP Programs
TEL;WORK;VOICE:281-486-5567
ADR;WORK:;;2222 Cullen;Houston;Texas;77005;USA
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:2222 Cullen=0D=0AHouston, Texas 77005=0D=0AUSA
URL;WORK:http://houstoninvestors.com
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20060811T223005Z
END:VCARD