Problem during creating a list based on SQLite SELECT

[Kleyber_Derick]

Hi all,

I am creating a list based on a SELECT SQL from a SQLIte table and I am trying to populate a list with all data, as showed below:

But when I execute (both companion and APK) I receive the message:

It's like I had made a repeated entry in the list... Where am I wrong?

TIA,

[TIMAI2]

Please show list: global itensMaterials

[Kleyber_Derick]

[TIMAI2]

Why not just copy this list to your new list ?

[Kleyber_Derick]

Interesting idea. I had not thought about it. I'll try right now and tell you the result.

[Kleyber_Derick]

Fantastic!!! It solved the problem. And in fact, it's not necessary create a copy from a list which already has the data from SQLite table... So I could cut this second global list off.

Thank you, @TIMAI2 !!

[TIMAI2]

Or did I misread what you were trying to achieve? If you wanted all the sublist items in a single string, then you could use the list separator block to do that....

[Kleyber_Derick]

In fact I am trying to create a parameter (list) with all fields together to be sent to remote server.

[Kleyber_Derick]

Just complementing... the copy list block solved the problem of generating a new list, based in the previous one. Now I have to get each data from the list and create a parameter to be sent via POST, like:

&items=1,ANTEPARO SEMCO,,,2

And I tried again to use the for each in List and the error from the first post appeared again.

I'm searching here for a solution.

TIA,

[TIMAI2]

Something like this?

Also I notice that in your second sublist you have a comma in the field. This could cause problems, so you may want to clean your data in the sqlite database to remove any commas...

Draggable Procedure

[ABG]

This is where your original blocks went wrong:

[Kleyber_Derick]

Ahhhhh... let me replace it. Thank you, @ABG. I'll try it now and tell you my results.

[Kleyber_Derick]

Yes, that was it!! Thank you very much @ABG !!