QUERY AND INSERT WITH COMBOBOX

[tomastoteles]

Hello community.

I'm looking for ways to display data from a database into a combo box, and once the show to insert what is chosen for this.

Could you please help?

Thank you!

GREETINGS!

[Klaus]

Hi tomastoteles,

what part is making problems: fetching data from database or putting this data into a combo box?

Sorry, don't understand this part:

Code: Select all

...and once the show to insert what is chosen for this.

?


Best

Klaus

P.S.
Please do not use all caps (thread titles), that is considered SCREAMING on the internet

[tomastoteles]

Hi Klaus! Thanks for answering.

First of all, an apology, I forgot for a moment the rules of Netiquette lol ...

and well, I want to retrieve data from MySQL and display them in a combobox.

Thanks and best regards!

[Klaus]

Hi tomastoteles,

...and well, I want to retrieve data from MySQL and display them in a combobox.

yes, THAT'S what I understood so far, but does not answer my question:

what part is making problems: fetching data from database or putting this data into a combo box?

since you now already know how to fetch images form a database, you should be able to fetch data from the database in general, right?


Best

Klaus

[tomastoteles]

Hello Klaus.

Yes, well, you're right ... Apparently yesterday was in no mood to think LOL.

Forget it, and sorry ...

Leave the solution to my problem (very easy), maybe someone will serve:

Code: Select all

  global conID
   put "SELECT *  from Programas" into PSQL
   
   put revDataFromQuery(tab,cr,ConID,pSQL) into pRecords
   
   if pRecords begins with "revdberr" then 
      answer error "Hubo un problema con los datos de la Base de Datos" & pRecords
      exit to top
   end if
   
    put pRecords into btn "Programa"

xD

Greetings! And thanks!

[Klaus]

Hi tomastoteles,,

I did not mean NOT to help, just wanted to know what you can solve by yourself!

OK, the script is OK in general, but "select * from tablename" will of course return ALL data
in that table in a TAB and CR delimited list.

And this is something that you CAN put into a button, but does not make sense nor will it be usable.
So what data from your table dou you want to display in your button?


Best

Klaus

[tomastoteles]

Hello Klaus = D.

I know, and really the solution was simple self ... Sometimes confused lol ...

I really wanted to do from the beginning and I did ... And take into account your recommendation ... But the combo box data shows me he wanted from MySql ... Like I said, the solution was in sight, and you helped me realize it = D

Thank you very much, and hope they serve so I stopped in this post = D


Best regards! and thanks again!