On 4/30/06 2:06 PM, "Joakim Schramm" <joakim AT astrocalc .DOT com> wrote:
> Hi,
>
> Why does the (VB6) code below not work? NextRecord does't do anything just
> stay on same RecId 1, so field references etc. never gets updated etc. does
> COM object don't work with With ... End With?
> Dim IdRec As Long
> Dim B As Boolean
> Dim sKey As String
> Dim fldPtr As VField
> Dim fldFK As VField
> Dim fldPK As VField
> Dim mTblCountry As VTable
> Dim mTblAlias As VTable
>
> 'prepare binary links
> 'Set mLinkCA = mDatabase.Link(lnkCountryAlias)
> Set mTblCountry = mDatabase.Table(tblCountry & sLang)
> Set mTblAlias = mDatabase.Table(tblCountryAlias)
>
> With mTblAlias
> Set fldPtr = .Field("PtrAlias")
> Set fldFK = .Field("CID")
> Set fldPK = mTblCountry.Field("CID")
> Call .FirstRecord
>
> Do While Not .EOF
> sKey = Trim$(fldFK.Value)
> IdRec = fldPK.FindSingle(sKey)
>
> If IdRec <> 0 Then
> fldPtr.Value = IdRec
> .UpdateRecord
> Else
> MsgBox "No " & sKey
> End If
>
> B = .NextRecord
> Loop
Okay I see mistake.
To do loop you use
Do While Not .EOF
Loop
EOF() property is from group of methods for ODBC style navigation.
You can use it only with NextRecord_ODBC methods.
The normal loop should looks as:
tbl.FirstRecord()
do
while( tbl.NextRecord() )
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2006 Ruslan Zasukhin |
