Visual LANSA Forum

thanks for the info so far but i'm still stuck.

i'm using chrome and brave, and occasionally firefox as my testing browser. brave isn't officially on the list (although it's running a chromium engine) so i've switched primarily to chrome

when i run the #pushManager.Query method, the .Changed ...

Is there an equivalent "delete" function that would work with a variable parm as the from file name?
I don't see a delete_sql?


i've had mixed success with non-SELECT statements. i've done UPDATEs, INSERTs, and DELETEs but they don't always work for me. i chalk it up to something in the SQL ...

in an RDMLX world, there is an additional option of using the #PRIM_IOC.xxx primitives. they're a little more complicated to use but they get the job done.
you can also use #XPRIM_FILE objects to do a lot of stuff.

honestly, the BIFs work just fine and are probably more familiar. but if you need ...

not in an RDML or standard SELECT statement.

you can do this with SELECT_SQL, RDMLX only , with the USING parameter.

the upside: a heckuva lot of flexibility
the downside: repository features basically gone

for your use case (looking for record counts) it could be fairly easy:

MTHROUTINE ...

I've been trying to get these to work on the web with no luck.

I've gotten the VapidKey to work on the server side (note: documentation has a minor typo, where they refer to the primitive as PRIM_CAP instead of PRIM_CAP I under 23.3 Developing Push Notifications / PRIM_CAP.PrivateKey ...

it doesn't sound strange. kinda goes along with the quirkyness of the ExcelService

here is what i've found so far:

it seems like formatting is a once and done thing - once i applied a style, additional styles didn't do anything. i can set color on a column, but can't later set the horizontal ...

yes to the questions... mostly.

i set context right after the sheet was created

i didn't initially have the CLOSE but added it after seeing your suggestion.

i did some re-arranging of the code after working with a coworker... originally my WRITE statements were done first, followed by the ADD ...

i've been fiddling around with the excel service and am having a heckuva time getting formatting to work.

example:

#JSMXCMD := 'ADD OBJECT(*CELLSTYLE) COLUMN(1,17) RANGE(1,1) BACKGROUND(*BLUE)'
USE BUILTIN(jsmx_command) WITH_ARGS(#JSMXHDLE1 #JSMXCMD) TO_GET(#JSMXSTS #JSMXMSG)

i've tried this ...

interesting.

when we applied 060, a bunch of "invalid pointer" functions started coming up - usually calls from RDML to RDMLX functions.

recompiling the proc/fctns seemed to fix the issue but that's something i've never seen before.

i'm not a COBOL guy (nor do i play one on TV) but i assume that it would be the same as any other external program call. you need to make sure your library list is correct but:
LANSA REQUEST(RUN) PROCESS(pppppppppp) FUNCTION(fffffff) PARTITION(xxx) should work.
(you may need to be able to call the ...

i know it is pretty fresh off the presses, but i'm curious if anyone has applied it yet. and if they have, have there been any issues on the update?

will there be documentation and/or code samples when it's released?

i've been working on a web project that has a lot of dynamic pick lists. and these are really slowing things down - load times for the page are terrible.

doing a performance capture, i've isolated things down to about a half dozen that are serious bottlenecks. i've figured out a way to speed ...

this is definitely something for me to look in to. i'm only familiar with the XPRIM object (which we used when 14.2 was released).

is this something from later in the 14.2 or perhaps 15.x cycle?

do these kinds of speed improvements translate to a windoz environment? and is there a writer side ...

i was a little afraid of that re: only in memory.

it does eliminate one of the possible explanations.

we will have to research on the defining the cell.

getting a weird error message that in 24+ years, i've never seen:

saying something about "tree already in use. too late to use."

but the error resolves back to a DEFINE_SPACE_CELL

do space objects by any chance get stored somewhere while they are in progress? e.g., a temp folder?

i upgraded to 14.2 a few days ago and don't even see version control as an option. is this going to require a whole new install or is there another way to get this feature added?

i put in a ticket a while ago - and am waiting on some sample code.

however, it sounds like they are doing some significant redesign of how this stuff will work in the future.

has anyone gotten the new webservices in 14.2 to work? i've been playing around with trying to kick the tires on it and am having some issues trying to get them to work.

the documentation for consuming webservices (available in EPC 141070) is great but there is nothing about the new API ...

add to this a wish that debug delay time would be retained between sessions. kind of annoying to have to set back it to 50ms every time i restart the IDE.