Select Col.name from table - SOLVED

[sphere]

You are most welcome

When i was reading the thread i remembered someone pointing me to it, cause i had some issues.
So i thoug'd i'd look it up, but could not find the original posting anymore somewhere on superuser or stackexhange. But indeed it has nice info about it.

[bogs]

Nice indeed, now tucked safely away in my bookmarks

[bogs]

Just as a finish up for anyone that follows along on this thread later, I did finally figure out the syntax to correct the display of the data. I'm not saying it is the best syntax mind you, just what worked here.

Code: Select all

put "SELECT `Title`,`Year`,`Format`,REPLACE(`Cast`,X'09',CAST( ' ' as text ))" \
         & ",REPLACE(`Summary`,X'09',CAST( ' ' as text )),`catNumber`" \
         & "FROM Movies" into tmpSql   

This resulted in nicely formatted columns in the table and grid objects which did not overflow the columns, so I didn't have to resort to going back to RB after all.

I may wind up going back to RB to suck out the pictures though, working on that step next. But this part was resolved completely in Lc.

Lesson learned from all this, make sure you strip pre/post spaces and either convert/replace internal/external tabs inside the data before inserting it into the db. Not impossible to overcome, but puzzling in its results sometimes