Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Alvin Chong

    Invisible Space In my PSQL database

    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...
  2. Alvin Chong

    Invisible Space In my PSQL database

    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.
  3. Alvin Chong

    Invisible Space In my PSQL database

    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...
  4. Alvin Chong

    Invisible Space In my PSQL database

    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.
  5. Alvin Chong

    Invisible Space In my PSQL database

    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...

Part and Inventory Search

Back
Top