Issue with Executing Data base query

Help Studio
1

Hi Team,

my Query was this
query ="INSERT INTO WebsiteUsers

        (SiteID,

        WebsiteUserID,

        CustomerID, Email, FirstName, LastName, LanguageCode,

        SaltKey, Password, PWHashVersion, Phone, WebsiteUserStatusID, VisibleItems,

        WebsiteUserLevelID, DefaultShippingMethodID, DefaultPaymentMethodID,

                              DefaultBillToAddressID, DefaultShipToAddressID, ShipToAddressID,

                              OkToEmail, InkSoftUserID, RegisterDate, RememberLogin, RememberAsked,

                              Notes, HourOffset, TimeZoneAbbr,

        Role_Users,          Role_History,    Role_Order,       Role_Pricing,     Role_Inventory,               Role_AccountStatement, Role_MarketingFunds, Role_Integrations,

        WebUserRoleID, gclid_Register,utm_campaign_Register,utm_term_Register,utm_content_Register,

        utm_medium_Register, utm_source_Register,

        DirectMail, eCatalogs, Addr1, Addr2, Addr3, City, State, Zip, Residential, CountryCode, LastCookieAgreement)

select

                                                        SiteID,

                                                        NEXT VALUE FOR WebsiteUserID_SNS,

                                                        CustomerID, 'uipath.auto_8_36_01_02@ssactivewear.com', 'ajay', 'bezawada', LanguageCode,

                                                        SaltKey, Password, PWHashVersion, Phone, WebsiteUserStatusID, VisibleItems,

                                                        WebsiteUserLevelID, DefaultShippingMethodID, DefaultPaymentMethodID,

                                                        DefaultBillToAddressID, DefaultShipToAddressID, ShipToAddressID,

                                                        OkToEmail, InkSoftUserID, RegisterDate, RememberLogin, RememberAsked,

                                                        Notes, HourOffset, TimeZoneAbbr,

                                                        Role_Users,      Role_History,    Role_Order,               Role_Pricing,     Role_Inventory,               Role_AccountStatement, Role_MarketingFunds, Role_Integrations,

                                                        WebUserRoleID, gclid_Register,utm_campaign_Register,utm_term_Register,utm_content_Register,

                                                        utm_medium_Register, utm_source_Register,

                                                        DirectMail, eCatalogs, Addr1, Addr2, Addr3, City, State, Zip, Residential, CountryCode, LastCookieAgreement

                                                        from WebsiteUsers

                                                        where email='uipath.auto@ssactivewear.com' and siteid=1;"

I’m getting issue with run this script can you anyone help me this issue. please share the example Xaml file it’s really helpful to me

Regards
Sai

2

@Mada_Sai_Krishna,

Please specify the error you are getting so we can understand and help here.

3

getting this issue

Run command: Incorrect syntax near ‘System’.

4

@Mada_Sai_Krishna,

The query you have shared looks broken here. Could you put it in a text file and share here to analyze.