Crystal Reports Logical Err

[Nasir]

Good Morning to All My Fellow Members
I am attaching a code the dbifo.ini file is for data bse connectivity please when u run it chage the server name plz problem is that reports shows only one record in disply i am try to display all the records but only one is comming all the rest r overwited ??? kindly help me asa possible .I will be grate full to the members

"Nasir "

 

[Paszt]

using This SQL statement:

QryString = " SELECT EmployeeID, FirstName + ' ' + LastName AS Name," _
          & " Address  " _
          & " FROM Employees  " _
          & " Where  EmployeeID=1 "

only the rows that have EmployeeID equal to '1' will be returned. I assume employeeID is either a primary key or no duplicates are allowed in that field; therefore you will only get one record. If you want all records, remove the WHERE clause:

QryString = " SELECT EmployeeID, FirstName + ' ' + LastName AS Name," _
          & " Address  " _
          & " FROM Employees"