Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > DB-Aware

Lost Password?

Thread Tools Display Modes
Prev Previous Post   Next Post Next
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

database, delphi

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 09:06 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.