Posts by debasisdas

modify your .net code and ensure that you get the above SQL before executing the same.

try this

INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES (505056,'CPU',15000, 1,'RAM', 1200,1,'KEYBOARD',1500,2,'','','','','','','','','','','','',' ','','',' ','','',' ','','','BACKUP',to_date('06/03/2011 11:41:43','mm/dd/yyyy hh24:mi:ss'),'IT Support')

and fix all that missing single quotes from your .net code.

If you are getting syntax error what is fine then ?

what happened to all those single quotes, why are they missing ?

That should work, ensure that you are using where clause on the proper column.

Also check if the column contains any white spaces.

@zebnoon

can you please rephrase your last question.

If you are opening the picture in any browser, check for zoom settings.

A cursor controls the navigation of records in a recordset and how the records will be updated

adOpenForwardOnly - this is the default cursor if no other is specified. This cursor allows only forward movement through a recordset

adOpenKeyset - this cursor supports forwards as well as backwards navigation. It also allows you to update a recordset and all changes will be reflected in other users recordsets. The cursor also supports bookmarking

adOpenDynamic - this cursor supports forward and backward navigation but bookmarks may not be supported (ie Access). Any changes made to data are immediately visible with no need to resynchronise the cursor with the database

adOpenStatic - this cursor uses a static copy of data from the database and therefore no changes to the data are visible and supports forward and backward navigation

getting auto-incremented, how ?

check if they are getting auto-incremented or not .

You are not inserting the Id columns (authorID, publisherID,..............) into any of the tables.

check your insert statements.

change the last line to the following.

& textDateTime & "','mm/dd/yyyy hh24:mi:ss')",'" &  ComboBox1.Text.TRIM & "')"

did you follow the steps as suggested by urtrivedi ?

may be you need to fix the part between the date and combo field.

change line # 9 to following and try.

rs.Open str, conn, adOpenStatic, adLockOptimistic

post only the SQL insert statement.

Can i have your table structure and some sample data please, that will really help understand your question better.

Can you print the SQL statement and post over here. (only the SQL not .net code)

what about passing more info .

it is Plan1 or Plna1

You can try to use Base64 encoding.

Yeah, I've read this too:
but I couldn't do anything.

what is the problem.

only reading is not enough , you need to understand the basics of the code.

Please read this and this.

you are not passing date in proper format.

yes, it can be if it a combination of more than one field and may be one filed is enough to uniquely identify the records.

in your case super key is not (12,harry) or (13,harry)

it is (emp_ID, firstname)

and since data in firstname column is exactly same , that is not going to help in uniquely identifying the records.

So only the emp_id is enough for the unique identification of record.

Given table: EMPLOYEES{employee_id, firstname, surname, sal}

Possible superkeys are:

{employee_id}
{employee_id, firstname}
...
(employee_id, firstname, surname, sal}

Only the the minimal superkey - {employee_id} - will be considered as a candidate key.

read more here.

Superkey - A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set.

please read more here, here, here .

every tool I found in the internet you have to buy it first to use it.

Let me tell you something, free lunch is a myth.

and i have a few questions for you.

1. you said you are a tester not a develop right ?
2. what language you are going to use for your tool development.
3. do you know how to write code / what code to write to create an application.
and the most important question
4. Why you want to create a free toll for everyone ?

Have you started with anything yet ?

simply try this

SELECT CURDATE() - 10

read more here and here .

You need to set the network path instead of local path in the database connection string.

1. Place the database in Machine 1.
2. Set the database path in the setup to the desired path (Machine 1).
3. Install the application in Mac 2, Mac 3,......

It will work every where.

You need to store the database file in a network path and specify that path in your connection string code.

yes you have to use SELECT INTO....

try the following , may work for you.

DELETE ServiceID FROM tblServices 
where serviceid in (select ServiceID FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG')

For the 2nd part of your question, you need to loop through all the tables in the desired schema and run the count() query using EXECUTE IMMDEIATE.

What exactly you mean by take dump of data ?

then go for this

SELECT TABLE_NAME,NUM_ROWS  FROM ALL_TABLES
WHERE OWNER = 'PM_CMP_MODEL'

Try this.

SELECT TABLE_NAME,NUM_ROWS FROM USER_TABLES

does your control have focus during scan ?

You mean to say this number 1231231231231231 is being stored in an integer field in the database ?

To implement indexes for getting performance is always an option. But to go for that one needs to have complete knowledge of the database design and the flow of data (how application hits the DB).

you need not write any code to capture the input from device.

If you want to process the input data further, write your own logic.

you need not write any code for that.

the device reads the code and the value is populated on any control that has focus, that may be any editable control in any application or simply a notepad.

If you still insist, try this sample.

Let me tell you databases are not created at run time, for what ever reason.

What about all the free cocktail and roller coaster ride, I have heard about. ;)

do you have any code that you are working on ?

use this.

UPDATE runquery.table1 SET runquery.table1.Column1 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM  runquery.table2 WHERE runquery.table2.itemid = 3 AND runquery.table1.Userids = runquery.table2.userid),
runquery.table1.Column2 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM  runquery.table2 WHERE runquery.table2.itemid = 5 AND runquery.table1.Userids = runquery.table2.userid)

try this

select code, description, count(code) as total
group by code

i was asking about database not dataset.

repeat the same for other column also.

UPDATE runquery.table1 
SET runquery.table1.Column1 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM  runquery.table1 , runquery.table2 WHERE runquery.table2.itemid = 3 AND runquery.table1.Userids = runquery.table2.userid

is this working ?