Hi Martin, That's strange. I just tried the following test: put revDataFromQuery(,,gDBID,"SELECT * FROM t1) into tVar put return & revDataFromQuery(,,gDBID,"SELECT * FROM t1) after tVar
tVar looked just like it should after the above, no blank lines. Are you using the default rowdelim character for revDataFromQuery? What platform are you on? My test was done on a Mac. Pete On Mon, Apr 2, 2012 at 10:57 AM, Martin Koob <mk...@rogers.com> wrote: > Hi Peter > > Thanks, I just tried your suggestion. > > That still inserts blank lines into the variable that I have to filter out > later. > > It seems the revDataFromQuery does not insert an end of line character > after > the last record and > it seems that the end of line character that is used to separate lines in > the variable is not the same as the return or LF constants in LiveCode. > > Martin > > -- > View this message in context: > http://runtime-revolution.278305.n4.nabble.com/on-rev-Line-endings-for-a-db-query-tp4526068p4526757.html > Sent from the Revolution - User mailing list archive at Nabble.com. > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > > -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
