August 2004 - openSUSE Programming - openSUSE Mailing Lists

Again the output format of QDate, addDays() and currentDate()
by Prabu Subroto 09 Aug '04

09 Aug '04

Dear my friends.. I am still confused how to use the QDate and QDateEdit. 1. How can I issue the current date with QDate. 2. I want to add the currectDate with some days (addDays() ). 3. I want to detemine the output of the QDateEdit to become "yyyy-MM-dd". Here what I've done: ============= QDate tgl; QDate appdate = tgl->currentDate(); if ( appdateEdit->isEnabled() ){ appdate = appdateEdit->date(); } else{ if ( hari1radioButton->isChecked() ){ appdate = tgl->addDays(1); } if ( minggu1radioButton->isChecked() ){ appdate = tgl->addDays(7); } if ( hari14radioButton->isChecked() ){ appdate = tgl->addDays(14); } if ( minggu4radioButton->isChecked() ){ appdate = tgl->addDays(28); } } QTime apptime = apptimeEdit->time(); QString warned = "N"; QString sqlapprep = QString("insert into appointment (noapp, custid, salesid, date, time,done, warned) values('%1', '%1', '%1', '%1', '%1', 'N', 'N')") .arg(noapp) .arg(cid) .arg(sid) .arg( appdate.toString("yyyy-MM-dd") .arg( apptime.toString ); =============== And here is the error message as I compiled my code: In file included from .ui/funonseqform.cpp:38: funonseqform.ui.h: In member function `virtual void funonseqForm::sendreportSlot()': funonseqform.ui.h:279: error: base operand of `->' has non-pointer type `QDate' funonseqform.ui.h:287: error: base operand of `->' has non-pointer type `QDate' funonseqform.ui.h:290: error: base operand of `->' has non-pointer type `QDate' funonseqform.ui.h:293: error: base operand of `->' has non-pointer type `QDate' funonseqform.ui.h:296: error: base operand of `->' has non-pointer type `QDate' make: *** [.obj/funonseqform.o] Error 1 patrixlinux@patrix:~/arsip/proyek/qt/kv/client> ======== Please tell me where my mistake. Thank you very much in advance. __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail

1 0

http://publib.boulder.ibm.com/infocenter/comphelp/index.jsp
by Steven T. Hatton 09 Aug '04

09 Aug '04

http://publib.boulder.ibm.com/infocenter/comphelp/index.jsp -- Regards, Steven

1 0

QSqlSelectCursor * cur = new QSqlSelectCursor(stringsql); //dynamic query
by Prabu Subroto 06 Aug '04

06 Aug '04

Dear my friends... I found QSqlSelectCursor on the doc.trolltech.com . I want to use it for dynamic query. I did like this: void funonseqForm::sejarahSlot() { cid = QSpinBoxCustid->value(); QSqlDatabase * bd = QSqlDatabase::addDatabase("QPSQL7", "OTHER"); bd->setHostName("192.168.23.237"); bd->setDatabaseName("kv"); bd->setUserName("postgres"); bd->setPassword(""); if ( ! bd->open() ) { bd->lastError().showMessage(); } QString stringsql = QString("select salesid, report, emoicon, timestamp from //salesreport where custid=%1").arg(cid); QSqlSelectCursor * cur = new QSqlSelectCursor(stringsql); hisdataTable->setSqlCursor(cur, true, false); hisdataTable->refresh(); } But the application meet a trouble "An error occured while accessing the database" if it executes the "sejarahSlot()". Where is my fault? is it because QSqlSelectCursor only can not use a variable as its query string? So how can I make a dynamic query with QSqlSelectQuery? Thank you very much. --- Sean Harmer <sean.harmer(a)aeat.co.uk> wrote: > Use QSpinBoxCustid->value() instead. > > Sean > > On Friday 06 August 2004 12:20, Prabu Subroto wrote: > > Dear my friends... > > > > I want to diplay the salesreports only for a > > determined customer (with custid) into a > QDataTable. I > > use QSqlCursor for doing "select" from a view > (false > > table). > > > > I did like this: > > " > > void funonseqForm::sejarahSlot() > > { > > cid = QSpinBoxCustid->text(); > > QSqlDatabase * bd = > > QSqlDatabase::addDatabase("QPSQL7", "OTHER"); > > bd->setHostName("192.168.23.237"); > > bd->setDatabaseName("kv"); > > bd->setUserName("postgres"); > > bd->setPassword(""); > > if ( ! bd->open() ) > > { > > bd->lastError().showMessage(); > > } > > > > QSqlCursor * cursor = new > > QSqlCursor("salesreport", true, bd); > > cursor.select("custid = %1").arg(cid); > > custdataBrowser->setSqlCursor(cursor, false); > > custdataBrowser->refresh(); > > } > > " > > > > but I got this error message in compiling process > > > > In file included from .ui/funonseqform.cpp:34: > > funonseqform.ui.h: In member function `virtual > void > > funonseqForm::sejarahSlot()': > > funonseqform.ui.h:36: error: invalid conversion > from > > `const char*' to `int' > > funonseqform.ui.h:48: error: request for member > > `select' in `cursor', which is of non-aggregate > type > > `QSqlCursor*' > > make: *** [.obj/funonseqform.o] Error 1 > > patrixlinux@patrix:~/arsip/proyek/qt/kv/client> > > > > how can I change the data type from the text of > > QSpinBox (QString) into "int"? > > > > And how can I do a selection with > QSqlCursor.select() > > but the value of cid variable must be whenever > > changeable. > > > > Thank you very much in advance. __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail

1 0

cursor.select("custid = %1").arg(cid);
by Prabu Subroto 06 Aug '04

06 Aug '04

Dear my friends... I want to diplay the salesreports only for a determined customer (with custid) into a QDataTable. I use QSqlCursor for doing "select" from a view (false table). I did like this: " void funonseqForm::sejarahSlot() { cid = QSpinBoxCustid->text(); QSqlDatabase * bd = QSqlDatabase::addDatabase("QPSQL7", "OTHER"); bd->setHostName("192.168.23.237"); bd->setDatabaseName("kv"); bd->setUserName("postgres"); bd->setPassword(""); if ( ! bd->open() ) { bd->lastError().showMessage(); } QSqlCursor * cursor = new QSqlCursor("salesreport", true, bd); cursor.select("custid = %1").arg(cid); custdataBrowser->setSqlCursor(cursor, false); custdataBrowser->refresh(); } " but I got this error message in compiling process In file included from .ui/funonseqform.cpp:34: funonseqform.ui.h: In member function `virtual void funonseqForm::sejarahSlot()': funonseqform.ui.h:36: error: invalid conversion from `const char*' to `int' funonseqform.ui.h:48: error: request for member `select' in `cursor', which is of non-aggregate type `QSqlCursor*' make: *** [.obj/funonseqform.o] Error 1 patrixlinux@patrix:~/arsip/proyek/qt/kv/client> how can I change the data type from the text of QSpinBox (QString) into "int"? And how can I do a selection with QSqlCursor.select() but the value of cid variable must be whenever changeable. Thank you very much in advance. __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

1 0

Re: [suse-programming-e] QDataBrowser can not display bpchar(150)
by Prabu Subroto 05 Aug '04

05 Aug '04

Hi Brad... I am so confused because the QLineEdit was defined by the Qt Designer. I create the QDataBrowser from Qt Designer and the QDataBrowser generate the QLineEdit by themselves. I try to define this line " QLineEditCompany = custdataBrowser->field("custid").QString(); " in the constructor ( init() ) but of course if I click the button of "next"/"last"/"previos"/"first" than the content of "company" field will not be displayed anymore. Please tell me your solution. Please.... Thank you very much. ==== void funonseqForm::init() { retrieve(); } void funonseqForm::retrieve() { QSqlDatabase * bd = QSqlDatabase::addDatabase("QPSQL7", "OTHER"); bd->setHostName("192.168.23.237"); bd->setDatabaseName("kv"); bd->setUserName("postgres"); bd->setPassword(""); if ( ! bd->open() ) { bd->lastError().showMessage(); } QSqlCursor * cursor = new QSqlCursor("v_cust_sven", true, bd); custdataBrowser->setSqlCursor(cursor, false); QLineEditCompany = custdataBrowser->field("custid").QString(); custdataBrowser->refresh(); } --- Brad Bourn <brad(a)summitrd.com> wrote: > been a while since I played with this stuff.... > > I know there is a way to reference the var as a > QString... > > > where is the actual data stored? > > like where do you try to fill in the lineedit? > > databrowser->fieldname ? > > if so, should be something like > > linedit = databrowser->field("fieldname").QString() > > > B-) > > > If you give me the exact syntax where you set the > lineedit var, I'll probably > remember. > > > On Wednesday 04 August 2004 11:49 am, you wrote: > > Dear Brad... > > > > But how? > > > > here is my code: > > === > > void funonseqForm::init() > > { > > retrieve(); > > } > > > > void funonseqForm::retrieve() > > { > > QSqlDatabase * bd = > > QSqlDatabase::addDatabase("QPSQL7", "OTHER"); > > bd->setHostName("192.168.23.237"); > > bd->setDatabaseName("kv"); > > bd->setUserName("postgres"); > > bd->setPassword(""); > > if ( ! bd->open() ) > > { > > bd->lastError().showMessage(); > > } > > > > QSqlCursor * cursor = new > > QSqlCursor("v_cust_sven", true, bd); > > custdataBrowser->setSqlCursor(cursor, false); > > custdataBrowser->refresh(); > > > > } > > === > > > > Thank you very much in advance > > > > --- Brad Bourn <brad(a)summitrd.com> wrote: > > > You should be able to set it to > > > QString > > > > > > B-) > > > > > > On Wednesday 04 August 2004 11:41 am, Prabu > Subroto > > > > > > wrote: > > > > Dear my friends... > > > > > > > > I am using postgres 7.2.x, Qt 3.2 and SuSE 9.1 > . > > > > > > > > I want to make the list of customer list with > > > > "previous", "next", "first" and "last" > buttons. > > > > > > > > Finally, I create this with QDataBrowser. > > > > Actually it works...the four buttons work as I > > > > expected. but what weird is that the QLineEdit > of > > > > Address can not display the value of the field > > > > "address". I define this field with > bpchar(150). > > > > > > Does > > > > > > > it has anything to do with the datatype? > > > > Which data type should I use? > > > > > > > > Please tell me where my mistake is. > > > > > > > > Thank you very much. > > > > > > > > > > > > > > > > __________________________________ > > > > Do you Yahoo!? > > > > Y! Messenger - Communicate in real time. > Download > > > > > > now. > > > > > > > http://messenger.yahoo.com > > > > > > -- > > > To unsubscribe, email: > > > suse-programming-e-unsubscribe(a)suse.com > > > For additional commands, email: > > > suse-programming-e-help(a)suse.com > > > Archives can be found at: > > > http://lists.suse.com/archive/suse-programming-e > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail - 50x more storage than other > providers! > > http://promotions.yahoo.com/new_mail > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail

2 1

memory Consumption
by Savvas Ladopoulos 04 Aug '04

04 Aug '04

Dear all, I have installed Suse 9.0 in two pcs. 1. A Pentium III with 256 MB of RAM. 2. A AMD 3200 with 1024 MB of RAM. Both have the same problem. Using top can see that used memory increases by 4-20kb every 1-2 secs and free is reduced by that amount. Further buffer size increases. Eventually all physical and swap is used and if unlucky will Hung too! Has anybody came across the same problem and if so what is set so wrong? Why buffer size increases all time ? Thank You, Savvas

3 4

QDataBrowser can not display bpchar(150)
by Prabu Subroto 04 Aug '04

04 Aug '04

Dear my friends... I am using postgres 7.2.x, Qt 3.2 and SuSE 9.1 . I want to make the list of customer list with "previous", "next", "first" and "last" buttons. Finally, I create this with QDataBrowser. Actually it works...the four buttons work as I expected. but what weird is that the QLineEdit of Address can not display the value of the field "address". I define this field with bpchar(150). Does it has anything to do with the datatype? Which data type should I use? Please tell me where my mistake is. Thank you very much. __________________________________ Do you Yahoo!? Y! Messenger - Communicate in real time. Download now. http://messenger.yahoo.com

2 2

Moving from current record to the previous or next record.
by Prabu Subroto 04 Aug '04

04 Aug '04

Dear my friends... I am using Qt, postgres and SuSE 9.1. I want to make 2 buttons, one is for moving to the previous record and one is for moving to the next record. but I find error message in compiling process: " patrixlinux@patrix:~/arsip/proyek/qt/kv/client> make g++ -c -pipe -O2 -march=i586 -mcpu=i686 -fmessage-length=0 -Wall -fPIC -Wall -W -O2 -march=i586 -mcpu=i686 -fmessage-length=0 -Wall -fPIC -D_REENTRANT -DQT_NO_DEBUG -DQT_THREAD_SUPPORT -DQT_SHARED -DQT_TABLET_SUPPORT -I/usr/lib/qt3/mkspecs/default -I. -I/usr/include -I/usr/lib/qt3/include -I.ui/ -I. -I.moc/ -o .obj/funonseqform.o .ui/funonseqform.cpp In file included from .ui/funonseqform.cpp:28: funonseqform.ui.h: In member function `virtual void funonseqForm::prevSlot()': funonseqform.ui.h:68: error: request for member `prev' in `this->cursor', which is of non-aggregate type `<unknown type>' funonseqform.ui.h: In member function `virtual void funonseqForm::nextSlot()': funonseqform.ui.h:74: error: request for member `next' in `this->cursor', which is of non-aggregate type `<unknown type>' make: *** [.obj/funonseqform.o] Error 1 patrixlinux@patrix:~/arsip/proyek/qt/kv/client> " Anybody would be so nice to tell me how to make them work? Thank you very much in advance. ===== Here is my code ===== void funonseqForm::init() { custdataTable->setNumRows(1); retrieve(); } void funonseqForm::retrieve() { QSqlDatabase * bd = QSqlDatabase::addDatabase("QPSQL7", "OTHER"); bd->setHostName("192.168.23.237"); bd->setDatabaseName("kv"); bd->setUserName("postgres"); bd->setPassword(""); if ( ! bd->open() ) { bd->lastError().showMessage(); } QSqlCursor * cursor = new QSqlCursor("v_cust_sven", true, bd); custdataTable->setSqlCursor(cursor, true, false); custdataTable->refresh(); } void funonseqForm::prevSlot() { cursor.prev(); } void funonseqForm::nextSlot() { cursor.next(); } __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

