No, I tried what you did and got the same error. Looking inside ListviewSQLDesktop.dll with Reflector it references the missing (old) "System.Data.SQLite, Version=1.0.40.0 ... " library. I don't know why it needs this reference as I would have thought that access to SQLite would be done via SQLDesktop.dll. ListviewSQLDesktop will need to be recompiled with this reference updated or removed in order to work with the SQLite files supplied with version 6.80.Is there some old path or registry setting I should remove?
Actually this step is not required. The correct System.Data.SQLite.dll is deployed in Basic4ppc folder during installation. When you run a program from the IDE, all additional libraries (not directly referenced by Basic4ppc) should be placed together with the main executable which is Basic4ppc Desktop.exe in that case.I note that System.Data.SQLite.DLL for the desktop will need to be manually copied to the project folder for the program to run.
Surely an optimised compiled app won't run if you don't?Actually this step is not required.
(from SQLDevice.cs)
//version: 1.51
//ref: SQLNative\Device\System.Data.SQLite.Device.dll
//copy: SQLNative\Device\SQLite.Interop.060.dllIf you mean what I think you mean (how have you reduced ...) then the answer is he hasn't, that is how a Listview in Details view draws itself. The line spacing seems to be governed by the Font in use and I can't see that Filippo has exposed a way of changing that.I am curious; how do you reduce the padding between the rows of the listview so that they are so compact?
This is because my Listview is ready set up with large and small icon ImageLists ready to be populated and Filippos' Listview is not. Because of this lines in Details view in my Listview are spaced to accept 16 x16 pixel images whereas Filippos is not. As you have noticed if you put checkboxes (which servo their size to the expected image size) in Filippos Listview the line spacing will now match mine. If you invoke Listview.SetSmallImageSize(1,1) in my Listview it will closely match Filippos but checkboxes will be too small to see. If you play with the height and width values of SetSmallImageSize you can see the effect on line height and inset of the left hand column items.Side by side view of the difference in row height between Filippo's listview and the listview accessible via Agraham's libraries.
Yes, that's what he designed it for while mine has no added functionality and just exposes the Listview control. His accesses SQLite directly to populate itself, hence the need to recompile the library for 6.80 but also hence its' performance advantage.Filippo's Listview is really great for SQL.
obj.FromLibrary ("Main.lv","_LV", B4PObject(2))
evlv1.New1(obj.value,"MouseMove")
...
Sub evlv1_NewEvent
o.Value = evlv1.Data
x = o.GetProperty("X")
y = o.GetProperty("Y")
o.Value = obj.RunMethod3("HitTest",x,"System.Int32",y,"System.Int32")
col = o.GetProperty("Column")
...We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?