Using MySQL over ADO via ODBC and Fivewin functions I can´t retrieve more tan 1969 records (adding LIMIT 1969).
If I issue oRs := FW_OpenRecordSet( oConexion, "select * from mytable"), I get in the oRs object:
0 IAccessor VERDADERO
1 IChapteredRowset VERDADERO
2 IColumnsInfo VERDADERO
3 IColumnsRowset VERDADERO
4 IConnectionPointContainer VERDADERO
5 IConvertType VERDADERO
6 ILockBytes FALSO
7 IRowset VERDADERO
8 IDBAsynchStatus FALSO
9 IParentRowset VERDADERO
10 IRowsetChange VERDADERO
11 IRowsetExactScroll VERDADERO
12 IRowsetFind VERDADERO
13 IRowsetIdentity VERDADERO
14 IRowsetInfo VERDADERO
15 IRowsetLocate VERDADERO
16 IRowsetRefresh VERDADERO
17 IRowsetResynch FALSO
18 IRowsetScroll VERDADERO
19 IRowsetUpdate VERDADERO
20 IRowsetView VERDADERO
21 IRowsetIndex FALSO
22 ISequentialStream VERDADERO
23 IStorage FALSO
24 IStream FALSO
25 ISupportErrorInfo VERDADERO
26 Preserve on Abort VERDADERO
27 Access Order 2
28 Append-Only Rowset FALSO
29 Blocking Storage Objects FALSO
30 Use Bookmarks VERDADERO
31 Skip Deleted Bookmarks VERDADERO
32 Bookmark Type 1
33 Cache Deferred Columns FALSO
34 Fetch Backwards VERDADERO
35 Hold Rows VERDADERO
36 Scroll Backwards VERDADERO
37 Change Inserted Rows VERDADERO
38 Column Privileges FALSO
39 Command Time Out 0
40 Preserve on Commit VERDADERO
41 Defer Column FALSO
42 Delay Storage Object Updates VERDADERO
43 Private1
44 Filter Operations 27
45 Find Operations 27
46 Hidden Columns 0
47 Immobile Rows VERDADERO
48 Literal Bookmarks VERDADERO
49 Literal Row Identity VERDADERO
50 Maximum Open Rows 0
51 Maximum Pending Rows 0
52 Maximum Rows 0
53 Column Writable FALSO
54 Memory Usage 0
55 Notification Granularity 1
56 Notification Phases 31
57 Column Set Notification 3
58 Row Delete Notification 3
59 Row First Change Notification 3
60 Row Insert Notification 3
61 Row Resynchronization Notification 3
62 Rowset Release Notification 3
63 Rowset Fetch Position Change Notification 3
64 Row Undo Change Notification 3
65 Row Undo Delete Notification 3
66 Row Undo Insert Notification 3
67 Row Update Notification 3
68 Bookmarks Ordered VERDADERO
69 Others' Inserts Visible FALSO
70 Others' Changes Visible FALSO
71 Own Inserts Visible VERDADERO
72 Own Changes Visible VERDADERO
73 Quick Restart VERDADERO
74 Reentrant Events VERDADERO
75 Remove Deleted Rows VERDADERO
76 Report Multiple Changes FALSO
77 Return Pending Inserts VERDADERO
78 Row Privileges FALSO
79 Asynchronous Rowset Processing 16
80 Row Threading Model 1
81 Server Cursor FALSO
82 Strong Row Identity VERDADERO
83 Objects Transacted FALSO
84 Unique Rows VERDADERO
85 Updatability 7
86 Batch Size 15
87 Update Criteria 2
88 Background Fetch Size 15
89 Initial Fetch Size 50
90 Background thread Priority 3
91 Cache Child Rows VERDADERO
92 Maintain Change Status FALSO
93 Auto Recalc 1
94 Unique Table
95 Unique Schema
96 Unique Catalog
97 Resync Command
98 Cursor Engine Version 60
99 Reshape Name
100 Update Resync 1
101 Release Shape On Disconnect FALSO
102 Bookmarkable VERDADERO
Has anyone experienced this?.
Using phpadmin the db and table work fine.
Thank you very much.
