Recent posts
#1
Programming / Re: Open, Read, Write/Update t...
Last post by nrh7 - Today at 10:02:46 AMNeat, I'll try that thanks!
#2
Language / Re: SVN Linux?
Last post by martinp - September 11, 2024, 11:06:42 PMSo 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 AMShould 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.
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 PMYou can execute SQL directly via the WRITE RECORD:
WRITE RECORD (CHAN) "INSERT INTO table_name VALUES (value1, value2, value3)"
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 AMOk, stuck again
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!
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 AMWould 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 ( )... Any ideas?
Thanks in advance,
Jean H//
Thanks in advance,
Jean H//
#8
Off Topic / Re: Nice website
Last post by jhendrickx00 - September 06, 2024, 08:07:36 PMYes, 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//
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 AMNice website refresh!
I'm going to miss the baby Mike King on the laptop though.
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 PMThanks 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
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