Search found 652 matches

by jyoung
Fri Apr 12, 2019 1:26 am
Forum: Questions & Answers
Topic: ODBC Error Invalid Column Name when adding new Field
Replies: 5
Views: 19032

Re: ODBC Error Invalid Column Name when adding new Field

Ok, so this kinda thing is super frustrating. I removed the Field and was still getting the error. Thinking that something had to be cached somewhere, I killed of all the processes and rebooted the PC. Still same error WITHOUT the Field in the File. All the while I am compiling with the drop / reloa...
by jyoung
Thu Apr 11, 2019 11:20 pm
Forum: Questions & Answers
Topic: ODBC Error Invalid Column Name when adding new Field
Replies: 5
Views: 19032

Re: ODBC Error Invalid Column Name when adding new Field

Hey Chad, I did not think about the collation, after all this is a LANSA created database and LANSA created Table with LANSA created Fields. Nothing changed. I ran the query to check the collation and got SQL_Latin1_General_CP1_CI_AS so it should be case insensitive and accent sensitive. Nothing out...
by jyoung
Thu Apr 11, 2019 2:03 am
Forum: Questions & Answers
Topic: ODBC Error Invalid Column Name when adding new Field
Replies: 5
Views: 19032

ODBC Error Invalid Column Name when adding new Field

I have a LANSA defined table that I am trying to add a Field "LastName" to. The table has data in it that I don't want to loose, I just need to add a column to it. When compiling the Table, if I choose Rebuild Table, Rebuild indexes and views, Rebuild OAMs, the new column does not show up in the tab...
by jyoung
Thu Apr 11, 2019 1:55 am
Forum: Questions & Answers
Topic: Colspan + Rowspan within a #PRIM_LIST
Replies: 3
Views: 5614

Re: Colspan + Rowspan within a #PRIM_LIST

Look into the List Cell Interface
https://docs.lansa.com/14/en/lansa016/p ... design.htm

It allows you to customize the display of an individual cell with multiple fields.

In your case, your second column could contain the panel described by Chad.

Hope this helps,
Joe
by jyoung
Tue Mar 26, 2019 8:45 am
Forum: Questions & Answers
Topic: VLF-ONE Check Availability to Command in custom Instance List
Replies: 2
Views: 6711

Re: VLF-ONE Check Availability to Command in custom Instance List

Ahh, I forgot about that user/object type name.

Will give that a go.

Thanks,
Joe
by jyoung
Tue Mar 26, 2019 2:48 am
Forum: Questions & Answers
Topic: VLF-ONE Check Availability to Command in custom Instance List
Replies: 2
Views: 6711

VLF-ONE Check Availability to Command in custom Instance List

In VLF-ONE the framework manager has an avCheckAvailibity method to check if the user has access to a particular object. I am looking for a way to check if the user has access to a specific Command in that object. Is there anyway to use avCheckAvailablity with Commands? The docs here https://docs.la...
by jyoung
Tue Mar 19, 2019 3:29 am
Forum: Questions & Answers
Topic: VLF-ONE Merging Frameworks
Replies: 9
Views: 5731

Re: VLF-ONE Merging Frameworks

Hey Balaji, By Commands, you mean new command definitions right? Not Command Handlers / Filters. In this case, all the command are already in the framework ( the handlers are not). When I try to merge JUST the Business Objects BEFORE the Application, the Merge Tool does not know what their parent is...
by jyoung
Sat Mar 16, 2019 3:01 am
Forum: Questions & Answers
Topic: VLF-ONE Merging Frameworks
Replies: 9
Views: 5731

Re: VLF-ONE Merging Frameworks

This bit me in the behind yet again. This happens after using the MergeTool. Capture.PNG I added the Application (without the Objects) to avoid the previously mentioned issues. Then added the Objects to the newly created Application. Initially everything looked ok, until a coworker checked it out an...
by jyoung
Wed Mar 13, 2019 1:19 am
Forum: Questions & Answers
Topic: VLF ONE #PRIM_MD.Input caption styling
Replies: 5
Views: 5253

Re: VLF ONE #PRIM_MD.Input caption styling

I would like to know how to do this as well. I find Theme customization super confusing. Between the ThemeCustomizer(VF_AC033O), VLWeb(PRIM_THM) and the Framework itself, its hard to know which to use and when. EDIT You can change the caption color with capture.png But I can't figure out how to do i...
by jyoung
Sat Mar 09, 2019 1:29 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4766

