On Mon, Sep 23, 2019 at 03:19 PM, sherman levine wrote:

Create a numeric virtual beneath your column and init to
if(isnull(column),0,column)
That will put the nulls with the zero.
or if(isnull(column),'2',column)
which will put the nulls at the bottom

Thats basically the way to do this, only that you should evaluate this on server side, resp. with SQL. Otherwise you run into quite some performance issues when there's lots of records in the table.

Most important it would be of course to know what the DBMS actually is.

Standard SQL also allows to specify where to sort NULL values in ORDER BY clause:
order by col asc nulls first
order by col asc nulls last

Also a CASE is possible there:
select * from orders
  order by (case DateDelivery IS NULL THEN 1 ELSE 0 ENS), DateDelivery

I have received from Alan some document files. The strange thing is : it works at some of my applications but not with all. I have also used the doc_std.eng (the standard document file), but also no output and the application shuts down. I have exported and imported one of those applications : no problems at all, but the document-file gives still no output. Somebody can told me what can be the cause ? I am converting 8.3 to up and also want to merge 3 applications together, so I need a dictionary list. Yes, I know I can create this by screen-prints but that cost a lot of time. Teun.  

Dear Todd Barmore,

Thanks for your comment!
Yes, I've tried.
I've made several more tests.
[MAGIC_RIA]
HttpRequestTimeout=70
Works more or less. Sometimes when wifi signal lost I got Server Unavailable in 2 seconds. Sometimes it works as expected so the program hangs the cursor shape changes and when I have wifi signal again the program continues. Sometimes the program hangs, cursor shape changes but after 7 seconds no  "Do you wish to retry connecting?" message appear.
So, I don't know to force the application to behave always the same way. When signal lost wait for 7 seconds then when signal is back continue if signal is lost drop an error message "Do you wish to retry connecting?". So only the error message appearance should be delayed for a while to give a chance to the user go back near the wifi.

Hello,
In the past I had made a document file to print the file- and program-dictionary for Magic8.3 applications, but I can't find it anymore. I have tried
to make a new one, but my knowledge has gone (I think) because of my age (72?). Who can help me to create such a document file while the standard
DOC_STD.ENG gives too much informaton : I only need the dictionary listing. TIA. Greetings from Holland, Teun van Unen (undix76@...
<mailto:undix76@...>).

Hello,
In the past I had made a document file to print the file- and program-dictionary for Magic8.3 applications, but I can't find it anymore. I have tried to make a new one, but my knowledge has gone (I think) because of my age (72?). Who can help me to create such a document file while the standard DOC_STD.ENG gives too much informaton : I only need the dictionary listing. TIA. Greetings from Holland, Teun van Unen (undix76@...).

Thanks Todd,

I saw those and that is kind of what brought it up. 

With XPA, Magic kind of split it into two versions with XPA 4.X, which seems like it was just supposed to be for Web based development, and XPA 3.3, which still seems to be primarily for Client/Server.

Is 4.6 then going to be a Client/Server, Web, or combined version of XPA?

Any dates on its availability?

Thanks,

Jim

On Mon, Sep 23, 2019 at 11:27 AM Todd Baremore <tbaremor@...> wrote:

Jim,

Charles Coe posted a number of pictures.  Somewhere in the mix is a list of the new client/server features in XPA 4.6.
https://magicu-l.groups.io/g/main/album?id=95599

Todd

On 9/23/2019 12:11 PM, Jim Stephenson wrote:

Todd and any other participants,

From a client/server perspective, what, if any, are the biggest changes coming down the pike for XPA?

I really wanted to go this year, but too many other things got in the way. Hopefully next year.

Jim

On Mon, Sep 23, 2019 at 9:02 AM Todd Baremore <tbaremor@...> wrote:

Sem,

Are you volunteering to video all the presentations next year?   We would greatly appreciate your help.

Todd

On 9/23/2019 10:23 AM, sem Grullon wrote:

in 2019 and could not make video!.

El lun., 23 sept. 2019 a las 8:19, Brenda Bullorini (<bbullorini@...>) escribió:

Too bad I couldn't make it!
But I attendeed in 2017 and it was awesome. I learned new things, there were great presentations,
good people who made my brother and I feel very welcome.
I'm from Argentina so it's very expensive for us to travel sometimes, despite of how much we want to be there.
Anyway I love to see for the comments now that Brown Bag is getting better and better! :)

--

Sem Grullon 

Servicios Moto Auto SRL 

Todd and any other participants,

From a client/server perspective, what, if any, are the biggest changes coming down the pike for XPA?

I really wanted to go this year, but too many other things got in the way. Hopefully next year.

Jim

On Mon, Sep 23, 2019 at 9:02 AM Todd Baremore <tbaremor@...> wrote:

Sem,

Are you volunteering to video all the presentations next year?   We would greatly appreciate your help.

Todd

On 9/23/2019 10:23 AM, sem Grullon wrote:

in 2019 and could not make video!.

El lun., 23 sept. 2019 a las 8:19, Brenda Bullorini (<bbullorini@...>) escribió:

Too bad I couldn't make it!
But I attendeed in 2017 and it was awesome. I learned new things, there were great presentations,
good people who made my brother and I feel very welcome.
I'm from Argentina so it's very expensive for us to travel sometimes, despite of how much we want to be there.
Anyway I love to see for the comments now that Brown Bag is getting better and better! :)

--

Sem Grullon 

Servicios Moto Auto SRL