Visual LANSA Forum

You need to use SQL to read or write BLOB's in RPG. Are you trying to read or write?

Thanks David. Everyone always says the IDE is written using LANSA but they still haven't convinced me. If I can get an answer to this that would help

Art

I have this form where a user can rearrange the order of the labels. If the user presses the up or down button how do I make the mouse pointer follow it? The IDE does it when working with Layout Rows. I can move the focus to each button but that doesn't move the pointer. fcolumns2.png This is how th...

Probably like this:

mthRoutine uLoadMe
define_map for(*input) class(GOPMID) name(#Migopmid)

* use #Migopmid

endRoutine

Thanks Rene. I can't see any other fields in my loaded file though. Only the available columns are in there.

Hi Rene: Were you able to figure out anything? I've been waiting over a week for LPC.

Hi Rene: I asked support here in USA to find out over a week ago. I have no answers yet. I emailed John Bo again today what is the status.

Anything you can find out would be great. Thank you very much.

My case# is 00805878

It is all of my files actually.

The fields are a mix of numeric and character. The files were developed probably back on V2 of OS/400 so there are no date types, blob’s, etc

The silence was deafening.

I haven't had any luck getting answers from support. I want to know what "Available columns" message means. Is LPC on their normal christmas vacation in August?

Can I change the style of one cell when they mouseover in a PRIM_ LIST? I've played with columnmouseenter but I haven't been succesful getting the row the user is in.

Thanks

When the user clicks the clear button i have to reset some other inputs, buttons, etc

I’ll try the clear counter thing. Thanks

Is there a way to capture an event for when user clicks the clear button (the X at the end of the box). Keypress perhaps?

Thanks, Art

Has anyone seen this before? Support in N.America says they can import my file normally. Other than that they have no explanation.

Thanks

I found my problem but not my solution. My other files indexes/logicals aren't showing all the column values. The physical is. I checked the definiton of the logical and it shows "Columns available". What does this mean? availablecolumns.png These are old DDS defined tables. The physical and logical...

I'm seeing possibly that server modules are reading other tables incorrectly. Some fields aren't returned. Windows works fine though. I heard this might have been seen before?

As i said this is a new install. I checked some other load other files and they look ok.

For another test, I right clicked the table in the IDE and loaded records. I went into SQL Management and the data is OK on the PC.

I applied the EPC and reloaded the file. Same issue. Waiting to hear from support.

No I have no EPC’s . I’ll get them. Thanks

I created a new v15 petition, did a load other file from IBM I. The data shows as corrupted. The numeric customer number is negative . The name doesn’t come through at all. This was on vl-web and same results from vl-win. I’m going to submit an incident hoping someone else knows if this is a fixed b...