How to configure Combobox based on neoPhpExecSql?

#1 · January 23, 2021, 9:57 pm

Hello and good time ...
How to configure Combobox based on neoPhpExecSql?

#2 · January 24, 2021, 2:16 pm

ComboBox object has an Items property. Just include an Array variable there (ie: [myArray]) to show each array element within the ComboBox. You can populate the Array in the callback subroutine you use to parse the content from neoPhpExecSql.

#3 · January 24, 2021, 2:58 pm

Thank you for your response! Can you give an example for training? thank you ...

#4 · January 25, 2021, 7:57 am

@javadrajabihakami please, to help me save time, attach your own sample with a SQLite database and I will add the code.

Thanks!

#5 · January 25, 2021, 11:19 pm

Thank you very much, of course

#6 · January 29, 2021, 1:34 pm

attach sample with a SQLite database

#7 · January 29, 2021, 1:43 pm

Hello and have a good time! Whatever I do, I can not attach a sample file! Please, if anyone can help and cooperate in this field, it has really done me a great favor! Thankful

#8 · January 29, 2021, 2:51 pm

@javadrajabihakami please send the file through WeTransfer or similar service to info[art]sinlios.com
The security system sometimes reject the attached files. Sorry.

Thank you!

#9 · January 29, 2021, 3:05 pm

@javadrajabihakami please take a look at the attached sample.
I have used neoGSheetsLoad, but it should be exactly the same when using neoPhpExecSql
Let me know if it answers your question.

Regards.

Uploaded files:

You need to login to have access to uploads.

Vadim has reacted to this post.

#10 · January 29, 2021, 10:19 pm

Hello and thank you, dear master! Thank you very much for your response ... I tried your attachment and failed to view the information in Combobox! Thanks for another tip! Of course, I am very ashamed to disturb your time! Thanks/

#11 · January 30, 2021, 11:57 am

@javadrajabihakami that's quite strange. Are you under a firewall blocking Google content?
Anyway, please take a look at the code. It has all you need to understand how populate a Combobox from a database:

1) Be sure your items and variable ComboBox properties are set.

2) Use neoPhpExecSql command and be sure to include to your CallBack Subroutine.

3) Your Callback Subroutine should load and parse the data. Just create and populate the Array you have included under items ComboBox property using a LOOP:

CreateEmptyArray [items]
Loop 0 [data.length] [n]
   ArrayAddItem [items] [data([n]).fieldName]
EndLoop

I have attached again the Google Sheets sample but using a Proxy to load the data.
It's no difficult. Let me know if you need help.

Regards.

Uploaded files:

You need to login to have access to uploads.

Vadim has reacted to this post.

#12 · January 30, 2021, 6:10 pm

Hello and have a good time! Thank you very much for your kindness, Mr. Louise
I have not succeeded yet! But I will try my best and I will pay attention to your sample and let you know! Everything I configure with neoPhpExecSql does not work. I will try to send you some photos of the code environment used. Thanks a world ...

Uploaded files:

You need to login to have access to uploads.

#13 · January 30, 2021, 6:12 pm

neoPhpExecSql

Uploaded files:

You need to login to have access to uploads.

#14 · January 30, 2021, 6:13 pm

combobox

Uploaded files:

You need to login to have access to uploads.

#15 · January 31, 2021, 12:49 pm

@javadrajabihakami attached complete sample with database included.
I think this time you will get it :)

Uploaded files:

You need to login to have access to uploads.

#16 · January 31, 2021, 1:17 pm

Hello and good morning, dear and honorable master
Thank you very much! Very big and dear ...! I do not know what sentence I can find to describe you! Thanks Thanks! He answered well ...

#17 · January 31, 2021, 2:04 pm

Great! :)

How to configure Combobox based on neoPhpExecSql? - Forum

How to configure Combobox based on neoPhpExecSql?