wxWidgets Discussion Forum

Have connected to a postgres database. The data base has more than one schema. If I use db->TableExists("Table name","user-id/schema), the table is found to be present. When opening table table->Open() it returns NULL, that is the table is not found. It would seem that cause of this i...

Thank you for the thought. I will still get back to you on it. It may be possible that if I get the catalog with the options on the schema increased to include more than one schema then I will be able to find more tables. HOWEVER, I cannot see how to open a table from one schema and then another fro...

About 2+ years ago. I was trying to get something going using Dev-c. It was then a popular pastime to post a question on the site asking in effect whether there was any future. Well it is 2+ years later, and they are still going strong, and it is 2+ years later and wxDev-C++ is still going strong as...

If there is someone who has successfully done the above under vista, could you contact me, give some help or something please.

Finally found the root cause of the problem.

UNDER POSTGRES YOU MUST USE THE EXECSQL COMMAND TO SET THE DEFAULT SCHEMA. IF YOU DO NOT DO THIS. YOU WILL NOT BE ABLE TO OPEN A TABLE.

It had to be something simple and easy.

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

1. There seems to be a difference in the results of the samples provided with devcc and with doing it using NEW Project|wxframe, as regards to navigation between controls. 2. The samples work - the programs I create using wxFrame, have some issues. 3. Project New|wxFrame - set wantsChar. Then a wxLo...

Thank you - I used the error log information available in Postgre. It told me that 1. One of the 'sql -exec' was incomplete and 2. That my program was actively not accepting the connection. ---------------- So I started again starting the connection from the first line of code, then checking the err...

Interesting thought. Never considered that approach. It was my thought that it is a wx problem. Postgres as I understand it has a dns one or more databases ( with user-id and password) each data base having one or more schemas and each schema having one or more tables etc... wx - does not provide fo...

There is an existing POSTGRE data base. I can connect. I can access all the table names and list them. I can access all the column names and list them with their details. I now want to open a table. Using one of the exising table names it has 58 columns. I used setcoldefs for two of the column names...

After more searching and more trial and error. It looks like I am winning. It is just that the schema is one of the last things one sets, and I was looking for it as one of the second things one needs to get. More later

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