Reference my post. I think he may have a blank row in his database. Bob
On Apr 2, 2012, at 12:12 PM, Pete wrote: > 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 _______________________________________________ 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
