SQL queries and slots

[wysota]

Connect to a single custom slot which simply calls the five methods you want to execute.

[fnmblot]

You mean something like this?

connect(ui.firstPB, SIGNAL(clicked()), this, SLOT(firstPBSlot()));

connect(ui.firstPB, SIGNAL(clicked()), this, SLOT(firstPBSlot()));

To copy to clipboard, switch view to plain text mode 

and then have

void nnDBSPieceViewForm::firstPBSlot()
{
      clearTextDateFields();
      pieceQuerySlot();
      changeEntryByUID();
      setFormValues();
      navPBCheck();
}

void nnDBSPieceViewForm::firstPBSlot()
{
      clearTextDateFields();
      pieceQuerySlot();
      changeEntryByUID();
      setFormValues();
      navPBCheck();
}

To copy to clipboard, switch view to plain text mode 

[wysota]

Yes, something like that.

[fnmblot]

Wow! Worked like a charm! I condensed 900 lines of code to 275. Now I just need to figure out how to create a login dialog prompt for my users to connect to the db and I will be complete and ready to put it out on kde-apps. Can anyone maybe direct me to a howto or some other open source code for this, please?

Thanks in advance,

fnmblot

[wysota]

If you're lazy then: QInputDialog.

[parmanax]

hi there fnmblot!

did you implement the database in MySQL? I have created a mysql database and would like to write some kind of interface with qt? Any specific C++ windows interface to suggest? which did you use? can you send me some kind of sample code to get an idea how somthing like this can be implemented?

thanx in advance!

lara

[fnmblot]

Well, I am not really feeling lazy about it. I am currently looking at the sqlbrowser in the demos. But thanks for the suggestion.

Parmanax, I will post my code here later today.

fnmblot

[parmanax]

Hi there,

just to remind you to post your code if this is of no inconvenience to you. Would be really very nice to have it as a starting point to go. Thanks in advance!

Lara