Question

Postgresql Error

15:27 Jun 25, 2020

Hi,

I have construct this select query in script task and got the attached error !

var UserConnection = Get("UserConnection");

var mangager = (DataValueTypeManager)UserConnection.AppManagerProvider.GetManager("DataValueTypeManager");

var currentDate = DateTime.Now;

var select = new Select(UserConnection)

               .Column("Id")

               .From("UsrAlpha")

               .Where("UsrStatusId").IsEqual(Column.Parameter("82f4864d-3c3b-46a7-93dc-318695dc90ec")) as Select;



var up = (Update) new Update(UserConnection,"UsrAlpha").Set("UsrCurrentDate",Column.Parameter(currentDate)).Where("Id").In(select);



up.Execute();

return true;

Please help !

Many thanks.

1 comments

Grigoriy

22:44 Jun 25, 2020

In 7.15 with PostgeSql this code work

Guid contactId = ......
Select select = new Select(UserConnection)
				.Column("ScpSNILS")
				.Column("INN")
				.From("Contact").WithHints(new NoLockHint())
				.Where("Id")
				.IsEqual(new QueryParameter(contactId)) as Select;

Change Column.Parameter to QueryParameter

Show all comments