Martin

The VSCode extension does require a PxPlus installation and so is Windows only at the moment (I suspect it uses either the .exe or the COM interface to check for syntax errors)

A demo-activated PxPlus is enough though. That's what I've been using since the Software Developer license got cancelled and I was able to use the VSCode extension. I also saw the expiration nag messages when running VSCode so that's why I suppose it needs the interpreter to interface with the language server...

Thanks!  Is there an interim solution we can use like a development key to the local PC or something?

Is there a real need to even link to a licensed pvx?  I just wonder because it cant really run pvx right? just read/save.. Doesnt the demo pvx plus allow same function?  or am I missing something.

Hi Deven, my field contains hexadecimal characters and i think that is causing problem.  than you for clarifying for me.

thank you Deven - so it doesn't seem to be working for me.
i'll try again ...thank you.

The VS Code Extension needs to be given the path to an active PxPlus executable not the activation file. In this first version you can't point it at a remote PxPlus to use it.

We are looking into that as a feature we can add in a update.

Yes it is the offset in the field.

Based on that ini setting it seems that the ODBC will ignore the data in the file for the first 5 characters and then treat the next 9 as the field.

I would consider Offset to be where we start in string like in a mid function
let if string is
JEFFREY-JONES
Offset = 4
Length = 3
and i say offset is 4 (assuming 0 based then) i would expect it to return
"REY"
where the "R" is in the 4th position (0 based) and then go over 3 characters...
is that what the Offset is?

Hey for the license type how can I point this to our linux server, do I have to share the ACTIVATE.PVX through samba ?  This safe?

Nevermind guys!
Ado is working well with chrome, its just the command "print" doesnt show anything but i can display information to a multiline or msgbox just fine.

So I guess im set for now, thanks!!!

This is the final product:

00041 LET CHAN=HFN
00042 MULTI_LINE READ MULTILINE.CTL,Y$
00043 OPEN (CHAN,OPT=";USER=pvx;PSWD=pvx123@123@;Connect='Provider=SQLOLEDB;';CONCURRENCY=LOCK;EXTROPT=(UPDLOCK)")"[ado]SADI\SQLEXPRESS"
00044 READ (CHAN,KEY="!SELECT [ITEM_ID],[ITEM_NAME],[ITEM_DESCRIPTION],[ITEM_ID_ORIGINAL],[LAST_UNIT_COST] FROM [WMPOS].[dbo].[D_INVENTORY] WHERE ITEM_ID_ORIGINAL ='"+Y$+"'")C1$,C2$,C3$,C4$,C5$
00045 PRINT C1$
00046 PRINT C2$
00047 PRINT C3$
00048 PRINT C4$
00049 PRINT C5$
00050 PRINT "========================================="
00051 CLOSE (CHAN)
00052 RETURN

It works wonderful because I input the internal code in the screen and run the code and it prints the info about the internal id.

Runs smooth!!! Finally....

However when I tried to run that same window via inomads it did not run nor it gave me any errors.

What changes do I have to make to inomads so that it can run, I use EZWeb Server on local network and google chrome.

THANKS GUYS!