SQL 2 Table Question

[Jimmy]

hi,

it is not a special FiveWin Question

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

Code: Select all  Expand view

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

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

[Enrico Maria Giordano]

Code: Select all  Expand view

"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

Code: Select all  Expand view

WHERE id1 = id2

EMG

[Jimmy]

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

Code: Select all  Expand view

   cQuery := "CREATE TABLE " + xtab + " ( "
   ...
   cQuery += " __record     serial  NOT NULL, "
   cQuery += " CONSTRAINT " + xtab + "_pkey PRIMARY KEY (__record)"
   cQuery += " )"                                
 

and change to

Code: Select all  Expand view

"SELECT a.text1,a__Record,b.__text1,b.__Record FROM sqldata AS a, sqlindex AS b where a.__Record = b.__Record"

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