Digital Workshop

hi,

ok i'm have a problem pulling data from a memo datatype in a ms access database.

it pulls the data in ok if i change the memo datatype to text datatype, but the debugging displays undefined if it's a memo type.

variable - databse defined in a variable
<DB_FileDNS> FILEDSN=KYUSA_StdRec_Db.dsn


opus script code:
var KYI_db = new Database(DB_FileDNS);

var featureStudyDetails = KYI_db.ExecuteSQL("SELECT FeatureDetails FROM Features WHERE Name = ('" + StudyFeature + "');");
var numRecords = featureStudyDetails.GetNumberOfRecords()

TextFeatureInfo.ReplaceSelection(featureStudyDetails.FeatureDetails)
TextFeatureInfo.SetSelection(0,-1)


is there any reason why this would work for memo datatype or am i doing something wrong. any help would be great, really need text to be longer than 255 chars, but if i'll split it up if needs be.

luke

Hi Luke

see this post

viewtopic.php?t=518

HTH
Chris

hi,

yeah i did a forum search and tried that solution but wasn't getting results. after trying a few different sql statements over the weekend, i got the following to work:

var featureStudyDetails = KYI_db.ExecuteSQL("SELECT * FROM Features WHERE Name = ('" + StudyFeature + "') AND TypeID = ('" + 2 + "');");

this pulls the memo datatype out fine.