1 0

one view for 2 different tables
by Prabu Subroto 02 Aug '04

02 Aug '04

Dear my friends... I am developing a database application with postgres 7.2.x, qt on SuSE 9.1 . I am in a situation where I have to use QDataTable and I have to use QSqlCursor that support only 1 table manipulation ( QSqlCursor * cursor = QSqlCursor("viewpatrix", true, db); ). So, as a strategy I make a view. with this view I hope I can work with more than 1 table at a time. kv=# create view viewpatrix as select customer.custid, customerdescription.descr iption, customer.firstname, customer.lastname from customer, customerdescription where customer.custid=customerdescription.custid; but I have problems if I want to make data update and data insertion from the QDataTable because I don't know how the rule should be. kv=# create rule viewpatrixcustdesc as on update to viewpatrix do instead update customerdescription set description=new.description where custid=old.custid; CREATE RULE kv=# OK, it works if the user wants to update the data in table "customerdescription". should I simply create another rule like this: kv=# create rule viewpatrixcust as on update to viewpatrix do instead update customer set firstname=new.firstname, lastname=new.lastname where custid=old.custid; CREATE RULE kv=# But how to make that the user can I also update the data in the table "customer" (customer.firstname and customer.lastname). Is it possible to create one view but from updating/inserting the data in the coresponded rule than the records in more then 2 tables are also updated/inserted? Thank you very much for your help. __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

2 1