![]() |
|
|||||||
| Home | Register | FAQ | Members List | Search | Today's Posts | Mark Forums Read |
| Questions & Help Needed Post any question regarding Basic4ppc. |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|||
|
To keep control of records I am using...
lLastRec=gPage*gRows ...and then SQL statement... SELECT * FROM Titles WHERE ROWID >0 AND ROWID <= lLastRec ORDER BY num The SQL error 'No such column lLastRec' suggests a variable cannot be used to compare ROWID. Having replaced it with a number and it works seems to confirm this. This obviously presents a problem when trying to obtain sets of data to display one page at a time to avoid having scrollbars appear on the Table. It means a number must manually be provided per page. I must have something wrong here. |
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Newbie: animation | texaspoker11 | Questions & Help Needed | 3 | 11-05-2008 06:43 PM |
| Newbie Question | Stevenator65 | Questions & Help Needed | 9 | 05-30-2008 09:53 PM |
| Newbie Questions | Bruno | Questions & Help Needed | 2 | 05-05-2008 07:45 PM |
| Newbie: Help file linking? | enonod | Questions & Help Needed | 2 | 04-26-2008 07:09 PM |
| Newbie questions | stratus | Questions & Help Needed | 2 | 11-13-2007 02:21 PM |