SQL feedback

[dlanyer77]

---

I was waiting for someone to say this, thanks MarkCuering.

if you're good and smart then why would you wait for anyone to open up a mediocre suggestion intended to hit me. now, the question is, what would i get amplifying such a suggestion and besides you are asking about the progress bar and the database event. In a nutshell, the reason why you never learn is that you have a wrong aversion over things that's supposed to be great, wonderful and glorious.

i don't think my response were egoistic. it is how i understand what you want. if i misrepresent it then don't follow it, as simple as that.

i am responding your inquiry more formally than just casually. there is no marketing tactics behind it all.

lastly, i am not here to seek only to fleece the ignorant masses through poor personal advertising.

[dlanyer77]

This time, just try to figure it out by yourself javapenguin, sometimes we have to bite some lazy awkward suggestion, which in the first place better not to... it only hold two things respectively, it’s either nagsisinungaling or nagyayabang

It is clear enough that you are making some distinction in what you said. Realistically, I can see you setting on a nice and expensive car but not having any audience impact.

It sounds to me like you are doing this with your colleague because you feel you should.

Not that everyone reading this post needs to learn the "eye-ball only" issues, but just for the sake of comprehension, would you please tell what those two issues were and what are your basis of "nagsisinungaling or nagyayabang"?

[UtOkbOlinAO]

Does SQL server give feedback about the progress so it is will be possible to reflect or bind it with the progress bar?

it's a big YES... makahatag man ug progress ang SQL server to bind it with a progress bar...

As a system developer in my company, ingon ani ang kadaghanang request sa among mga users

dinhi sa among company.. Kanang naay progress bar during inquiry of data...

[javapenguin]

if you're good and smart then why would you wait for anyone to open up a mediocre suggestion intended to hit me. now, the question is, what would i get amplifying such a suggestion and besides you are asking about the progress bar and the database event. In a nutshell, the reason why you never learn is that you have a wrong aversion over things that's supposed to be great, wonderful and glorious.

i don't think my response were egoistic. it is how i understand what you want. if i misrepresent it then don't follow it, as simple as that.

i am responding your inquiry more formally than just casually. there is no marketing tactics behind it all.

lastly, i am not here to seek only to fleece the ignorant masses through poor personal advertising.

Good to hear from you, your really cool with your words, great potential of a really good lawyer and probably even more, well anyway some say it's possible and some say it's not, that's the beauty of it all, thanks to you, you have made this thread an interesting one but special thanks goes to those who contributed code samples and work around solutions.

[MarkCuering]

It is clear enough that you are making some distinction in what you said. Realistically, I can see you setting on a nice and expensive car but not having any audience impact.

It sounds to me like you are doing this with your colleague because you feel you should.

Not that everyone reading this post needs to learn the "eye-ball only" issues, but just for the sake of comprehension, would you please tell what those two issues were and what are your basis of "nagsisinungaling or nagyayabang"?

I was actually referring from previous post

i tested it with Oracle 10g, MySql, MSAccess and SQL server. if you want to have a clear understanding about what we mention here then all you need is your fingers and enter "how to use progress bar" into the google search field.

happy coding!

You’ve said that you tested it with Oracle 10g, MySQL, MsACCESS and SQL server, but you didn’t even mentioned a few procedures on how you able to get it, instead giving him such words that made him looks like dumb grade school pupil! Where in the first place he wouldn’t mind asking, if he was… The way you deliver the mode of your answers and suggestions, makes me wonder if you ever had or given such Respect!

Man, I even tried my own way to solve his problem, and just now PMed him regarding the possibilities that I’ve found…

I was looking it on sqlite as I have a complete copy of it… looking it on a CALLBACK functions, that it can be made possible if you will compile your own modified version of it.

#include <stdio.h>
#include <sqlite3.h>

static int callback(void *NotUsed, int argc, char **argv, char **azColName){
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv : "NULL");
}
printf("\n");
return 0;
}

int main(int argc, char **argv){
sqlite3 *db;
char *zErrMsg = 0;
int rc;

if( argc!=3 ){
fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
exit(1);
}
rc = sqlite3_open(argv[1], &db);
if( rc ){
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(1);
}
rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
if( rc!=SQLITE_OK ){
fprintf(stderr, "SQL error: %s\n", zErrMsg);
sqlite3_free(zErrMsg);
}
sqlite3_close(db);
return 0;
}

I found related issues of MySQL board, a short specification for an extension of the client/server protocol. This is what they mentioned:

Add 'progress' packages to the protocol and let the client register a
callback function that will be called for each progress package.
This allows the client to implement a 'progress bar'.
The package should include two numbers: Current record position and
estimated end record position.
This doesn't have high priority, but should be thought of.


In deed I got some chances on this, but I could not follow, as I’m not a seasoned system developer as you are. I don’t know if this is really implemented on their recent releases, as it may affect performance and must not be present at all times. But it is good to try it first in sqllite as it may carry the same concept…the only difference I guess is you will be working it on thread pools (in case of SQL server).

If only I had plenty of time… but for now, at least I know where to find… happy to share some insights duh by not just telling the user to get out and beg it to Google. LOL…

[i]What a happy life ^_^

[BadDudes]

I was actually referring from previous post
Add 'progress' packages to the protocol and let the client register a
callback function that will be called for each progress package.
This allows the client to implement a 'progress bar'.
The package should include two numbers: Current record position and
estimated end record position.
This doesn't have high priority, but should be thought of.
[i]What a happy life ^_^

@mark... for a long time never had successfully made a progress bar from Oracle datasource (kulang ug praktis heheheh) but is it possible ba to identify how many records / record positioning being manipulated especially if stored procedure or package is being called from the front end?

[javapenguin]

@MarkCuering
Thanks for the sample code and insight, really appreciate your effort, I hope to be able to reciprocate in the future.

[dlanyer77]

Is it possible with MySQL? What database have you tested? Do you have any suggestion on how I can google this? Thanks in advance.

giving him such words that made him looks like dumb grade school pupil! Where in the first place he wouldn’t mind asking, if he was… The way you deliver the mode of your answers and suggestions, makes me wonder if you ever had or given such Respect!

@MarkCuering
if you decide to push an issue, do it intelligently. deal with javapenguin's post, analyze it. now, tell me who starts a kiddie question? if you do appeal, don't rely on your meaningless tales and imagination unless there are special reason behind. you must avoid singling out individuals. Focus on relevant issues not on the person associated with the issue.

a good decision about how much brilliant idea is enough is necessarily based on your skill and judgment, as you consider the factors that bear upon that issue.

so don't worry about finding a formula on how to show up. worry about using your head. though it's not a sin not to use your head but it's a sin to be careless, thoughtless, or not to learn from your experience.

[silent-kill]

i suggest we put this thread to close ....
there are things better left unsaid, although we have different understanding on different situation.... we have to consider other people's feelings.

it is best to stay polite at all times, after all we are educated people trying to answer the same question.

not people, stroking his/her own EGO by proving someone's else answer wrong, and provoke more agitation, unless of course im wrong... then forgive me.

calling BadDudes...

[javapenguin]

We differ in personality so we respond differently. In my opinion I see dianyer77 answer too precise, nevertheless it is still appreciated and he has a good point as well, but most people appreciate if you do the extra mile by answering beyond what has been asked. Those who shared codes, insights and more elaborate suggestions are indeed generous and has showed a good example to follow.

Let's get back to the topic please...