I'm trying to take a record set from a DB I designed (and is
connecting fine), but somehow I always end up with the same error
message: "No such column: <text from column>"
If I do a "select * from DxCode", the record set loads up just fine,
yet when I try to define the record set with a given value which is
correct and accurate, it doesn't work but gives me the error 1 code.
I'm currently working with RB 2006r3 (although I also tried it with
r2 with the same result)
I'm using a Powerbook G4, OS 10.4.7 with 1 GB RAM
TIA,
Elvin
--
Here is my code:
Dim rs As New RecordSet
rs=myDB.SQLSelect("select * from DxCode where DxId="+DXList.cell
(DXList.ListIndex,0))
if rs<>Nil then
rs.Edit
rs.Field("DxId").StringValue=EditField1.text
rs.Field("DxDSM").StringValue=EditField2.text
rs.Field("DxCPT").StringValue=EditField3.text
rs.Field("DxTitle").StringValue=EditField4.text
rs.Field("DxDesc").StringValue=EditField5.text
rs.Update
end if
If myDB.Error then
MsgBox myDB.errormessage
else
myDB.Commit
end if
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
