Hey, I was having an issue with this but with GET_STR$

I see now if I pass GET_STR$(X$,1)  It returns null and no longer errors out. 

If I pass GET_STR$(X$,0) and X$ was not found in the data, the the error 11 isn't trapped

a serious error in: json.pvc 0484 error 11 results.  Shouldn't that  be trapped either way or did you want a hard error there?

Shouldn't the ,DOM=*NEXT   directive work there or?

Thanks for clarifying.

PvxPlus is here and continuing to develop! They just released ver 22!

Yay! Thank you

Thanks for that SYSTEM_HELP PRINT.  I never knew of this neat PDF print trick interesting... Interesting it used my adobe printer default rather than windows printer.  I'll have to play with this some more.

EDIT: This simulates right clicking pdf and selecting print

You can open the pdf then have them manually print it.

Another way is quite involved:

invoke wait "[wdx]"+quo+EXE$+quo+" /h /n /t "+quo+F$+quo ! +" "+quo+"Microsoft Print to PDF"+quo

EXE$ = executable
F$ = File

You need the EXE for acrobat reader may be able to read registry.  Or can set executable manually.

check for executable

let CC=unt; open (CC,err=*next)"[wdx]C:\program Files\Adobe\Acrobat DC\Acrobat"; close (CC); let EXE$="C:\program Files\Adobe\Acrobat DC\Acrobat\Acrobat.exe";


I think you should try to fix the print (OUT) of your report.  Are you sure you have the correct sequence of 'DF' mneumonics, you should be able to get them to match.

print (REP)'font'("Arial",-12),'DF','cpi'(10),'lpi'(6),

When is the new vers coming out?

Excited!

Thanks

Probably a windows thing which windows?  Do you have full line highlight on?

But if your logs show fine from postman then it must be able to communicate with external.

Does by chance the linux have some sort of firewall that is blocking, you should be able to trace that.

Where is the server hosted, is this a firewall issue at this point since postman can get in?  postman is coming in on https?  if so your key is fine then

If you are concerned if the web server is even active, you should be able to hit it from the local server?  Is this windows or linux

Hey I use the pvx web server you need to do the following:

cat privkey.pem fullchain.pem > pxplus_key.pem

and point your webserver to that SSL pxplus_key.pem everything will work then

Then restart the web server.

PS.  If you are running from an ssh you may find error messages displayed on the main console only, so if you are running Virtually see if u can access console.

The problem are the spaces in the MSGBOX, Remove them and it will work.

msgbox "Test","Test","?,BTN1=Summary, BTN2=Detail, BTN3=Cancel,3",x$
To

msgbox "Test","Test","?,BTN1=Summary,BTN2=Detail,BTN3=Cancel,3",x$

Any luck? if every other file is working it shouldn't be too hard to figure out where the problem is?  field names? file path location? keys?

I need to add a few more important notes I came across:

The above works great for a simple single connection however if I wanted to have multiple individual channels open at once for various tables then a number of changes have to be done.

#1 I had to install the latest SQL ODBC driver from microsoft Search: ODBC Driver for SQL Server"  At time of this writing it was 18.4.1.1  After you install this you will have a new Driver data source named:

'ODBC Driver 18 for SQL Server'

let OPT$="CONNECT='Driver={ODBC Driver 18 for SQL Server};Server=CONSTRUCT-SQL;Database=InSight;TrustServerCertificate=yes;MARS_Connection=Yes;uid=artcraftinsight;pwd=insight'"
#2 A few key Added options were needed at least for my case.

MARS_Connection=Yes

is the important one which allows multiple requests at one time.

TrustServerCertificate=yes (This was for my setup)

If you are not passing a user name for a trusted connection add: ";Trusted_Connection=yes"

After I did above I could create as many concurrent opens to the SQL Database as I needed.

Hope this helps.

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.