Namespace: Consultingwerk.Studio.LegacyGuiMigration.Frame
Class 
SourceBufferJoinBuilder Copy to Clipboard
Parent classes:
Progress.Lang.Object
Consultingwerk.Studio.LegacyGuiMigration.Frame.SourceBufferJoinBuilder

Inherits: Progress.Lang.Object


Navigate to: Methods | Constructors | Events | Properties | ProDatasets | Temp-Tables



Top Method Summary
Options Name Purpose
AddBuffer (character, character, character, character) Adds a source buffer
CHARACTER GetBufferNames () Returns the buffer names in the order of the joined query
CHARACTER GetOrderedList (logical) Returns the buffer or table names in the order of the joined query
CHARACTER GetSourceDefaultQuery () Returns the joined query for the source buffers
CHARACTER GetTableNames () Returns the table names in the order of the joined query


Method Detail
Top

AddBuffer (character, character, character, character)
Purpose: Adds a source buffer
Notes: A buffer that was already added keeps its table. Its join
criteria is only assigned when it did not have join criteria
yet

Parameters:
pcBufferName CHARACTER
The name of the buffer
pcTableName CHARACTER
The name of the database table of the buffer (the buffer name when empty)
pcJoin CHARACTER
The join criteria of the buffer (without the WHERE keyword) or an empty string
pcJoinBuffers CHARACTER
The comma delimited list of the other buffers referenced by the join criteria
Top

CHARACTER GetBufferNames ()
Purpose: Returns the buffer names in the order of the joined query
Notes: The base buffer (added first) comes first, every further buffer
follows the buffers referenced by its join criteria

Returns CHARACTER
The comma delimited list of the buffer names
Top

CHARACTER GetOrderedList (logical)
Purpose: Returns the buffer or table names in the order of the joined query
Notes: Places the base buffer first. Then repeatedly places the first
buffer (in the order they were added) whose join criteria only
references buffers placed before or buffers that are not part
of the source buffers. Buffers with circular join criteria are
placed in the order they were added

Parameters:
plBufferNames LOGICAL
True to return the buffer names, false to return the table names
Returns CHARACTER
The comma delimited list of the buffer or table names
Top

CHARACTER GetSourceDefaultQuery ()
Purpose: Returns the joined query for the source buffers
Notes: Returns an empty string when there is only one buffer or when
a buffer has no usable join criteria - a buffer without join
criteria, or with join criteria referencing a buffer that is
not part of the source buffers. The generator then falls back
to its default query

Returns CHARACTER
The query string for the SourceDefaultQuery of the temp-table
Top

CHARACTER GetTableNames ()
Purpose: Returns the table names in the order of the joined query
Notes: The entries match the entries of GetBufferNames

Returns CHARACTER
The comma delimited list of the table names


©2006-2026 Consultingwerk Ltd.         info@consultingwerk.de         http://www.consultingwerk.de       09.11.2026 08:15:09