Liveware Publishing Support Forum

Anyone know how to issue a sql select statement for multiple tables that has a common field with the same name? I don^t want to specified each individual field and qualify each with the table name skipping the field with the same name.

It worked as you discribed. Now I am trying to add a date to the filter string using calculated field systax and I can^t get it to work.__bStat = setFilter(hRpt,(LPCSTR) "LIKE(^Feed*^,linename) and InstallDate = {3/17/73}");____Thanks.

Has anyone used the setFilter function to set a filter with wildcard? I can^t seem to get it to work.____setFilter(hRpt, (LPCSTR) "LineName is like ^xyz*^");__