PostsreSQL / SQL newbie question

[Bob Fiering]

Hi Bas,

I did try this, but no effort.
It has something to do with the way Omnis created the tables when dragging the df1 files to postgres.
When i create a database and a table manual in pgAdmin, fill it with data, connect to it in Omnis, create schema class etc., it shows the data.
When i create an extra table in this database in pgAdmin based on the sql statement Omnis used to create the tables with the serial field etc. and fill it with data. The same routine doesn't show the data.

regards,

Bob


Op 14 apr. 2013, om 09:29 heeft Bastiaan Olij <bastiaan at basenlily.me> het volgende geschreven:

Hi Bob,

Try changing the table name of the schema simply to 'FBV', omit the
public bit.

Also did you connect to the right database? With the postgres DAM you
select the database first, then logon, not the other way around, so you
may simply be connecting to the postgres database instead of your own
database.

I need to find time to get my website back up and running but I'll send
you my old getting started demo library, you may find it of some use :)

Cheers,

Bas

On 14/04/13 4:28 AM, Bob Fiering wrote:
> Hi Mark,
> 
> 1. Yes, i can connect with the Omnis SQL Browser to the postgres database. I can use show data and it shows the content of that table.
> I can also connect with the object in combination with my login window that i created. 
> 
> 2. With the pgAdmin tool i can see all tables and its corresponding data. When moving all tables under Omnis the tables were automatic placed under Schemas / public / Tables. Under public also the sequences are placed.
> 
> 3/4  I think here lies the problem. The monitor tool you mentioned (and i missed) gives the message
> 
> 2013-04-13 19:51:40 CEST	ERROR	relation "public.fbv" does not exist at character 1269	
> 2013-04-13 19:51:40 CEST	STATEMENT	SELECT public.FBV.BBVCODE,   ......all fields from the table.....  public..FBV.BWEBSITE FROM public.FBV	
> 
> when i choose show data in the SQL Browser of Omnis the statement is   SELECT * FROM "public"."FBV"
> So "public"."FBV" is the right syntax. When i look at the properties of the schema class the table name is public.FBV.
> When i change this to "public"."FBV" the error changes to
> 
> 2013-04-13 20:08:16 CEST	ERROR	column FBV.bbvcode does not exist at character 8	
> 2013-04-13 20:08:16 CEST	STATEMENT	SELECT "public"."FBV".BBVCODE,"public"."FBV".BBVNAAM,  ..... all the fields from the table........  "public"."FBV".BWEBSITE FROM "public"."FBV"	
> 
> So somehow the schema class i created by dragging the table to Omnis has not the right relation to the table in postgres.
> Not sure how to solve it, but i am a step further in the process of solving the problem.
> 
> regards,
> 
> Bob
> 
> Op 13 apr. 2013, om 17:57 heeft Mark Phillips <mark.phillips at mophilly.com> het volgende geschreven:
> 
> On Apr 13, 2013, at 8:22 AM, Bob Fiering wrote:
> 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com