Thanks, Norman, suggestions!
Elvin
On Jul 7, 2006, at 10:30 PM, Norman Palardy wrote:
On Jul 07, 2006, at 4:00 PM, Elvin S. Rodríguez wrote:
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
No need to do NEW
Just
dim rs as recordset
rs=myDB.SQLSelect("select * from DxCode where DxId="+DXList.cell
(DXList.ListIndex,0))
if rs<>Nil then
Check if EOF is true
With a newly created reocrdset if it is true you have a valid
recordset with 0 records
if not(rs is Nil) and (rs.eof=false) 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>
Norman Palardy
OS X 10.4.6 / MacBook Pro 2.16Ghz MHz / 2Gb RAM
_______________________________________________
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>
_______________________________________________
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>
