Posts by debasisdas

How you define last transaction amount ?

why you need to use GROUP BY to select the last transaction amount ?

Please find more details here and here.

You can't use GROUP BY clause without using any grouping function in Oracle.

Also consider not to use date as a field name as a best practise. That is a predefined keyword in any database.

What happens when you execute the code ?

Are you getting any error ?

You seriously needs to read books for all that.

what software you want to make ?

Try this.

select EmployeeID, sum(TransactionAmount) as TotalAmount from employee where EmployeeID IN ('E123','E234') group by EmployeeID;

How RFID will work with a book ?

try this

Dim dtmTest As Date
dtmTest = DateValue(Now)

next you need to compare the date with desired date using DateDiff.

Really difficult to guess anything without detailed information.

Another approach (using database).

If using oracle as database, compile this procedure in database.

Call the same from VB 6.0 using ADO like this.

The second link is a sample only, to show how to call a oracle stored procedure from VB 6.0..

Try using SHELL.

you need to check the system date and compare with desired date on start up

Why RFID is required for Library management system ?

The simplest thing to do is to check system date on start up.

suppose you want for 30 days from today ---say 25_sep-2011.

in the start up check if the date is less than the above date.

if it is more display an error message.

for a better and full proof solution you need to write into system registry.

May be you are dreaming, you need to wake up and check your application code.

You need to read this.

No

Write your country name correctly.

I did not ask what you want ,but what you have tried so far.

what exactly you need to implement ?

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.

you need to read this.

then why are you using JOIN.

Go for a Cartesian product.

you want without join, right ?

You need to format the DateTimePicker1.Text before passing the same into database for inserting.

show some effort, to get any help.

what you have tried so far ?

you have to create a procedure / function for that.

I am only getting results for converting a MS Accss 'database' to a SQL 'database'. ...... I just want to convert one MS Access 'table' to SQL Server (2008) 'table'.

What is the difference ?

so, what is the problem ?

what is the query that you are working on ?

Welcome to Daniweb.

Welcome aboard.

You need to use common dialog control.

You need to use ADO library in VB 6.

Read more here and here.

for that you need to frame the query dynamically at run time.

try this.

PREPARE sql_stmt FROM "your query";
EXECUTE sql_stmt;

post your table structure and the query that you are working on.

more information please .

Is it an attendance system ?

try the fiollowing

SELECT * INTO OUTFILE 'result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;

also read this.

Are you asking what a query is?

He is asking for spoon feeding.

do you have index on id column ?