Forgive me as I'm relatively new to dynamic queries and the like.....
I have created a program to display all data from a table whose name I feed the program as an input parameter. Obviously all my tables contain various numbers of fields of various data types so I create a dynamic tt like the table I pass in(this is to allow me to sort and query the data after the program runs..).
My problem is the database and the data within.... As the temp table inherits the formats from the table there are various instances where the data is not in the correct format and the row-display trigger(i think) of the browse complains every time some duff data appears.
Does anyone know of a nice solution to change the format of the cell to allow the data to be displayed correctly or at very least if I can suppress these errors to give me some time to come up with a better solution???
I'm using 10.2b in a windows environment.
Any ideas would be greatly appreciated!!
I have created a program to display all data from a table whose name I feed the program as an input parameter. Obviously all my tables contain various numbers of fields of various data types so I create a dynamic tt like the table I pass in(this is to allow me to sort and query the data after the program runs..).
My problem is the database and the data within.... As the temp table inherits the formats from the table there are various instances where the data is not in the correct format and the row-display trigger(i think) of the browse complains every time some duff data appears.
Does anyone know of a nice solution to change the format of the cell to allow the data to be displayed correctly or at very least if I can suppress these errors to give me some time to come up with a better solution???
I'm using 10.2b in a windows environment.
Any ideas would be greatly appreciated!!
