PxPlus User Forum

Twitter Twitter Twitter

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Stéphane Devouard

Pages: [1] 2 3 ... 5
Language / Re: [Pxpprg] / [Pvxprg] program file header
« on: January 05, 2022, 01:32:28 PM »
Hi Mike

Thanks for the answer.


Language / [Pxpprg] / [Pvxprg] program file header
« on: January 05, 2022, 08:55:09 AM »

Best wishes for 2022 to all

I cannot remember if there is any system parameter that would prevent PxBasic V10 to overwrite the [Pvxprg] header (as created by Sage PVX v9.10) with [Pxpprg]
This way I could use PxBasic's *IT editor to do some coding in the old app I have to maintain and programs would still be readable & executable by ProvideX


Nomads / Re: Newbie in Nomads Development
« on: November 05, 2021, 03:36:55 AM »

Would I have been still working as freelance, I would have offered to share my knowledge of the Nomads & iNomads environment, which I have been working with since the end of the 90s up to now. However I have a full-time job working as Support/Developer which does not leave me extra time.

The Flash videos I have pointed you to will give the basic barebones of creating Nomads forms.

There is also a series of videos on Youtube where Mike is creating a small app from scratch in less than 30 minutes :


Nomads / Re: Newbie in Nomads Development
« on: November 04, 2021, 12:20:12 PM »

I know at one point (in the 2000s, when ProvideX swung between the Sage and Best Software brands) there were classes to learn the language, an intro to Nomads and an Advanced Nomads course, as well as some OOP introduction.
I even found some old Sage & Best training / tutorials Word docs in my archives
An awful lot of things have changed since, but they would probably be still relevant for the most part

However I guess these docs (or up-to-date versions of them) are only available if you purchase some kind of training class with the experts

You need to check with your distributor if they offer this type of service, and if not, ask the PxPlus folks.


Nomads / Re: Newbie in Nomads Development
« on: November 04, 2021, 08:57:12 AM »

You can watch a few short Flash-based tutorials on this page :


ODBC / Re: Crystal Reports SAP/PxPlus ODBC Driver Error 3 Tables
« on: October 19, 2021, 11:47:12 AM »
Hi Jeff

Haven’t done much Crystal and PxPlus ODBC, but :
How about linking order lines to order header and inventory master ?
Would be two inner joins to the main table instead of one left join then one inner join

Just thinking out loud


Nomads / Key names size limit
« on: September 16, 2021, 08:35:26 AM »

I haven't found any mention of a limitation in size for a key name

Yet, the key definition dialog in the DD maintenance tool imposes a 24-char size limit to the key name entered.

Having got some training in SQL, I know that in most DB systems, primary key constraints & index names must be unique throughout a database, so I now name primary keys as 'PK_<table name>', alternate indexes as 'IX_<table name>_<sorting>' -- not to mention table names often start with a 2-4 prefix representing the sub-application module ;-)

So... Is the 24 char limit by design or are keynames allowed to be larger ?


Programming / Re: Thoroughbred Migration
« on: September 01, 2021, 12:37:20 AM »

I migrated an hospitality software from Tbred 8.3 to ProvideX 4.01 in 1998.
At that time, the migration tool was creating a big bundle text file with all your programs and data files (depending on the directory devices you had selected for migration)
You then moved this big ass file to the target environment / system and used the unbundle tool to recreate programs and files in ProvideX format.
Almost all incompatibilities were addressed by the conversion tool, and fixing those that remained only took hours (do not have the details, as it has been 23 years). Even if you were using the Tbred « Windowing » system which we did not, and is quite different from ProvideX windows and dialogue controls, the conversion tool was modifying your code to call emulation routines provided by ProvideX.
During the transition period, you can use the various emulation modes provided by ProvideX (such as the Tbred FID() format, the windowing emulation, etc…) but it is then recommended to change your code to move and stick to the ProvideX standards and conventions. Who would want to migrate to another BB once under ProvideX anyway ? ;)

You can read more @ https://manual.pvxplus.com/PXPLUS/conv.tbd/overview.htm

Hope this helps

Nomads / Query auto-tab
« on: August 18, 2021, 05:11:28 AM »

Unless I missed something or the current documentation is not complete :
There is no %NOMADS property that would enforce the auto-tab value in the query headers throughout the system ?

Is that something that could be considered for a future update ?


Nomads / FM generator issues
« on: August 01, 2021, 11:42:40 AM »
Here are a couple of issues I found while using the FM generation wizard :

1) Inserting a dot in the FM panel name
If I name the panel with a dot (e.g. company.fm), I cannot re-open the FM wizard after the first generation of the panel. From the Nomads selector I get a message telling me to delete and regenerate the panel. From *it, I can open the library then edit the generated panel.
If I name the panel with an underscore (e.g. company_fm) then everything works as expected.
Looking at the Nomads code, this is due to the way the folder tabs are generated.
So I would simply suggest to add a check on the presence of a dot (.) in the name when creating a new FM object

2) Defining a primary key segment with a format specifier

If one of the primary key segments in the data dictionary is defined as "Last Substring" (for example), then I cannot complete the FM wizard
I am getting a message saying that some of the required fields are missing on the screen layout.
This is because the :[...] format specifier adds an extra comma to the IOLIST and screws up the test @ 1446 in fm_wizard


Language / Re: Writing Postgres tables
« on: July 10, 2021, 06:02:15 AM »

Since PxPlus does not provide a direct interface to PostgreSQL, you need to download and install the ODBC driver

The attached code connects to a database on the local machine using a DSN-less connection string

When run, it yields :
Code: [Select]



You can also insert to a table (very simple schema : an auto-increment id and a varchar description :
Code: [Select]
1:write record (pgdb)"insert into categories (category_name) values ('Friends')"
1:write record (pgdb)"select * from categories where category_id=3"

And update as well :
Code: [Select]
1:write record (pgdb)"update categories set category_name='Professional' where c
1:write record (pgdb)"select * from categories where category_id=2"

Thin Client/WindX / Re: MS Window Size
« on: July 05, 2021, 03:06:11 AM »

Could also be due to the location where WindX has been installed on each workstation.
If it is installed under "Program Files", the Windows security enforced on this system directory may prevent the interpreter from writing back to pvx.ini / pxplus.ini when exiting


Language / Re: *windev* and scheduled tasks
« on: June 17, 2021, 11:13:54 AM »
Then you should try to open a session as administrator account, run a ProvideX prompt, and try to open the *windev* device
If it yields an error 12, then it will yield the same error when running as a scheduled task

You may need to manually mount the shared printer / queue in your program with something like

Code: [Select]
invoke "net use ..."


Language / Re: *windev* and scheduled tasks
« on: June 17, 2021, 10:52:06 AM »

When running, the scheduled task will have the credentials of the user account you have set up for the task
If you use something like LocalSystem, then be aware that this user does not have any network access, which may explain the error 12 if your *windev* points to a shared printer device.


Nomads / Re: Displaying an Excel spreadsheet on a NOMADS panel
« on: June 06, 2021, 05:52:07 AM »

When you use the "Excel.Application" ProgID, you create as the name implies, an Excel application object
That is, you ask for an EXCEL.EXE executable to run, with its own user interface, that you can make visible with the 'Visible property

If you want to embed an Excel object on a panel of yours, you need to use either the "Excel.Addin" ProgID for a workbook, or "Excel.Sheet" for a simple worksheet

However, I haven't found any Load(), Open() or similar method to load data from an existing .xlsx file

Maybe others who have been more successful can chime in

Hope this helps


Pages: [1] 2 3 ... 5