This could work except when the results are numeric values. Casting them as alpha-numeric values messes up the ordering, when I use a numeric virtual as output variable I get this:

 

 

Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens harry@...
Verzonden: dinsdag 13 juni 2017 14:48
Aan: main@magicu-l.groups.io
Onderwerp: Re: [magicu-l] Populate with SQL [XPA 2.5]

 

Hi Florian,

You could use a direct sql task with the whole sql select as a parameter and build your combobox string from that. You could send this back as the return parameter.

Best regards,
Harry Kleinsmit.

 

Met vriendelijke groet - With kind regards, Florian Groothuis Analist/programmeur +31 (0)6 21927914

meilink.eu Meilink Beheer Borculo B.V. • Kamerlingh Onnesstraat 1 7271 AZ  Borculo • Nederland • +31 (0)545 253525 KvK 08009803 • Our general terms and conditions apply • Disclaimer

 

 

 

 

Hi Todd!

 

I don't have my laptop with me but,

1. Yes, it goes there, sorry I forgot to tell you before!

2. Compile version can be 21, 22, 23 or whatever. But, check the targetSdkVersion, I tried it with 22. 

If you use 23 in targetsdkversion you'll have to add some code to ask for permission to use the Telephony service when api >= 23. 

I think that Magic in the help explains how to do that, but I didn't test it so I'm keeping api 22 in targetsdkversion for now. My cellphone uses api 23 and it worked with targetsdkversion 22.

 

And the message you see is just a warning but is still works.

 

Oh, wait!!! I think I forgot to tell you something, I knew something was missing when I wrote you.

Add to the AndroidManifest file:

<uses-permission android:name="android.permission.READ_SMS" />

<uses-permission android:name="android.permission.RECEIVE_SMS" />

Where the other permission lines are.

 

Check the targetsdkversion, set it to 22 and try again.

 

If it's still not working, what I would try is:

- Uncomment this line 

//Toast.makeText(context, "I got to onReceive", Toast.LENGTH_SHORT).show();

Just remove the "//"

- Generate new apk. 

- Run app and see if the Toast shows up when sms arrives. Then we can see if it's not getting to java or not getting to magic.

 

Good luck !!!

(And if it's still not working I'll be happy to help through teamviewer or something)

Hi Todd!

 

I don't have my laptop with me but,

1. Yes, it goes there, sorry I forgot to tell you before!

2. Compile version can be 21, 22, 23 or whatever. But, check the targetSdkVersion, I tried it with 22. 

If you use 23 in targetsdkversion you'll have to add some code to ask for permission to use the Telephony service when api >= 23. 

I think that Magic in the help explains how to do that, but I didn't test it so I'm keeping api 22 in targetsdkversion for now. My cellphone uses api 23 and it worked with targetsdkversion 22.

 

And the message you see is just a warning but is still works.

 

Oh, wait!!! I think I forgot to tell you something, I knew something was missing when I wrote you.

Add to the AndroidManifest file:

<uses-permission android:name="android.permission.READ_SMS" />

<uses-permission android:name="android.permission.RECEIVE_SMS" />

Where the other permission lines are.

 

Check the targetsdkversion, set it to 22 and try again.

 

If it's still not working, what I would try is:

- Uncomment this line 

//Toast.makeText(context, "I got to onReceive", Toast.LENGTH_SHORT).show();

Just remove the "//"

- Generate new apk. 

- Run app and see if the Toast shows up when sms arrives. Then we can see if it's not getting to java or not getting to magic.

 

Good luck !!!

(And if it's still not working I'll be happy to help through teamviewer or something)

Hi Todd, just tested in Android Studio and also in Magic.

package com.magicsoftware.magicdev;

 

import com.magicsoftware.core.CoreApplication;

import android.content.BroadcastReceiver;

import android.content.Context;

import android.content.Intent;

import android.os.Bundle;

import android.telephony.SmsManager;

import android.telephony.SmsMessage;

import android.widget.Toast;

 

public class MySmsListener extends BroadcastReceiver {

    

    final SmsManager sms = SmsManager.getDefault();

 

    public void onReceive(Context context, Intent intent) {

 

//Toast.makeText(context, "I got to onReceive", Toast.LENGTH_SHORT).show();

 

        final Bundle bundle = intent.getExtras();

 

        try {

 

            if (bundle != null) {

 

                final Object[] pdusObj = (Object[]) bundle.get("pdus");

 

                for (int i = 0; i < pdusObj.length; i++) {

 

                    SmsMessage currentMessage = SmsMessage.createFromPdu((byte[]) pdusObj[i]);

                    String phoneNumber = currentMessage.getDisplayOriginatingAddress();

                    String senderNum = phoneNumber;

                    String message = currentMessage.getDisplayMessageBody();                    

CoreApplication.getInstance().invokeExternalEvent("SMSRECEIVED:" + message);

 

                } 

            } 

 

        } catch (Exception e) {

            // Error

//Toast.makeText(context, "Exception" + e.getMessage(), Toast.LENGTH_SHORT).show();

CoreApplication.getInstance().invokeExternalEvent("SMSERROR:" + e.getMessage());

        }

    }

}

On the AndroidManifest.xml add the following lines:

<receiver android:name=".MySmsListener">

            <intent-filter>

                <action android:name="android.provider.Telephony.SMS_RECEIVED" />

            </intent-filter>

 </receiver>

Build apk.

Then in Magic:



Thinks to keep in mind:

- I added a Toast in the java class, uncomment if you need to see if the sms gets to the android java class.
- Since android >= API 23 needs a different type way of requestion permissions, I use targetSdkVersion 22 on the app build.gradle. I tested this on my cellphone that has android 6.0 and it's working.
- I think that's all!

Let me know if you need any help!!

Brenda