I have been playing around with the Data Linker Xtra and don't see a way to modify the data or add records. Is this a data viewing xtra only?
Matt,
No, it supports all valid sql commands using the getDataBySQL() method.
Insert example:
gDataObject.getDataBySQL("INSERT INTO tblUser (userID) VALUES (101)")Update example:
gDataObject.getDataBySQL("UPDATE tblUser SET created = Now() WHERE userID = 101")
After spending only a short amount of time with it I found it easy to use and completely dependable. The only difficulty I had was due to my own ignorance of SQL, but fortunately there's an SQL guru down the hall who helped me get the syntax right.
Tom -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Tom Jacobs - InterVision --------------------------------------------------------------------------- (541) 343-7993 http://www.intervisionmedia.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]
