Posts by debasisdas

then no program can read that and load into a database for you.

You mean to say a physical book (a printed hard copy) ?

Welcome to Daniweb.

you need to round off the value to the desired decimal places.

if the time is stored as character, you will not be able to perform any calculation on the same.

Do you want any summary information as well ?

why need to go to the last record.

simply use max(id) + 1, to generate the new id.

You need to store the database file in a centralized server to which all the connecting systems has read write access.

you can do that by running a script to update the records.

You can maintain two fields
1. Id-------number
2. company_id-----string

suppose i have 1 record in the database
so
Id = 1
company_id = NEW1

next time you want to generate a new company id

read the max of id
i.e.--1
increment the same by 1
so
new Id = 2
new company_id = NEW2

don't forget to make the ID field unique and the Company_id field primary key of the table.

i think that is clear enough.

are you trying to fetch the last record ?

In what format dates are being stored ?

You must and should go with the approach of using relational database.

First of all you need to store opening and closing time in date time format.

store the value that is being generated in a database and read back the same and add one to generate the new value.

You need to use database for this.

new value = max of current value + 1

Noone is going to ask you about all the controls and their corresponding properties, methods and events.

No need to remember all.

Use the one required for you.

Welcome aboard.

Hi Jonan,

Welcome to Daniweb.

You do that for windows phones.

Are you using database ?

Use printer for what ?

What you want to print ?

Please pass more information.

Kindly post the tables structures also post the query that you are working on.

You need to go through this for details.

TRY THIS

cnn.BeginTrans
cnn.Execute "your sql udpate query goes here"
cnn.CommitTrans

Your data is in which format ?

Sorry, ours is not a free code supply service. We do not do that.

how to insert a pdf file in database

Read the file into a binary stream and store the same into a database table.

you need to fix the SQL query that you are using .

Check for proper syntax.

oracle is an ORDBMS ---in short is a database.
and dba is a human being----is one who manages/administers the database.

please explain what exactly you are doing.

I will explain the difference between the two.

Welcome to Daniweb

Are you facing any problem with the control ?

You simply need to take the value from the control, format is at per you database date format and store in DB.

why not use a combobox to populate data from from1 in form 2 for ID_no field.

You need to use FileSystemObject.

Lets see what you have tried.

please pass more information what exactly you are trying to do.

cross check if the column name is CATALOGNO or CATALOG_NO

Welcome to Daniweb.

You need to read this.

The concept is same for all databases.

what is that .mdb file you have mentioned ?

welcome aboard.

What exactly you mean by disable a cell of datagrid ? Are you trying to make it read only ?

First look shows some problem with single quotes.

Print the variable sqlupdate before executing the same.

Try to execute the output of the print , you will know the part that is creating the problem.

If you are familiar with oracle refer to EMP table of SCOTT schema for start up.

You need to define your own sub-routine for the purpose.

What is the query that you are working on ?

declaring variables and assigning values to those.