K.Venkat Ramana
March 15th, 1999, 02:48 AM
Hello Every Body,
Environment :- VB5 Pro. with WIN98 Database:- MSACCESS 8.0
I am Facing a peculier problem.Im am Using DAO objects for dealing with
the database part.When I opened the visdata for the first time it asked
for the system datebase and i supplied the rigth path for it .i.e
c:\windows\system\ and satrted working with it.But I noticed a very odd
problem i.e When I created a table and it has 3 fields.
And all three of them text varibles with 255 size .
The Problem When I am giving a plain select in visdata like
select * from tablename;
It is Showing correctly all the results.
But when I am giving a where clause a maxmium it is showing only 2
records.And This problem is not only with this table with all the tables it is happening . i.e only 2 records are fetched at max. when a "WHERE "Clause is given.
Is there any setting involved.
Please help
With Regards
Venkat
Environment :- VB5 Pro. with WIN98 Database:- MSACCESS 8.0
I am Facing a peculier problem.Im am Using DAO objects for dealing with
the database part.When I opened the visdata for the first time it asked
for the system datebase and i supplied the rigth path for it .i.e
c:\windows\system\ and satrted working with it.But I noticed a very odd
problem i.e When I created a table and it has 3 fields.
And all three of them text varibles with 255 size .
The Problem When I am giving a plain select in visdata like
select * from tablename;
It is Showing correctly all the results.
But when I am giving a where clause a maxmium it is showing only 2
records.And This problem is not only with this table with all the tables it is happening . i.e only 2 records are fetched at max. when a "WHERE "Clause is given.
Is there any setting involved.
Please help
With Regards
Venkat