Search found 12 matches

by rosswg
Tue Jun 16, 2009 4:49 pm
Forum: Database Related
Topic: wxdev - postgres - schema
Replies: 0
Views: 1559

wxdev - postgres - schema

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 is because there...
by rosswg
Sun Jan 27, 2008 7:37 pm
Forum: wxDev-C++
Topic: POSTGRE - table->Open()
Replies: 7
Views: 1247

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...
by rosswg
Fri Jan 11, 2008 6:33 pm
Forum: wxDev-C++
Topic: wxDevC++ future ???
Replies: 12
Views: 2515

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...
by rosswg
Wed Jan 09, 2008 11:50 am
Forum: C++ Development
Topic: wxFrame... wxTextCtrl. Vista. Navigation and wantsChars.
Replies: 1
Views: 339

If there is someone who has successfully done the above under vista, could you contact me, give some help or something please.
by rosswg
Wed Jan 09, 2008 11:48 am
Forum: wxDev-C++
Topic: POSTGRE - table->Open()
Replies: 7
Views: 1247

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.
by rosswg
Wed Jan 09, 2008 11:44 am
Forum: General Development
Topic: wxDb - Postgre - connection and table access.
Replies: 2
Views: 570

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...
by rosswg
Thu Jan 03, 2008 7:34 pm
Forum: C++ Development
Topic: wxFrame... wxTextCtrl. Vista. Navigation and wantsChars.
Replies: 1
Views: 339

wxFrame... wxTextCtrl. Vista. Navigation and wantsChars.

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...
by rosswg
Sun Dec 30, 2007 2:16 pm
Forum: wxDev-C++
Topic: POSTGRE - table->Open()
Replies: 7
Views: 1247

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...
by rosswg
Wed Dec 26, 2007 8:20 pm
Forum: wxDev-C++
Topic: POSTGRE - table->Open()
Replies: 7
Views: 1247

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...
by rosswg
Mon Dec 24, 2007 8:10 pm
Forum: wxDev-C++
Topic: POSTGRE - table->Open()
Replies: 7
Views: 1247

POSTGRE - table->Open()

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...
by rosswg
Thu Dec 13, 2007 6:07 am
Forum: General Development
Topic: wxDb - Postgre - connection and table access.
Replies: 2
Views: 570

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
by rosswg
Tue Dec 11, 2007 6:49 am
Forum: General Development
Topic: wxDb - Postgre - connection and table access.
Replies: 2
Views: 570

wxDb - Postgre - connection and table access.

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