View Single Post
  #1  
Old 04-27-2016, 07:05 AM
lexd lexd is offline
Senior Member
 
Join Date: Feb 2015
Posts: 268
Default How to filter correctly

I have a table of users with a field ID Number
And a table of Items that hold a number that relates to users
I'm using a ADODataSet

I have a simple filter that works finishing with: - where ID = 1;

1/ I want to automate the DataSet rewrite the script before a refresh so: - ID = another user number
2/ in the list of items their may be 100 items, how can I make SQL script list Items 20 to 40 as an example

Last edited by lexd; 04-27-2016 at 10:04 AM.
Reply With Quote