Let me explain what I know about the relationship between the database and ERP system.
As I said before I have 3 databases, which is 1 databases = 1 company in ERP System.
A new database will be created by ERP System when I creating a new company and it will generate all the required table for...
Both data types are CHAR and indexes.
I think the problem is the table, I tried to replace the data file with the original data file and using "INSERT" to import data.
I tried many things on it, but still the same.
Mirtheil, thanks for your reply.
Yes, I can get the same results in all my database.
The results are totally the same, no space & no extra characters in front of PO_NO.
I take another example.
ROUTER_TABLE has the same issue.
When I try to run the query below and get the result without a...
This is my PCC info
PSQL Control Center
PSQL Install Version 12.11.025.
Java Version 1.7.0_51.
This is my server PSQL info
Actian PSQL v12 Server Engine SP1
Version 12.11.025
I did reinstall the Server's PSQL Engine with loading back all the previous data, but it still the same.
I have 3 similar databases in the PSQL which is used for my ERP system.
First database = dbA, Second database dbB, Third database dbC
Mostly we use dbA as our main database to link to the ERP, dbB & dbC is a test database for the ERP system.
Recently, I exported all data from the dbA and import...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.