Rank: Advanced Member
Groups: Registered
Joined: 1/20/2017(UTC) Posts: 59  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.
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 484
Was thanked: 81 time(s) in 81 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.
|
|
|
|
|
|
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.
