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()+"' )");

Reply via email to