Posts by debasisdas

Try using scheduled jobs, if your database is ORACLE.

Please help me in the following matter:-

vb6 Ado database connection
vb6 Ado recordset connection
show record
add record in database
delete record from database
edit record from database
find record from database
and all sort of ado connection

and add record in datagrid
Please give me solution.

That simply means you need to read books .

What about using VB 6.0 wizard to create any database application from scratch and check the code that system generates for you.

Check if you have permission and can call the components of the Yahoo Messenger in your own application.

hi neha..........can i know how much time is left with u

She has already graduated and does not need your help any more. You need to check the date of post at least before posting to such a historic threads.

you need to open the recordset with multiple columns and then to add to the list box try this

list1.additem (rs(0)&"  " & rs(1) & "  " & rs(2))

what you are concern about , is it the duplication of relations ?

How much you are ready to pay me for that ?

Please do not hijack others threads.
Always start a new thread for your own question.

You need to read this to the solution to your question.

Kindly post the code that you are working on and also mention the part that you are struck with or having any error.

I am ready to upload.

How much you are ready to pay me ?

Since you are storing user name and password in database, user name field must be the PK of the table(so it is unique and can't be null).

Assuming the above criteria.

run the following query

SELECT COUNT (*) FROM TABLE_NAME WHERE USER_FIELD='USERNAME_THAT_YOU_ENTERED' AND PASSWORD_FIELD='PASSWORD_THAT_YOU_ENTERED'

If the above query returns one (the query will never return >1 as per the above assumption) you have passed correct credentials. In that case proceed further , else re-prompt for the login credentials.

Hi Ramya,

Welcome to Daniweb.

You are welcome to ask all your computer related doubts but in specific sections of the forum only.

That is the way to learn.

We all did that to learn what we have learned today.

Hello

from all of us here.

Hello

Welcome to Daniweb.

You can join the tables based on user ID in both the tables and retrieve the desired data.

if that contains picture, that works directly in crystal report(you can directly drag the filed to report area). I am not sure of Data report.

Do you know how to populate data from/to a DB into/from a DataGrid/DBGrid ?

Database table is a 2D array only.

You need to read this for a complete explanation.

You only need to change the connection string to access the database.

There would hardly be any changes to your VB code for MySQL.

You are a star in my private galaxy.

That depends on your requirement.

ex
USERS
----------
ID
FIRST_NAME
LAST_NAME
........
........
etc

RELATIONSHIP
---------------------
R_ID
U1_ID
U2_ID
R_TYPE
R_DESC
........
........

etc

You need to generate the PK value dynamically based on system date using a procedure. For the serial number use a SEQUENCE to generate a serial of non-repeating numbers.

If one understands what is ON DELETE CASCADE and how/ where to use that and where not ,that piece of code would definitely not look surprising. There is no magic or tricks in that, that is pure logic. ON DELETE CASCADE is designed for that only.

What exactly you want, What is the data type of that PK field ?
Please pass more information.

Why you need to store the data in the client machine in case of a online application ?

If you want something free try to go for oracle Express

What about storing the users(contacts) and the relationship details in separate tables and linking them using PK and FK.

If you have designed the DB (something to start with), Please post the ER here. That will be really helpful to add to your ideas.

^ needs some rest
< needs some rest
V needs some rest

"Love is the delusion that one woman is different from another".
Oscar Wilde

"Love is the delusion that one woman is different from another".
Oscar Wilde

Try to access the DLL or other componenets of the tool to achieve the same from your own application

You need to join the tables to fetch the data from multiple tables.

Definitely there is no potential danger, but as time pass this thread will go down the memory line. Once it goes pas t the 2nd page i don't think anyone will ever open it unless someone runs a search with specific key words. So my idea was if it is an article (as the number is less) that would be easily accessible to others. As you say there is no problem with this approach i have nothing more to say.

Regards,
Deabsis

i have added the .addnew method to look like the following but it now ads a new row with blank fields and only one field at the end.

that is because you have assigned value only for one field (copiesremaining) not for others.

If you know something and want to show your knowledge then please do not post those here as questions. Better post those as an article ,that will really help the new members.

If you know something and want to show your knowledge then please do not post those here as questions. Better post those as an article ,that will really help the new members.

Does the device respond to any command from the system COM port ?

You need to call AddNew or Edit method before calling Update.

Tanhayee------------Sonu Nigam

no

have you ever been fired from your job ?

Hi Jerry,

welcome to daniweb.

Hi Fritz,

Welcome aboard.

Hi Fritz,

Welcome aboard.

Welcome to daniweb.

Hi Aparna,

Welcome aboard.

As i have already suggested to go for something like Oracle, that will solve your all data size issues. And retrieval data time depends mostly on how the database is designed rather than size only.

what kind of data file you are using.

use two database connection
1 for access
2 for excel
read from excel and write to access.

can you connect the device to system using COM port or something ?