Posts by debasisdas

you need to check for existance of the ID before trying to insert a new record. If it exists prompt the user to enter a new ID or can increment the max(id) by 1 and continue.

I mean to say that i didn't check in VB6 environment.

What exactly is the issue for you ?

You need to create a separate table for POINTS and assign some score for each position. That needs to be implement as a look up table in your database.

I don't think that is an database issue.

who has designed the DLL ?
Try to get it registered with windows by using REGSVR32 key and recheck.

That needs to be implemented as part of your database design.

go ahead and post your database design here.

You question should have been posted in vb.net section of the forum.

Does your application connects to any database for the list of items ?

Your looks ok (i did not check in IDE )

Are you getting any error from your code ?

Please check the auto generated code in inbuilt wizard in VB 6 .

Can you please clarify a bit. What exactly is the requirement ?

thats the main problem....till you take initiative and start writing and post the code that you are working on, no one here is going to write code for you.

so what is the problem ?

post the code that you aare working on currently to get any help from experts.

NOTE:---You need a procedure not a function.

a simple subtraction of birthdate from sysdate will do the trick for you.

You need to understand the actual requirement before jumping into database design.

I have requested them if possible to increase it to 100 gig or even to terabyte.

Go for Oracle , version 10g supports 8 million terabytes.

I think that would be enough for all your data.

So what is the problem ?

student Id is not the Primay Key in Test_StudentSubjectTrans.

Is there a chance that your SqlCommand or the corresponding SqlConnection is shared and used by multiple threads and one of them might have closed the connection (socket/handle)?

If the application uses one connection from multiple threads then, If one thread closed the connection, and another tried to use it it could generate this error.

You still need to go through the other steps - check the
logs, check the network connectivity, etc.

By knowing more about the project .

What about reading books ?

change style to graphical and then set the icon property.

first of all you need to correct the database design
1. there is no primary key in any of your tables
2. why tables are joined on name and description field ?
3. what are those gur... and NOK.... fields ? (needs to be moved into some new tables)
4. what is th euse of empidno while you already have empid field in the table.

once you fix the above mentioned issues do post back.

Please reframe the question, explaining the exact requirements clearly.

Better prevent and prepare than repent and repair.

If I get a disease, I am to be blamed.

what about creating two tables
1..containing the user information
2..containing the users files information.
and linking both

To avoid unnecessary extra joins which can be avoided to retrieved data.

You need to understand the theory part of distributed database , before trying to understand it.

for example ----try to use a DB link (in oracle) to connect to different database servers and fetch the data using a single SQL.

try this query

CREATE VIEW TopLevelCust AS
SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit
FROM Customer
WHERE CreditLimit >= 10000;

You need to use the trigonometric functions SIN and COS for the purpose and use the X,Y co-ordinates of the control for position.

Option 1---- point the application to the latest JVM location.
Option 2---- download the version of SQL Developer that comes bundled with JVM.

everyone can teach me???

but who will pay me ?

Format the dates as per the NLS setting of your target oracle database and try again.

are you able to connect to the database from another system using the same tns file.

You need to use UTL_FILE predefined package for the purpose.

how you have formatted the dates ?

please find the details here.

you can use that

try this if using ADODB for database connection.

conn.begintrans            'ADODB connection object.
conn.execute "your insert statement goes here"
conn.committrans

What is the code that is throwing the mentioned error message ?

all icon files comes with .ICO extension. You may also able to use .CUR (Cursor files) also.

You need to use Common Dialog Control for that functionality.

1. You can use DBMS_JOB or DBMS_SCHEDULER on a Oracle DB to execute a procedure at interval .

Other questions are totally irrelevant without the knowledge of the actual requirement.

What is l_employees ?

It does not have any definition in your code .

try this

#
rs.open "select * from table2 where gender='" & cbgender.list(cbgender.listindex) & "'",conn,adopenkeyset,adlockoptimistic,adcmdtext
#

this code should fire after selection of the combo box not before that

by writing some SQL.

What is the database that you are working on ?

what is the code that you are working on ?

You need to add ORDER BY clause to your SQL.

Select the field on which you need to sort (may be payment _date in your case)

Yes

exactly.

You need to concatenate the fields to display as address and then populate the grid with the address field.

Please find the details here
here and here.

Have you designed the database according to your requirement ?