Re: Decimal / Percent Conversion and Display

Ahh, I thought it may be a javascript thing. I submitted a support ticket because it was driving me crazy. I'll add your info to it. It dawned on me late last night, that I can do the conversion on the server and avoid the issue. Management is concerned that a user may mis-enter a decimal point whic...
by jyoung
Fri Mar 08, 2019 8:40 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4766

Re: Decimal / Percent Conversion and Display

Put this in a server module begin_com role(*EXTENDS #PRIM_SRVM) srvroutine name(Get) field_map for(*OUTPUT) field(#BPU1) #BPU1 := 1.14 endroutine end_com Then this in a web page begin_com role(*EXTENDS #PRIM_WEB) theme(#SYS_THEME<MaterialDesignBlue>) define_com class(#BPU1.EditField) name(#BPU1) dis...
by jyoung
Fri Mar 08, 2019 8:32 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4766

Re: Decimal / Percent Conversion and Display

Response from the server shows the right values.
capture4.PNG
capture4.PNG (15.87 KiB) Viewed 4751 times
by jyoung
Fri Mar 08, 2019 8:29 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4766

Re: Decimal / Percent Conversion and Display

In this instance CurrentBPU1 should not be relevant. It is used in a diff calculation later. It is defined as a reffld of BPU1 define field(#CurrentBPU1) reffld(#BPU1) BPU1 & 2, wk_Percent1 & 2 are the only fields displayed. From your MESSAGE_BOX_ADD, I assume you are using VLWIN, whereas I am in VL...
by jyoung
Fri Mar 08, 2019 7:15 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4766

Re: Decimal / Percent Conversion and Display

That was going to be my next move. I was trying to avoid it as when the user enters a value, I am going to have to do some checking to ensure only numbers are entered. Easily enough done, I was just wanting to avoid it if I could. The calculation should not require rounding. When I tried it with the...
by jyoung
Fri Mar 08, 2019 5:58 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4766

Decimal / Percent Conversion and Display

I have two fields (BPU1 and BPU2) that are a signed(7,6). For display and data entry purposes I need those fields to be a whole percent. To do so, I have created a new field (wk_Percent1 and wk_Percent2) both of which are int(4). I calculate the percentage using wk_Percent1 = BPU1 * 100 so that .140...
by jyoung
Wed Mar 06, 2019 1:09 am
Forum: Questions & Answers
Topic: Ancestor fields in group_by and def_list
Replies: 6
Views: 2718

Re: Ancestor fields in group_by and def_list

This is been accepted as a correction to be released in a future EPC.

Thanks,
Joe
by jyoung
Sat Mar 02, 2019 5:15 am
Forum: Questions & Answers
Topic: Object Equality
Replies: 2
Views: 1508

Re: Object Equality

That is what I was looking for.

Thanks!
by jyoung
Sat Mar 02, 2019 2:36 am
Forum: Questions & Answers
Topic: Object Equality
Replies: 2
Views: 1508

Object Equality

If I define an object as such function options(*DIRECT) begin_com role(*EXTENDS #PRIM_OBJT *LISTFIELDS #ListFields) group_by name(#ListFields) fields(#HVBTC #HVPLCN #HVPLD #wk_Bool1) define_pty name(TypeCode) get(*AUTO #HVBTC) set(*AUTO #HVBTC) define_pty name(ControlNumber) get(*AUTO #HVPLCN) set(*...
by jyoung
Sat Mar 02, 2019 2:07 am
Forum: Questions & Answers
Topic: Ancestor fields in group_by and def_list
Replies: 6
Views: 2718

Re: Ancestor fields in group_by and def_list

Done. I'll post their response when I hear back.

Thanks,
Joe
by jyoung
Fri Mar 01, 2019 2:15 am
Forum: Questions & Answers
Topic: Ancestor fields in group_by and def_list
Replies: 6
Views: 2718

Re: Ancestor fields in group_by and def_list

In the ancestor, they are just fields so I can add them in the group by Here is a test of the ancestor (TestBasePanel) function options(*DIRECT) begin_com role(*EXTENDS #PRIM_PANL) DisplayPosition(1) Height(270) Left(0) TabPosition(1) Top(0) Width(500) LayoutManager(#Layout1) define_com class(#PRIM_...