When is the new vers coming out?

Excited!

Thanks

Here is a very basic example of an SQL connection with a dsn-less connection to a Microsoft SQL Server.  (pvxplus 21)

This is through windx and for reference on linux but should work elsewhere.

I had great difficulty with the documentation finding this so I hope it can be updated for this simple case, I hope this helps someone I found numerous mailing list tips ideas on this and I wanted to just summarize it all to a very simple real world example.

SQL_Server = CONSTRUCT-SQL
SQL_Database = Artcraft_Machines
uid = SQL user id
pwd = SQL password

SQL_Table = scm_artcraft

Now because I specify "uid" and "pwd" in the connect string with the OPT=  We do not have to pass the different syntax of USER=abc, PSWD=def on the Open.  If you do not specify in connect string then you must use this USER/PSWD syntax on open.

Also it's critical to pass "ignore;"  as the first parameter on the open as it just skips this because we are using a connect string but you still need it on the open as a padding.


0010 begin
0020 !
0030 let OPT$="CONNECT='Driver={SQL Server};Server=CONSTRUCT-SQL;Database=Artcraft_Machines;uid=artmachine;pwd=artmachine'"
0040 open (1,iol=*,opt=OPT$)"[lcl][odb]ignore;scm_artcraft;Key=Code" ! ;USER=artmachine;PSWD=artmachine"
0050 !
0060 select * from 1
0070 print CODE$,"   ",THICKNESS,"x ",WIDTH," x ",LENGTH
0080 next record
0090 !
0100 print lst(iol(1))



There was also notes of using {SQL Server Native CLient 11.0} instead of {SQL Server} or whatever vers I think this is needed, I assume based on windows versions.  This may differ based on your SQL version.  But for me I was just trying a regular Microsoft SQL Server.

If using ED+  and have 2 programs loaded with tabs, is it normal that it always goes back to top of the program when switching tabs? 

*IT worked fine through windx,

PS.  I just tested a local windows PVXPLUS and it holds the position as expected... Is this an ED+ bug through windx?  Latest pvxplus 21 on Linux!

Thanks?

With the newest pvxplus 21.00 I'm noticing certain panels when processed from within other panels do not retain the default background (library defaults) and return to white.  I can send you a test scenario, just want to know if this isn't already known.

New Query acting strange..

Hope this picture is clear.

It's only occurring on some file queries as well...

Tried the new Maintenance Generation, always get an error #26 at end

*win/fm_wiz_regen

0024 if vis(element$)<>"" then let template_string$+=element$+"="+vis(element$)+$01$


Quick debugging shows ELEMENT$ was "iolist SETTING$"

This is after clicking FINISH.

Nice website refresh!

I'm going to miss the baby Mike King on the laptop though.

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?

Noticing defunct processes when using pipes since new pvxplus upgrade.  I found the 'WP' parameter helps.

So I set_param 'WP'=1 as my default.

Just I have one weird scenario.  with this TAC if I dont set 'WP'=0 the close will hang indefinitely.

So after a few experiments I got this to work:

! This opens the logfile

OPEN:
let PRODLOG=unt; open (PRODLOG,err=ERROR)"< tac /tmp/albertibuffer_ProdErr.csv 2>/dev/null"

READ_CYCLE:
! Do my READ (PRODLOG) loop, I only want a certain # only (so tac stays incomplete)

DONE:
set_param 'WP'=0 ! PVXPLUS setting to wait for pipe to end
if PRODLOG then close (PRODLOG); let PRODLOG=0
wait 1 ! This clears zombie
set_param 'WP'=1 ! PVXPLUS setting not to wait for pipe to end affected old <date routines but lets see if this causes issues
wait 1 ! This one ACTUALLY Clears Zombie


Do I really need this Apollo 13 ending sequence?

Maybe I should use a different routine to simplify it just I am used to using pipes like this with old PVX 5.14 with zero issues.

Thanks

Just reading about SVN does this work with Linux pvxplus?  I get an error #99 but I dont have anything setup yet.

Thanks

Seems to be a bug in the *tools/makeqrcode

works fine if you don't pass quality level (L,M,H) if you do I get a html dump response.

0020 call "*tools/makeqrcode","ABC123","/tmp/qrtest.png","H"

looks like server end may be an easy fix for you.

error 201

1:?msg(201)
Invalid response: '<html>
<head>
<meta http-equiv="Content_type" content="text/html">
<title></title>
</head><body>
Error▒has▒occured:<br>
ERR(Err)............12<br>
ERR(Erx)............120000<br>
ERR(Ret)............258<br>
ERR(OSerr)..........<br>
ERR(Program)......../home/pvxplus/public_html/qrcode.pvp<br>
ERR(EntryPoint).....0<br>
ERR(Stno)...........39<br>
ERR(Obj)............0<br>
ERR(Method).........<br>
ERR(Lfa)............60<br>
ERR(Lfo)............61<br>
ERR(LastPath)......./tmp/00135434.png<br>
ERR(LastKey)........<br>
ERR(Module).........pvxopn.c<br>
ERR(Line)...........145<br>


more debug stuff but seemed like not necessary.

Thx

Why do spawned WindX session come up with the "Settings" Icon.  Is there a way to change the icon reference on spawned windx sessions?

I'm using *windx.utl;SPAWN  even if I pass the ini file with the same as the initial windx connection it doesnt seem to take it.  So my primary window has the correct icon but any spawned sessions have a 'settings' icon.

I have 5 folders, and the second folder say folder "B" I want a different panel to be there based on certain conditions on entering the main program.

I used to be able to easily set _F_OBJ$[2,0]="NEW_FOLDER.FD2"  (I want an entirely new Nomads panel there not just switch tabs)

However this is no longer possible.

I am trying to use FLDR'GetPanelNames$() and FLDR'SetPanelNames$() I am struggling to figure out when or how this works as it just isn't working for me.

$01$+"FLDR1"+$01$+"FLDR2"+$01  It just doesnt seem to save it.  I tried a FDLR.ReDraw() and it seemed to do something but not what I want.

If I find the answer I'll post.  Right now I am stuck.  Thanks

Forum Search too strict. 

The 5 second rule is too harsh, can this be eased up maybe after 3 consecutive searches or something.

I find myself playing a game to do searches here.

Hi, Is there an actual updater that updates windx itself on a clients machine from an older windx?  or is it only custom files such as static/dynamic pictures that is used for this auto updater?

"AutoUpdater to automatically check for and install critical patches/upgrades on all client workstations"

I see nothing in the documentation how this works?  Thanks

Hi I was just wondering what is in store for the future of PVX PLUX?  Will there still be yearly developments?

Hi thanks for releasing pvxplus 2023.

No luck with Ubuntu 22 and openssl still I need to assign:

export PXP_SSL_LIB=/usr/local/lib/libssl.so.1.1
export PXP_CRYPTO_LIB=/usr/local/lib/libcrypto.so.1.1

And I now am getting a new error:

Could not locate entry point 'OSSL_PROVIDER_load' in libcrypto library.
Likely an incompatible SSL Interface. (err/ret=2/2)


Do I need to install OpenSSL 3.1 for this to work?

Thanks!

Read the notification from Jonas software.  So how does going with Jonas help push providex to move forward with new technology?

Pvxplus 2023? Coming soon?  Can't wait!!   

Hey Everyone.  With the Ai craze going about.  I was wondering how this can tie into anything PVX Plus related. I haven't done anything personally other than play with Chat GPT but I was wondering how we can use some of these tools in future or what not.  Just curious!  Thanks for any thoughts.