Posts by debasisdas

Is that your own code ?

You have to frame the SQL at run time and execute the same using as dynamic SQL in a stored procedure.

Read more here and here.

do you how to fetch first 5 records from a table using SQL in MySQL ?

you need to call label_click event in the Key press event.

try to debug the code.

use like in place of = in the where clause

move the following lines to form_load event
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient

close the recordset after populating the drid

Set DataGrid1.DataSource = rs

The 3rd and 4th column of your output clearly shows, this output is not of the query that you have posted here. Please recheck.

1. You need to frame the query dynamically at run time by taking parameter from the input.
2. Open the record set using the sql.
3. Populate the grid from the recordset.
4. If record count is 0 display the alternate message.

It will be easy to do the same at database level.

In which line you are executing the SQL statement ?

1. Select the distinct value from the column Car Manufacturers and display in the first List Box.
2. Select the value from the first List Box.
3. Pass this value to another SQL dynamically at run time.
4. Fetch the values from the SQL and populate the second List Box.

I think access is not backward compatible and so can't open .ACCDB file which is supported in the version 2007 onwards.

As already suggested no need to install Access if it is used as database only. Having the .MDB file only is enough.

Lets see the code that is throwing the error.

You need to read this and this.

you need to handle the key ascii in Key press event

please post your code here for reference.

you need to select start and end dates from the control
format it as per database format before using the values.
Use BETWEEN operator in database side for date range.

Please specify how are you connecting ? I am not sure what exactly you mean by The database is being detected but not the tables inside the database.

As suggested by smantscheff, you need not bother about STATUS column at all if you do not want to filter by that column and display all the records. So it really does not matter how many distinct values you have in that field.

Welcome aboard.

what is the problem with step2 ?

suppose
on start of the timer
x=1500
y=2000

after 2 seconds
x1=2500
y1=3000

if x <> x1 and y <>y1 then
' your next logic here

No need of using array ,using variables should work for you.

If you do not want time factors, why use timestamp for the field.

If only data and time portion is required why not use DATE data type and sysdate only.

1. On a timer keep tacking of the X,Y coordinates of the mouse.
2. Check the same after desired time gap and compare with the old location, if it has changed call the click event.
3. On each mouse move reset the timer.

What is the target field type ?
Why you need to convert current_timestamp using to_timestamp ?
Why not use current_timestamp of systimestamp directly.

What is Dwell Clicking ?

Take these following 2 items from you data as example

123--Phone power on but vibrate is too weak P300-3110-VX8575
124--place a test call. P300-1710-DROID

Line 1-----length----60---length of Item Number-----16-----starting position of Item Number--45
Line 2-----length----39---length of Item Number-----15-----starting position of Item Number--25

So, the data is inconsistent.

It will be difficult to design a generic logic for this kind of inconsistent data.

but i don't see any consistency in the data, neither length nor format.

uninstall
reboot system
install

and then check

those are not characters but strings on data.

On what basic / logic you want the output ?

Is the format always same for all the records ?

Oracle is an ORDBMS and sql is a programming language to interact with database.

Please read books for details.

You need to read books for all those details.

Yes.

Lets see what you have so far.

You need to join both the tables based on ItemNumber or Ponumber or both based on your database structure.

you need to format the dates properly before passing the same into the database.

May be you only understand what are you trying to do.

how are you trying to connect.

use cmd.ExecuteNonQuery() outside the IF ..END IF block.

I can't find any code where you are executing the OleDbCommand object.

No

Why not loop through the items in the array by index..

you need to convert the string to date format as defined in your database table column.

I didn't .where?

In post no 5 of this thread.

just use

SELECT table1.col1,table1.col2,table2.col1
FROM table1,table2

without any join.

but output may not be as expected as the result is a cross product in absence of any join..

lets see the query that you are working on.

Your question has nothing to do with VB.net application. The business logic needs to be implemented entirely at database level.

Try to export the access table into a CSV file and import/load the same in SQL Server.

then why are you using JOIN.

Go for a Cartesian product.

you want without join, right ?