Dear All,
I'm new in Ebase Xi, i was trying create some form and table list with ebase sample database.
Now I want use my database, I create database using postgres, I was connect database, Adding database resource, create Business view, and add table on form. after that iwant display my data on table list on form, using fetchtable TABLENAME;
but it error , from execution log :
Error: SQL error reading from database resource TEST select * from base.TEST
Error: ERROR: relation "base.test" does not exist
Can you help me solve this problem
Regards
Juned
ERROR: relation TableName does not exist
Moderators: Jon, Steve, Ian, Dave
-
- Ebase User
- Posts: 35
- Joined: Mon Jul 14, 2014 11:55 pm
-
- Moderator
- Posts: 184
- Joined: Tue Sep 11, 2007 8:58 am
Hi Juned,
A few things to check first.
1. Open the database connection used by this resource and click the 'Test Connection' button. Does it work?
2. Does your postgress database include a schema/user called base?
3. Does base include a table called test?
4. Using the database connection tested in step 1, click the 'create resource(s) from database schema' button and import any table creating a new resource.
5. Create a new form which uses a table backed by this new resource - does fetchtable work in this form?
Regards,
Hovik
A few things to check first.
1. Open the database connection used by this resource and click the 'Test Connection' button. Does it work?
2. Does your postgress database include a schema/user called base?
3. Does base include a table called test?
4. Using the database connection tested in step 1, click the 'create resource(s) from database schema' button and import any table creating a new resource.
5. Create a new form which uses a table backed by this new resource - does fetchtable work in this form?
Regards,
Hovik
0 x
-
- Ebase User
- Posts: 35
- Joined: Mon Jul 14, 2014 11:55 pm
This is answer of your question
1. Open the database connection used by this resource and click the 'Test Connection' button. Does it work?
it works, Connection test successful.
2. Does your postgress database include a schema/user called base?
yes, this is tree view of postgres
Server
-Database
-->az_dev
---->Schemas
------->base
----------->Tables
--------------->Test
3. Does base include a table called test?
Yes
4. Using the database connection tested in step 1, click the 'create resource(s) from database schema' button and import any table creating
a new resource.
I was do that, TEST (table) will show on IT Element -> External Resource-> Database Resource
5. Create a new form which uses a table backed by this new resource - does fetchtable work in this form?
fetchtable not work
error Message :
SQL error reading from database resource TEST ,ERROR: relation "base.test" does not exist Position: 15
1. Open the database connection used by this resource and click the 'Test Connection' button. Does it work?
it works, Connection test successful.
2. Does your postgress database include a schema/user called base?
yes, this is tree view of postgres
Server
-Database
-->az_dev
---->Schemas
------->base
----------->Tables
--------------->Test
3. Does base include a table called test?
Yes
4. Using the database connection tested in step 1, click the 'create resource(s) from database schema' button and import any table creating
a new resource.
I was do that, TEST (table) will show on IT Element -> External Resource-> Database Resource
5. Create a new form which uses a table backed by this new resource - does fetchtable work in this form?
fetchtable not work
error Message :
SQL error reading from database resource TEST ,ERROR: relation "base.test" does not exist Position: 15
0 x
-
- Ebase User
- Posts: 35
- Joined: Mon Jul 14, 2014 11:55 pm
-
- Ebase User
- Posts: 35
- Joined: Mon Jul 14, 2014 11:55 pm
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
-
- Ebase User
- Posts: 1
- Joined: Mon Apr 20, 2015 10:25 am
-
- Moderator
- Posts: 1342
- Joined: Wed Sep 12, 2007 12:49 pm
It sounds like you are quite close. Make sure the "For use with table operations" checkbox in the Database Resource is checked. Then add a script to the before page event of the page containing the fetchtable statement, then drag the table on to the page.
This tutorial may help: http://dev-docs.verj.io/ufs/doc/tables_tutorial.htm.
From your post I'm not sure if you want to display the data as a table (as above) or as a list. Lists are different - to do this, you need to create a Dynamic List then link this to a form field. You can create a Dynamic List from a Database Resource by clicking the Build Dynamic List icon on the toolbar of the Database Resource Editor.
This tutorial may help: http://dev-docs.verj.io/ufs/doc/tables_tutorial.htm.
From your post I'm not sure if you want to display the data as a table (as above) or as a list. Lists are different - to do this, you need to create a Dynamic List then link this to a form field. You can create a Dynamic List from a Database Resource by clicking the Build Dynamic List icon on the toolbar of the Database Resource Editor.
0 x
Who is online
Users browsing this forum: No registered users and 6 guests