Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Designer & Simulator

Author Message
 Post subject:
PostPosted: Wed Feb 15, 2006 3:20 pm 
Offline

Joined: Fri Jul 23, 2004 2:50 pm
Posts: 59
Location: USA
Two character fields each contain a date in the format of '02/14/06'. <br> <br>A section of the VALUES statement: <br>VALUES <br> ('F', <br> '@START_TIME', <br> '@ST_AM_PM', <br> CTOD(@START_DATE), <br> '@END_TIME', <br> '@END_AM_PM, <br> CTOD(@END_DATE),... <br>results in: <br>VALUES <br> ('F', <br> '730', <br> '1', <br> CTOD(), <br> '730', <br> '2, <br> CTOD(), <br> <br>Why is the insert command trying to insert 'CTOD()' in place of the date 02/14/06? <br> <br>Thanks again for the response...


Back to top
 Profile WWW 
 
 Post subject:
PostPosted: Wed Feb 15, 2006 3:35 pm 
Offline

Joined: Tue Mar 18, 2003 5:52 pm
Posts: 54
Location: Canada
'2, <br> <br>should be <br> <br>'2', <br> <br>Hint: Create test statements with your DB interface environment when you get stuck. Copy / Paste faulty statements into it to debug, and then update TeleFlow. <br> <br>Good luck!


Back to top
 Profile WWW 
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Designer & Simulator


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Style by Midnight Phoenix & N.Design Studio
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.