Announcement

Collapse
No announcement yet.

Multiple Select for Grid application

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiple Select for Grid application

    Hi, is it possible for me to have multiple SQL SELECT? and store each of them in an array?

    I can't seem to have decent results selecting the queries all at once. since I have bad data in my database(which is a lot).

    right now I can't organize the (old)data but if I can have multiple SELECT or queries I can have my code working fine. (i tried it in a blank form and it works but this time I want to use the GRID application)

    Or if you have any suggestion I would really appreciate it!

    thanks! (y)
    Last edited by andre963; 11-06-2014, 03:06 AM.

  • #2
    you can display the field from type double-select in grid, it will be displayed nicely. If you have this field with data, add the field to your grid and chose proper field type like integer, text..etc. go to lookup section and choose multiple values: Yes, put valid delimiter there you go

    Comment


    • #3
      Originally posted by MikeDE View Post
      you can display the field from type double-select in grid, it will be displayed nicely. If you have this field with data, add the field to your grid and chose proper field type like integer, text..etc. go to lookup section and choose multiple values: Yes, put valid delimiter there you go

      Thanks! but what i mean is I kinda need another SQL select... for another data/relationship/other things. I wanted to have multiple SQL select.

      Comment


      • #4
        ok where you want it? can you please explain more, perhaps will clear what you want to do because it is not clear (for me)
        Last edited by MikeDE; 11-06-2014, 05:05 AM.

        Comment


        • #5
          Hi Andre963,

          If I need data from several tables, I created a View. Use the SQL builder to test the result (using appropriate JOIN, as needed). When I got the correct datasets I need, I paste this SQL statement in my Create VIEW statement. Thén I used this View in creating GRID application. I'm not sure if this is the best solution, and I hope I got your question right

          If you got other solutions, please share it also

          Regards.

          Comment


          • #6
            Originally posted by MySJ View Post
            Hi Andre963,

            If I need data from several tables, I created a View. Use the SQL builder to test the result (using appropriate JOIN, as needed). When I got the correct datasets I need, I paste this SQL statement in my Create VIEW statement. Thén I used this View in creating GRID application. I'm not sure if this is the best solution, and I hope I got your question right

            If you got other solutions, please share it also

            Regards.
            good idea MySJ, hopefully it is what the dude wants, perhaps he wants a data from different tables!? language barriers I think

            Comment

            Working...
            X