OK. I figured out my problem now. I was mixing standard RB objects with MBS objects and when you are using SQLConnectionMBS that is not the best way to go.
So my next question is there an equivalent obect to RecordSet in the SQLConnection/CommandMBS world? Or is it that SQLCommandMBS encapsulates the RecordSet? If the latter, then what is the best way to destroy the RecordSet in SQLCommandMBS? cmd=Nil? Thanks, Craig Boyd ________________________________________ From: [email protected] [[email protected]] on behalf of Boyd, Craig [[email protected]] Sent: Thursday, January 10, 2013 21:02 To: [email protected] Subject: [MBS] SQL Plugin Hello All, I am using the SQL Plugin demo and using it to connect to Oracle. That piece works fine, but when I try put in code for a SELECT I get the following error: "Type mismatch error. Expected RecordSet, but got String" My offending line of code is: rs = con.SQLSelect("select owner, table_name from dba_tables order by table_name") Not sure what I am doing wrong, thoughts? Thanks, Craig Boyd The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________ Mbsplugins_monkeybreadsoftware.info mailing list [email protected] https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________ Mbsplugins_monkeybreadsoftware.info mailing list [email protected] https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
