





Browse articles by category

























[KB1250] Postgres provider tutorial using Npgsql provider
PostgreSQL is “the world’s most advanced open-source relational database”. It’s made by PostgreSQL Global Development Group. Unfortunately, PostgreSQL like some open source projects such as Maria DB does not offer a ready […]
[KB1241] SQL Server Native Replication (Enterprise Edition)
See attached pdf document. Download attachments: KB1241.pdf
[KB1236] Not possible to archive in SQL database
If the traces are activated you could have this kind of error: CSchTable::AbleToWrite on ‘TRENDTABLE1′ is FALSE ID=’2’ Here’s what we recommend you check in this case: Is the database […]
[KB1145] Database status check at startup
Applies to: PcVue 11.2 onwards Summary: Program and mimic to be set up to check if connection to a database is valid at project startup. Details: At project startup, HDS […]
[KB732] How to copy the contents of an HDS table to another SQL table or other relational database
Applies to: All PcVue versions including the HDS Originator: AD Summary: The SQL Server tools allow you to copy the contents of a table using two methods. On the fly […]
[KB716] Accessing SQL Server Database through VBA
Applies to: All VBA versions Summary: This VBA module allows to send read and write requests to a SQL Server database, using the ADO VBA Reference. The script is embbeded […]
[KB479] How to generate TS column if it is absent from the database
Applies to: PcVue all versions. Summary: This article explains how, when using the HDS, to generate a TS column by using an SQL query. Details: TS is an optional column. […]