Subject Re: order by on different way
From Dirk <non@non.com>
Date Mon, 22 Nov 2021 18:23:22 +0100
Newsgroups dbase.getting-started

Op 15/11/2021 om 21:17 schreef Dirk:
>
>  solved, tja another approach

    thanks for the input to Mervyn

    Dirk

    hello,
>
> i need some explanation about :order by
>
>     this is placed in open :  form.vraagbak_sort = form.vraagbak_firma.sql
>
>
>    local cSort
>          cSort = Form.vraagbak_firma
>        //form.vraagbak_sort = form.vraagbak_firma.sql
>        // form.Veld_zoek_data.value = ""
>        form.Veld_zoek_data.setfocus()
>       Do Case
>        case this.value == "firma"
>         cSort.active = false
>                 cSort.sql = form.vraagbak_sort+[order by name]
>                  cSort.active = true
>               cSort.rowset.first()
>
>   1 ) when i create a query with a join between  firma data and contact
>   data  i can order by name or whatever
>
>   2)  when i use 2 queries and conected with masterfields ..
>
>       get message invalid use of keyword By
>
>
>    the form is used to create data
>
> some info would be helpfull
>
> regards
>
> Dirk,