Network Automation Software
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: SQL statement help
Topic Summary:
Created On: 09/13/2011 06:36 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 09/13/2011 06:36 AM
User is offline View Users Profile Print this message

Author Icon
DanielGrip
Master (500-999)

Posts: 569
Joined: 11/25/2007

Im trying to store a value from a variable to a table column (smalldate) but I keep getting errors

The variable in this case holds the value "2010-11-08"

The error I get is "Microsoft OLE DB Provider for SQL Server:Conversion failed when converting character string to smalldatetime data type"



 Category Survey



Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)


-------------------------
Daniel Grip
 09/14/2011 04:32 PM
User is offline View Users Profile Print this message

Author Icon
Ricardo Castaneda
HelpSystems

Posts: 3424
Joined: 01/11/2008

Hi Daniel,

Can you please provide a workable sample?


 Category Survey
AutoMate BPA Server 7 version:
Windows version:


-------------------------

Ricardo Castaneda | Principal Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700
 09/15/2011 05:31 AM
User is offline View Users Profile Print this message

Author Icon
DanielGrip
Master (500-999)

Posts: 569
Joined: 11/25/2007

Thansk Ricardo but I managed to figure it out.

 

There were to many % characters surrounding the variable

('%%InkomTelSIMS%%')   NOT WORKING

('%InkomTelSIMS%')  WORKING!



 Category Survey


-------------------------
Daniel Grip
Statistics
18257 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 6686 on 11/01/2020 at 01:24 AM.
There are currently 1128 guests browsing this forum, which makes a total of 1128 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog