Using VCOM 3.5.2 API_Way to filter recordset?

[Barry G. Sumpter]

Hi all,

Testing VCOM from 3.5.2

After installing - my apps in 3.5.3 won't compile


Using VCom API_Way in vb6 is there a way to filter the recordset? 

"Select * from myTable where myField = 'myCriteria'" 

Private Sub Command3_Click()

  Dim f As String
    
  On Error GoTo ErrDb
  f = App.Path + "\Databases\myDB.vdb"
  
  Set mDatabase = New VDatabase
  mDatabase.InitLocal kStorageDefault

  mDatabase.Open f
  
  Dim t As VTable
  Set t = mDatabase.Table("myTable")
  
  
  Dim setAll As VSet
  Dim SortedSet As VArraySet
  
  Set setAll = t.SelectAllRecords()  
  '??? Set setAll = t.SelectAllRecords("Select * from myTable where myField
= 'myCriteria'")  '???


  Set SortedSet = t.Sort(setAll, t.Field("myField"), True)
  
  ' Now show records in the sort order using set
  TableBrowser.AssignArraySet t, SortedSet
 
  
  
  
  ' Now we want show records:
  TableBrowser.Show

Exit Sub
 
  
ErrDb:

MsgBox mDatabase.ErrString

  ThreadError


End Sub
...

-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Barry G. Sumpter
Sent: Sunday, November 29, 2009 4:46 PM
To: 'Valentina Developers'
Subject: RE: VCOM

Typical 2 hours looking for doco.
Post a query and find it 2 mins later.

C:\Documents and Settings\<Windows User>\My Documents\Paradigma
Software\VCOM_4

Apologies for any distraction.




-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Barry G. Sumpter
Sent: Tuesday, January 07, 2003 9:40 AM
To: 'Valentina Developers'
Subject: VCOM

Hi all,

I've got a need to use VB6 and would like to use VCom.

I've installed VCom but don't know where to go from there.

Anyone have a sample vb6 project using vCom.

Or a hyperlink or a quick How to get started reply would do.

Thanks,
     Barry G. Sumpter


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina