Posts by debasisdas

How fast you are able to connect to oracle server form any client on the same machine as your application . Is is faster than your application connection time ?

What exactly you mean by startup is very slow ?

changing the data type of a field is a bad idea.

Replace the comma with space in the string and then use LIKE search.

Try using this.

Or simply use the On Screen keyboard.

if you had replied to my question, you would have known the difference between the two.

Both query will fetch same output.

It is up to you to decide whether to use coding standards or not.

If you want that take my SQL else pick yours.

You can use either of the queries.

You can create a view like this

CREATE VIEW stu_sub AS SELECT st.studname, su.subjectname, st.marks FROM
    student st, subject su
    WHERE st.subjectcode = su.subjectcode

OR using your SQL and use that.

Ok, to answer your question, you can use either of the queries. Both will give you correct data in the output.

Have you tried using SendKey {BREAK}

If you do not understand my answers why should i reply, what is the use ?

You are right . :)

But to understand my answers, you need to have some basic understanding of SQL.

My question is just to test that.

My question is still open to you. The sooner you reply, the sooner you will get reply :) .

Yes, and if still the problem is there try to remove the order by temporarily.

That is a question from my side to you.

Are you using all the 39 fields in the report ?

Does that involves a complex query or fetching too many records ?

Many implications to this, but this is not the place to address them.

Exactly.

st. ---- used in query is the table alias. It is a fully qualified name of the field.

Ok, tell me how will you display subjectcode after joining both the tables.

can u post some sample data.

I think you do not need the HAVING part of the SQL.

If you know what is the source code for all those files ,you can definitely recompile those source code to generate the component.

Those seems to be custom controls, Only the author can provide you those.

You need to ask you client for those files.

Once you have the files with you , you need to register those with windows using regsvr32 key.

Your tables should be joined like this

SELECT st.studname, su.subjectname, st.marks FROM 
student st, subject su
WHERE st.subjectcode = su.subjectcode

Do you have both the OCX files with you ?

If you are already getting the desired output using your SQL by joining both the tables, simply create a view based on that SQL. Once the view is created no need to write your SQL again and again. You can directly select from the view.

which part you do not understand ? creating view ?

Put this in a batch file and call as desired.

for /f "tokens=2,3,4 delims=/ " %%a in ('date /t') do set fdate=%%a%%b%%c
for /f "tokens=1,2,3,4,5 delims=: " %%a in ('time /t') do set ftime=%%a%%b%%c%%d%%e
exp userid=DEBASIS/DEBASIS@DEBASIS_DB file=C:\BACKUP\backup%fdate%%ftime%.dmp log=C:\BACKUP\backup%fdate%%ftime%.log

Lets see the query you are working on, to solve your assignment.

1. create a backup script.
2. store it in the server.
3. call it remote when required.

You need to run the EXP utility from the user account.

in VB 6 or in .NET ?

adodc is a control to connect to the database and is not a database itself.

You cam also use FileSystemObject.

This may be helpful to you.

What you need to use is proper key words for search, will will always hit what you are looking for.

You need to use GROUP BY clause in your query.

i think you said you want to find the highest block_id

then why using max(unique_id)

How you populate the grid ? is it not from recordset ?

have you opened the record set ?

that can be done using a view also.

If you have Hugh records, the insert into temp table will take a lot of time.

if you are simply selecting from other tables , why need to store the result set.

why not use a view instead.

I dont understand the code. No where in the code mentioned to insert the image

SavePicture()---does that for you.

as i said this only a sample and is not fully customized to cater to your exact requirement.

first insert a record into database without he document and then modify the code in the link.

your procedure contains only the SQL , and nothing else ?

have you tried for those file formats ?

So what are you doing after that SQL query ?

Please read this and this.

these are sample codes only.

You need to fix the other joins as well.