As I understand Postgre there is a
1. DNS - which will be PostgreSQL30 - or equivalent
2. Data Base Name - User defined - say 'TestDataBase'
3. Schema Name - User Defined - say 'TestSchema'
4. TableName - User Defined - say 'TestTable'
5. User Name - User defined - say 'TestUser'
6. Password - User defined - say 'TestPassWord'
Now following the example giving in the documentation of wx for a data base, and also searching through the other documentation, I was not able to find how to set the Data Base Name and or schema name.
Again according to the existing Postgre set up being used, the DNS has more than one Data Base, and the the Data Bases have more than one schema.
It would be appreciated if someone could point me in the direction that I should be going, because at the moment I am walking around in circles.
Thankyou
wxDb - Postgre - connection and table access.
Phew - I got something going and then lost it again, and then
when I was trying to get it to go again - I finally found the answer it is this -----
UNDER POSTGRES - AFTER MAKING A CONNECTION YOU MUST THEN USE
THE EXECSQL command AND SET THE DEFAULT SCHEMA TO THE ONE THAT
YOU ARE USING.
IF YOU DO NOT DO THIS - YOU WILL NOT BE ABLE TO OPEN A TABLE.
when I was trying to get it to go again - I finally found the answer it is this -----
UNDER POSTGRES - AFTER MAKING A CONNECTION YOU MUST THEN USE
THE EXECSQL command AND SET THE DEFAULT SCHEMA TO THE ONE THAT
YOU ARE USING.
IF YOU DO NOT DO THIS - YOU WILL NOT BE ABLE TO OPEN A TABLE.