[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] odbc date


  • Date: Mon, 15 Mar 2010 21:13:20 -0700
  • From: "Chris DePuy" <cdepuy@xxxxxxxxx>
  • Subject: [amibroker] odbc date

PureBytes Links

Trading Reference Links



I am trying to write a date into SQL in .afl using odbcExecuteSQL command.  I cannot recall an easy way to do this unless I were to use string manipulation.  Is there an easy way to complete the DATE-GOES-HERE part of my second insert command?
 
The following works great, except it doesn't include date:
 
odbcExecuteSQL("INSERT INTO trades (price,SYMBOL) VALUES( '"+C+"','"+Name()+"' )");
 
I want
 
odbcExecuteSQL("INSERT INTO trades (DATE,price,SYMBOL) VALUES (?DATE-GOES-HERE?? '"+C+"','"+Name()+"' )");


__._,_.___


**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/





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

__,_._,___