Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
nigel  
#1 Posted : Sunday, February 12, 2017 11:26:12 AM(UTC)
nigel

Rank: Advanced Member

Groups: Registered
Joined: 1/20/2017(UTC)
Posts: 59
United Kingdom
Location: sussex

Thanks: 1 times
I am using the same sql table for multiple pages and need each page to have a different select statement. When I amend the statement for one it amends the others. The pages are not linked or sharing the same database name (eg DB1, DB2 etc) but it still affects the other select statements.
bbv  
#2 Posted : Sunday, February 12, 2017 11:49:16 PM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 495

Was thanked: 87 time(s) in 87 post(s)
Each SELECT statement which you use in your design has a name. You can see this name in the dialog where you edit your SELECT statement in the Name: field on the bottom.

You obviously have used select statement with the same name for different DB sources, which results in what you describe.

To create an independent SELECT statement for DB2 source, for example, click the button with yellow DB symbol to the right of $DB2. You will see an overview of all SELECT statementes used in your design. Click here the Add/Edit SELECT statement button to enter a new statement - the dialog must show initially empty text and a different Name. If you do everything right, then you will have an independent statement for $DB2

Then you can continue same way with other DB sources.
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.