FiveTech Support Forums

hi,

it is not a special FiveWin Question

as i know i can use 2 Table in SQL-Statement when using "A(lia)S"

when both have Table "same length", will it be "sync" when "navigate" in Table

---

when using ADO i get a Record-Set from Table sqldata
but how "sync" Table sqlindex when have cFor, cWhile and nOffset ... or will it be "in Sync"

or do i need a (internal) FIELD __Record in both Table to "sync"

---

as i know "older" SQL Version can create a "real" SLQ Index only from 1 x FIELD
so FIELD1 + FIELD2 will not work like in xBase as IndexKey

the Idea is to create a second Table sqlindex
when create a Table sqlindex i can create a FIELD which can hold Value of FIELD1 + FIELD2 as IndexKey
when change ORDER all Information are in same ROW and i can use Table sqlindex "internal" as ORDER

can this Concept work
Comment welcome

Jimmy wrote:

Code (fw): Select all Collapse

"SELECT a.text1, b.__text1 FROM sqldata AS a, sqlindex AS b"

This join is incomplete as it lacks of the WHERE clause. Without it you would get a recordset of n1 * n2 records. You have to use something like



EMG

hi Enrico,

This join is incomplete as it lacks of the WHERE clause.

yes you are right

i need a "Relation"
so i add "internal" FIELD __Record and use

and change to


Ok now i can begin to add "more" where, ORDER, OFFSET and LIMIT for "navigation"