Automatic Data Entry

Peter De Berdt peter.de.berdt at pandora.be
Fri Oct 29 15:48:01 CDT 2004


> Simply Kim:
>
>    s = "select RecID, story_name, heading, sub_heading, caption, body,
>   story_writer, section, publication, depth, page, comment from stories
> where
>
>
> If you need join tables then
>
>     SELECT ..
>     FROM T1, T2
>     WHERE T1.RecID = T2.ObjectPtr
>

You can even just say "SELECT ... FROM T1,T2" because the ObjectPtr 
already knows how to join the two tables.
>
> You can use RecID by name.
>
And if you need the RecID in the SELECT query, you need to include it 
in the query, even if you are using SELECT *  (it's all in the docs if 
you have not read them yet):

SELECT ..., RecID FROM T1

Best regards

Peter De Berdt



More information about the Valentina mailing list