Recent posts

#1
Programming / Re: Open, Read, Write/Update t...
Last post by nrh7 - Today at 10:02:46 AM
Neat, I'll try that thanks!
#2
Language / Re: SVN Linux?
Last post by martinp - September 11, 2024, 11:06:42 PM
So I tested this on a local version of PVX PLus on windows with a demo key, and it seems to get past where I am stuck does this not work on Linux through windx?
#3
Language / Re: SVN Linux?
Last post by martinp - September 11, 2024, 08:37:15 AM
Should I submit a ticket I really cannot get SVN going..   It keeps looping environmental setup box after I provide a start_up.svn as if it doesn't accept that file.

My PVX is on a linux server.
#4
Programming / Re: Open, Read, Write/Update t...
Last post by Devon Austen - September 10, 2024, 02:57:22 PM
You can execute SQL directly via the WRITE RECORD:

WRITE RECORD (CHAN) "INSERT INTO table_name VALUES (value1, value2, value3)"
#5
Programming / Re: Open, Read, Write/Update t...
Last post by nrh7 - September 09, 2024, 10:19:28 AM
Ok, stuck again  :o

I'm using the following code to read data from SQL Server DB using ADO:
READ (CHAN,KEY="!SELECT [ITEM_ID],[ITEM_NAME],[ITEM_ID_ORIGINAL] FROM [WMPOS].[dbo].[D_INVENTORY] WHERE ITEM_ID_ORIGINAL ='"+VALUE$+"'")F1$,F2$,F3$

Works well, it brings the item data, now I need to modify say, the name variable ITEM_NAME, how can I write/remove from SQL DB using ADO?

I tried to use the UPDATE SQL command instead of SELECT but it doesn't work.

I can read already, I need to be able to:
Write New Record
Update Existing Record
Delete Record

Thanks for the help team!
#6
Language / Re: Disable LISTing on some us...
Last post by Patrick Denny - September 08, 2024, 12:24:28 AM
Would you want to password protect the programs?  They'd be blocked unless they obtain the password.
#7
Language / Disable LISTing on some users/...
Last post by jhendrickx00 - September 07, 2024, 08:51:43 PM
  Hi, it's possible to disable the LIST feature on some users/clients? The customer has a PxPlus 10 users license and he wants to disable the programming ability (LIST, modify programs) in 8 places, so only 2 users will have the ability to modify programs. Not allowing that users be able to break the program and stay on console is a great start, but some programs are old and still need to be assisted/checked before any other action, so the user could be able to stay at console due an error... I think if we're able to limit the LIST/LOAD/SAVE commands will be enough ( :-X )... Any ideas?

  Thanks in advance,
  Jean H//
#8
Off Topic / Re: Nice website
Last post by jhendrickx00 - September 06, 2024, 08:07:36 PM
Yes, the new site has a great modern and fresh style.

Still I'm looking for some sections, but I think the change is outstanding!

Congrats!!

Jean H//
#9
Off Topic / Nice website
Last post by martinp - September 06, 2024, 10:56:50 AM
Nice website refresh!

I'm going to miss the baby Mike King on the laptop though.
#10
Language / Re: SVN Linux?
Last post by martinp - August 30, 2024, 06:10:23 PM
Thanks Mike nice to hear from you!  I just want to be clear this does work on a PVXPLUS that is on an Linux license?

Right now it keeps asking me to enter start_up.svn  I created one but it just keeps looping the "environmental setup" box? please pick start_up.svn