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 [4] 5 6 ... 9
46
Wish List / Re: query version of ODBC-driver
« on: March 04, 2022, 06:13:13 AM »
Thomas,

I guess Devon refers to this function, which is probably implemented in the pxpsqlodbc.dll ?
https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlgetinfo-function?view=sql-server-ver15

I just found this other possibility to be quite simpler :
Code: [Select]
->def object fs,"Scripting.FileSystemObject"
->? fs'GetFileVersion$("D:\PxPlus\SQL ODBC Driver (64-bit)\pxpsqlodbc.dll")
7.0.3.0

You need to know first where the PxPlus ODBC driver has been installed
You can get that by querying the Registry key
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PxPlus® SQL ODBC Driver (64-bit)
And retrieve the Driver value

Regards

47
Programming / Re: Managing available memory (error 31)
« on: January 25, 2022, 08:50:47 PM »
Loren

You may want to try the IZ parameter as well, to have your program ignore any memory size limitations

Regards

48
Thin Client/WindX / Re: Using INVOKE with Windx on remote RDP users
« on: January 20, 2022, 11:54:04 AM »
Mike

Many moons ago, I was using env("clientname") to identify workstations in Citrix/TSE environments
You may want to try it and see if that works for you

Regards

49
Nomads / Re: buttons
« on: January 18, 2022, 07:47:04 AM »
Thomas

Since you need both icons and text with different font styles, I see several ways to do this :

- An easy one :
Define the buttons using graphical mnemonics (an image, two fonted texts and a frame with rounded corners) and then use SETMOUSE to define the clickable region and the CTL it should return. However it won't handle the hover event to change the button background color...

- A more complex one :
Define the buttons as bitmap buttons and use a virtual bitmap (using the *bitmap* special file) that you create yourself.
This way you can have the hover event handled

Regards

50
Language / Re: [Pxpprg] / [Pvxprg] program file header
« on: January 05, 2022, 01:32:28 PM »
Hi Mike


Thanks for the answer.


Regards

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


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


TIA

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

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 :
https://www.youtube.com/user/pvxplus

Regards

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

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.

Regards

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


You can watch a few short Flash-based tutorials on this page :
https://home.pvxplus.com/pgsrvr.pvp?pg=docs


Regards

55
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


Regards,

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


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 ?


Regards,

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


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

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


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 ?


TIA

59
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

Regards

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


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]

-:run
1
Family


2
Work

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

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

Pages: 1 2 3 [4] 5 6 ... 9