debasisdas

Hi Yamna, Welcome to Daniweb.

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

Welcome to Daniweb

You need to read [URL="http://www.oracle.com/technetwork/database/features/plsql/overview/how-to-write-injection-proof-plsql-1-129572.pdf"]this[/URL]. The concept is same for all databases.

You need to create a parametrized function with [B]$artistID[/B] as the input. Then call the function from your application code.

Welcome to Daniweb.

cross check if the column name is CATALOGNO or CATALOG_NO

welcome aboard.

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.

for what ?

First look shows some problem with single quotes. Print the variable [B]sqlupdate[/B] before executing the same. Try to execute the output of the print , you will know the part that is creating the problem.

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

try this (oracle code) [CODE]select to_char(sysdate,'ddspth fmmonth yyyysp') from dual[/CODE] If dates are being stored in oracle DB then you may use this.

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

What is the query that you are working on ?

Welcome aboard.

[URL="http://www.vbgold.com/vb-projects/shutdown-reboot-system.shtml"]This[/URL] may help. also try --- [B]Shell "shutdown -s"[/B]

You need to read [URL="http://windows.microsoft.com/en-IN/windows/help/learn-how-to-install-windows-xp-service-pack-3-sp3"]this[/URL].

declaring variables and assigning values to those.

you need to pass the parameter for [B]bill_INV_No[/B] dynamically using some control. try this [CODE] Private Sub Report_Initialize() CrystalReport1.SQLQueryString = "Select * from bill_client where bill_INV_No = & val(text_INV_No.text)" End Sub[/CODE]

[URL="http://dev.mysql.com/doc/refman/5.1/en/alter-table.html"]This[/URL] may help.

Welcome aboard.

creates password for what ?

You need to handle that part in your code. Lets see your code.

From where you got this error ? What code , which application, which database ?

What is [B]jtds000001[/B] ?

Sharpen your pencil first.

Spread the word, tell your friends.

You can't do that. How about handling that using numeric keypad. use the keys 1,3,7,9

Actually selecting the table and field names should be handles from front end application and the same need to be passed into back end and the database procedure should process the input parameters to process the job.

what is the application ?

Test using some sample data you will come to know.

You need to use some third party tools / components to generate barcode.

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.

Please read more [URL="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm"]here[/URL].

What exactly you are trying to print ? Is it a report ?

What exactly you are trying to print ?

What exactly is the error message ? Why the table name is within parenthesis ? NOTE:--Do not use [B]dataset[/B] as name of an object, it is a predefined key word..

check for date format.

Negative number in a timers interval property does not makes any sense.

which database you are using and what exactly you mean by linking ?

I know only one language SQL, and people still refer me as Senior Programmer. :cool:

Lets see the code that you are working on and fix it.

Hi Ashfaq, Welcome to Daniweb.

Your SQL syntax is wrong.

your problem seem to be an application issue than database. [QUOTE=NeedDBhelp;1617832]I dont know where to start.:sad:[/QUOTE] design the database first.

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 …

Welcome aboard.

Welcome aboard.

to resize the image control set its height =formheight-300 or any other value and the same for width also in the form resize event.