Posts by debasisdas

what about file name ?

Requirement is not clear.

How you set which file to play using the control ?

The solution is here.

Experience can not be explained.

From VB use ADO to connenct to database.

Please find the connection string here.

let see the code that you are working on.

ADODC is not a database, it is a control to connect to database.

use ADODB and try this code

cn.begintrans  ' cn--adodb connection object
cn.execute "your update command goes here"
cn.committrans

What is the problem if you store the complete date, you can always display only the month and year part for any reporting. You can't store 00 as a date value.

Another option is to store the month and year values as string not dated.

Welcome aboard.

Welcome aboard.

What is the expected result ?

you need to join both the tables based on room id.

You need maintain two separate tables, one for rooms information and another for bookings information.

Welcome aboard.

nope :)

What nope ?

If it is one value or more always better to store securely , preferable in DB.

What about using database for the purpose.

No a separate table for booking information , there you need to store room number with booking start and end time with date.

Check for proper syntax in your code.

Are you storing the username and password in database ?

Not necessarily. the status of the room will be availble before 09:45 and after 11:15.

It will be occupied during 09:45 - 11:15 only.

You need to maintain separate tables for rooms and rooms bookings.

What exactly you are trying to do ?

Have you tried as i suggested in my previous post ?

then go and read books.

Start crying louder, that may help.

That is what school kids do when they are not spoon feed.

i don't you have started writing a single line of code yet.

Hi Cliff,

Welcome to Daniweb.

You need to read books for all those details.

sorry duplicate

Please follow this procedure.

1. Collect all the code that you can find over net.
2. Put in a mixi
3. Run the mixer for 4 and 1/2 minutes (preciously)
4. Add chocolate cream with a shot of citrus juice.
5. Serve your friends chilled,

all your friends will be impressed with your code mixing skills.

All the rooms will be part of a single table.

The flag needs to be set to available when ever it is available, occupied otherwise.

Consider this and check if this suits your requirement.

Tables structure

Person
(id,
name,
field3,
field4,
..........
static_energy,
se_status)

1. Initially insert al other details into the Person table except statis_energy column and set the se_status to 0.
2. when the external process runs creat the output into a text file with name same as ID of the person and update the status in the table to 1.
continue this process for all other person details.
3. Run a procedure to read the text file and update the static_energy column of the corresponding record (based on ID).

Is that being stored anywhere in the DB ?

How the application knows what is the status of the execution of external process ?

Are you setting any flag ?

Generally how you determine if the external process executed properly or not ?

Are you going to insert every thing from the text file into a table or update a single field of a table based on data in text file ?

which part you are struck up with ?

1. read the content from the text file.
2. write to database.

it should be that simple.

First of all tell me from where you got VB 6.5 ? Is it a home grown version ? ;)

1. Use ADO (refer to ADODB library).
2. Open recordset using desired SQL.
3. Populate the controls from recordset.

What is the differnece between Returndate and Receivedate ?

No need to store TotalDays in the DB table, it can be calculated at run time for any requirement like reporting.

Please teach me step-by-step

You need to read books for all that.

What exactly you are trying to do ?

welcome aboard.

welcome aboard.

use 2 recordset object
open one with the count query and check the data in DB.

If it returns 0(that means the userid does not exists in the DB) then open the other recordset to insert new records.

If it returns 1(that means the userid already exists in the DB) prompt the user for new userid, password and then then open the other recordset to insert new records.

Try this sample code.

Dim cn As New ADODB.connection
 
cn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\data\DataBaseName.mdb"

cn.BeginTrans
cn.Execute "your insert statement goes here."
cn.CommitTrans

What is the code that you are working on ?

To display data from database in the VB forms you need to open recordset and populate the controls.

Try this sample code.

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str As String

cn.open "your connectionstring here"
 
str = "SELECT Field1 FROM Table1"
rs.CursorLocation = adUseClient
rs.Open str, conn, adOpenStatic, adLockOptimistic
 
Text1.Text = rs("Field1")
 
rs.Close

You need to check for BOF and EOF also.

There is no generic answer to this.

A lot will depend on how you have installed and configured the DB.

During installation it is compulsory to set password for SYS and SYSTEM account. Again you can unlock and set password for other preexisting accounts (SCOTT is one of them) which is not compulsory during installation and can be done later by logging in from either of SYS or SYSTEM accounts.

So to log in into SYS or SYSTEM accounts, you need to login with the password that you have set (which you only know) during installation process.

God is the best imagination of man.

Test using some sample data you will come to know.