Multiple Select for Grid application

Applications Grid / Reports
#1

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)

#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

#3

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.

#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)

#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 :confused:

If you got other solutions, please share it also :o

Regards.

#6

[QUOTE=MySJ;29148]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 :confused:

If you got other solutions, please share it also :o

Regards.[/QUOTE]

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