Listview.dll with and without SQLite-Interface

[manu]

Thanks Filippo.

Is that news is this library?

manu

[Cableguy]

Hi Fillipo...

I'm trying to use your dll with formExDesktop, and I !!!NEED!!! the ControlRef, wich does not exist in the current version of your dll...
Since you have not provided a CS file, I cannot add this prop it myself..
Could You please do this...???

[agraham]

Originally Posted by Cableguy

I !!!NEED!!! the ControlRef, wich does not exist in the current version of your dll...

You could try getting it with the Door library

Obj.New1(False)
  ... 
Obj1.FromLibrary("ListViewObjectName", "_LV", B4pObject(2))

[Erel]

Don't forget the module name:

Obj1.FromLibrary("Main.ListViewObjectName", "_LV", B4pObject(2))

[Filippo]

Hi Cableguy,

i don't understand for what you need a CS-file, the ControlRef or why...


Ciao,
Filippo

[Cableguy]

Originally Posted by Filippo

Hi Cableguy,

i don't understand for what you need a CS-file, the ControlRef or why...


Ciao,
Filippo

I'm using your ListView with SQLLibrary (NOT ListViewSQL), And I need to reference the Listview in a command as a String...
Since there is no NAME prop or Control.Ref, The command can't "see" the desteny table...

With the cs file I could Add this prop to the dll myself and then use it...

@EREL & Agraham:
I'm using 4 dll's already, and adding another one just to get this parameter is a bit overkill...
Anyway...

Obj1.FromLibrary("Main.ListViewObjectName", "_LV", B4pObject(2))

I can use this line like this?

LIstView_CtrlRef=Obj1.FromLibrary("Main.ListViewObjectName", "_LV", B4pObject(2))

[Filippo]

could you please post a part of your code here? maybe i find another way to get your problem away

[Cableguy]

I have a module handling the database, so I just pass some values to a particular sub...
Like this one:

Public Sub Load_Tecnicos(destino)
Cmd.CommandText = "SELECT Nome FROM Tecnico"
cmd.ExecuteTable(Destino,0)
cmd.ExecuteNonQuery
End Sub

In this sub I pass as "destino" the table name...
But since I'm using your listview.dll, I cant get a valid reference to the table without the ControlRef.

With a native b4ppc table, my command would look like this...

BaseDados.Load_Tecnicos("Main.Table")

With ListView, it must be something like...

BaseDados.Load_Tecnicos(ListView.controlRef)

[Filippo]

Here is a small example

PHP Code:

Sub Globals
  Database=AppPath & "\Northwind.sl3"
  SortAscending=True
End Sub

Sub App_Start
  Form1.Show
  lv.New1("Form1",0,0,Form1.Width , Form1.Height)
  lv.FullRowSelect=True
  lv.SetRowColor(cBeige,cSilver)
  LoadSQL
End Sub

Sub LoadSQL
  lv.Clear
  ' ' lv.loadSQL(Database,"Categories", "", True)
  lv.loadSQL(Database,"Products", "", True)
End Sub

Sub lv_ColumnClick
  SortAscending=Not(SortAscending)
  lv.SortColumn(lv.SelectedColumn,SortAscending)
End Sub 


[Cableguy]

I tryied EREL's and Agraham's code, but it fails with the error message below...

@Filippo
The call to the LoadTecnicos sub is comming from a diferent module...
The database module will hold ONLY and EXCLUSEVELY SQL objects(command, Conectio and datareader).
Your aproach demand me to add the treeview object to the database, and is is a NO-NO for me...
With a native table, all goes OK