Posts by debasisdas

what exactly you are trying to do ?

you simply need to write a loop.
and no need to create a procedure at all for that and you need to remember that printing somthing like that is not the main purpose of defining procedures in database.

Applications connects to the database through the drivers.
ODBC, it is a differnt layer .ODBC is neither part of the frontend nor the backend.

when you are posting such a questiln always post what you have tried so far to solve that . That will give us an idea on your exact requirment.

is your join proper ?

what you want to do with the tables ?

As suggested ,that can be done at database level. No need to any special aglorithm for that.

Are you able to connect to theweb database from your system ?

Please find connection details here.

Hey Debasish.

Here is your tech guru ,but what can i do for you ?

Constant dripping hollows out a stone.

What did google say ?

Have you tried for that option ?

strategy --> win

life is boring.

adjective is an english word that starts with a.

trigger can be defined only on one base table.

One of the best uses of your time is to increase your competence in your key result areas.

sorry , i am not intrested to open the attached ZIP .

you need to connect to third party software to connect to SMS gateway.

If you have a talent, use it in every which way possible. Don’t hoard it. Don’t dole it out like a miser. Spend it lavishly like a millionaire intent on going broke.

Visualize the thing you want. See it, feel it, believe in it. Make your mental blueprint and begin.

how to read barcode scan data directly from visual basic 6 form

Please do not hijack others threads .

Start a new thread to post your own question if you have any.

please find a related discussion here.

You need to use third party component for that.

You need to create your own dll.

Why you need to do that .

Try to use third party software for the purpose.

kindly post what have you tried.

Warriors take chances. Like everyone else, they fear failing, but they refuse to let fear control them.

There is no such function in Oracle.

Get around the right people.Associate with positive,goal-oriented people who encourage and inspire you.

the file contains data in which format ?

is it binary ?

you need to use COUNT in the database by passing the username and password from the user input . if it returns 1(one) then allow to login else re-prompt for correct user name and password

to store data in database you need to use Insert query from frontend not select .

if i give days between 4 months, but i want days only till end of the first month only

why you need to pass dates for that.

Last_day will do that for you with only one parameter.

In 10g once the table is dropped its related objects are renamed and stored in recyclebin. But grants will not work anymore.

Check the data foramt by using this

select * from nls_database_parameters

Sports serve society by providing vivid examples of excellence.

you need to pass the password dynamically . If it is wrong return some error ,tap it at front end and reprompt for correct password.

what exactly is your requirment ?

you need to desing the frontend as well as the database and connect the both for the purpose. you need to store alll the details that you need for retrieving it back.

You cannot dream yourself into a character: you must hammer and forge yourself into one.

why you need to compare the images .

try to work on other fields line id or any other primay / unique key field.

you need to set the properties.

that is not possible

to open any exe use SHELL from vb6.0

The way to gain a good reputation, is to endeavor to be what you desire to appear. - Socrates

you need to use

set DataGrid1.DataSource = Adodc1.RecordSource

it will be better to handle the database part manually if it is sql server or oracle.

text fields needs to be enclosed by quotes.

you need to connect the device and capture the input.

after that processing is same as input from a normal keyboard.

if there is any primay key in your table then
1.when you movenext retrive the value of the PK field
2.pass the same in a query to database
3.fetch the blob field.
4.convert the code to an image file.