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,
|
|