How to view and select the information of one field from one table in another tab! In the table editing section! - Forum

Forum Navigation
You need to log in to create posts and topics.

How to view and select the information of one field from one table in another tab! In the table editing section!

Hello and good time dear friends ...!
How to get the information of a field from a table! For example: year! See and select another table in the edit section? Thanks

Uploaded files:
  • You need to login to have access to uploads.

Hi @javadrajabihakami, sorry I don't undertand your question. But perhaps this thread helps you:
https://visualneo.com/forum/topic/neotable-neotablesetcolumn-and-subroutine-to-format-the-data

Regards.

Hello and have a good time ...! Thank you for your kindness dear friend!

I meant we have 2 tables! Table a: Year
Table b: Students!
Now, when we want to edit the students' school year, for example! By choosing their year! We can view and use the year data we have stored in Table a in the Student Year Editing section!

@javadrajabihakami you just need to call the appropriate "SELECT" SQL query whenever a year is chosen to get the data you need to show on the table. Please take a look at the Database Tutorials in our YouTube channel to learn how to send parameters to a SQL query in VisualNEO Web.

Regards.

Hello and good time dear friend! I watched almost all the videos! They are very good and excellent and practical! But I want to use the ((neoTableEditColumnAsSelect) command when I'm in the table editing section! I can display the data of, for example, a column from another table where the data of the year is located and select it! Thanks a lot

@javadrajabihakami yes, you need to generate the neoTable again using neoTableEditColumnAsSelect with the data you get from the other table.

Regards.

Hello and good time and thank you for your response dear friend! I can not see all the data inside a column this way! For example, it shows one to 9! Thank you for taking a look at my example and guiding me! Thanks a lot

Uploaded files:
  • You need to login to have access to uploads.

@javadrajabihakami take a look at the modified sample.
Regards.

Uploaded files:
  • You need to login to have access to uploads.
javadrajabihakami has reacted to this post.
javadrajabihakami

Hello and good time dear friend ...! Thank you very much for your kindness! Thank you very much! I am definitely a very bad student ...

I am definitely a very bad student ...

I don't think so. Don't give up and soon you will be helping others, including me :)

Quote from luishp on April 28, 2021, 6:58 am

@javadrajabihakami take a look at the modified sample.
Regards.

Shame, if we want to show the classes of a school like this! What should we do? It only adds the number that we specified to it with 1 and continues up to 9 in the loop! But I want him to do this, for example, with the classes of a school! Thank you for your guidance in this regard! Thanks a lot

Please take a look at my sample! I can not edit the table! Show the classes well! All displayed together. Thank you very much

Uploaded files:
  • You need to login to have access to uploads.

@javadrajabihakami you need to add a "\n" after each item (except last one) to separate them.
Take a look at the attached image.

Regards.

Uploaded files:
  • You need to login to have access to uploads.
javadrajabihakami has reacted to this post.
javadrajabihakami

Hello and thank you for your response, dear friend ...
Thanks a lot, but an extra token is added to each of the options! the mark (,)
For example :
اول
, دوم
, سوم
This sign (,) should not be at the end of the options! Thank you for your guidance in this regard! I am very, very ashamed of you dear friend!

Dear friend, thank you very much! The problem was with my code! My problem is solved! Thank you

@javadrajabihakami I see... that's because you have used and Array instead of a simple variable to store the items.
Please take a look at the attached fixed sample.

Regards.

Uploaded files:
  • You need to login to have access to uploads.
javadrajabihakami has reacted to this post.
javadrajabihakami

Thank ! Yes that's it ...