Hi All,
I'm connecting Mapinfo to a SQL Server database and attempting to retrieve
an individual row from a table.
As SQL Server doesn't have (as far as I know) the concept of a "RowID" is
there another way to select a particular row. This table has no unique IDs
to go on, and adding a 'rowID' column isn't really an option.
I would like to do something that has the same effect as "Select * From
mytable where RowID = 666"
The Server Fetch command only works for fetch first or fetch next.
i.e.:
....
iHstmt = Server_Execute(SQLConnectID,sSQLString )
If iHstmt > 0 Then
Server iHstmt Bind Column 1 to myColumn, iSysStat
Server iHstmt Fetch First ' This works
Server iHstmt Fetch Next ' This works
Server iHstmt Fetch Last ' This doesn't work
Server iHstmt Fetch Rec n ' This doesn't work
Server iHstmt Close
End If
....
Has anyone got any ideas about a way round this problem?
Many thanks,
Dominic
Dominic Lowe
Systems Developer
ORC Data Services
www.orcpartnership.com
