georgiadonut
New Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Newid() function
Hello All -- I am very new to TestComplete and am trying to do a database insert using newid() but keeping getting the error "NEWID" is not defined. I've tried various different formatting (single quotes, double quotes, etc) as well as creating a variable to store the uniqueidentifier but always get same error. Is there a special library I need to include to use this SQL function or special formating? Thank you in advance for your help. query = "INSERT INTO "+ProjectSuite["Variables"]["PrimaryDB"]+".[dbo].[Workstations](ID,[LocID],[Name])VALUES('"+newid()+"','"+Project["Variables"]["PrimaryLocID"]+"','"+Project["Variables"]["Workstation"]+"')";Solved2KViews0likes4Comments