Select Statement with Repeating fields

[Todd Dignan]

Is there away to get a repeating fields value with a sql select statement.  If so, what would proper structure of the select statement.  I have tried the following.

 

 

Let(

 

 

~sql = "SELECT "Tab Names" FROM PREFERENCES";

 

ExecuteSQL ( ~sql ; "" ; "" )

)

 

and 

 

 

Let(

 

~sql = "SELECT "Tab Names[17]" FROM T14_PREFERENCES";

 

ExecuteSQL ( ~sql ; "" ; "" )

)

 

Thanks,

 

Todd Dignan.

[bruceR]

"SELECT "Tab Names"[17] FROM T14_PREFERENCES"

[Todd Dignan]

AWESOME!  That work!