Im trying to sort a column of numbers that are strings and I’d like them to sort numerically. The catch is that I cannot convert the numbers into int. Here is the code: therefore it does not show me the highest because it is of type nvarchar foreach (var ttUD31_Recs in (from ttUD31_Row in ttUD31 …

I think you will have to do it in two steps. int intKey1 = System.Convert.ToInt32(UD31_Recs.Key1) + 1; Key1 = intKey1.ToString();

Lets step back a bit. Why? What are you doing? Do you have control over the data that is written to UD31? If so, I would be duplicating the Key as an INT to a numeric field and do the sort on that instead. There is really no good way to do what you are doing efficiently.

I have a ud form that increases each time a record is added. But every time I want to bring to the last record, that is, the maximum value. I can’t get it and therefore the sequence is incorrect [ss]

It doesn’t really matter that I duplicate as I only have test records

Unless you want pain, I would go ahead and duplicate they Key1 to a numeric field, or change your key to something like a guid and use the numeric field as your ticket number. Do the sort on the numeric field. If you have existing data, just write a quick procedure to write the numeric field from …

or use YYMMDDhhmmss as a sting into Key1 and then Number01 as the ticket number.

number 01 is of decimal type, how can I convert from integer type to decimal or be able to call a column created from the c# code of the bpm

I have been out of practice on my linq queries… but hopefully this is close. What I did was create a LIST of records, and then sorted that list and returned the top item. var UD31_Recs = Db.UD31.Where(x=>x.company == Session.CompanyID) .Select(x=>new {int myInt = System.Con…

[image] E_coatlicue: how can I convert from integer type to decimal or be able to call a column created from the c# code of the bpm That’s not a problem back in .net / c# land. A decimal field should just take an integer. To convert it back just use Convert.ToInt32(decimalfield).

[image] timshuwy: What I did was create a LIST of records, and then sorted that list and returned the top item. The way that query is written, will bring in all the records that match the company, and then sort after the fact. If there are a lot of records, this can be a big problem.

Convert nvarchar t

Epicor ERP 10

klincecum (Kevin Lincecum) June 27, 2023, 10:14pm 13

I may have spoken too soon.

I just realized we had a similar discussion before:

Topic		Replies	Views
Convert nvarchar UD column to either string or integer throws error Epicor ERP 10 bpm	4	1735	August 3, 2020
Setting UD Table Key using C# Expression failed on Convert.ToInt32 Epicor ERP 10 e10	4	1568	February 21, 2019
UD Table Relations - data type error - Number of Rows in xxx query Epicor ERP 10 bpm	14	1899	August 17, 2020
Order by a string within Select Epicor ERP 10 orderby	2	497	April 1, 2020
C# Code UD Table Sort - Help Needed Epicor ERP 10 bpm	5	1079	May 6, 2021

Convert nvarchar t

Related topics