TextView crashes on orientation changes

Question

I am facing app crash on changing orientation

My activity has a action bar which contains app logo and title. Activity has multiple fragments with different layouts What I need to do is I have to hide logo on some of the fragments and I can achieve this by using this line of code

var gameTv= requireActivity().findViewById<TextView>(R.id.gameTv)
gameTv.visibility=View.GONE

and this works perfect but the issue is when I change the orientation of the app my app crashes.

Answer 1

I'm not sure exactly how you're loading your data into snowflake, but I think your best option here is to have your load process convert empty strings to null. That's the only option I can really think of where you don't have to specify per column.

For example, in COPY INTO statements (and by extension PIPEs), you can use the EMPTY_FIELD_AS_NULL option for your file formats. See Format options here.

Answer 2

You have two related options in the COPY INTO command:

1. NULL_IF = ('', 'null', 'NULL') - by default '\\N'. When unloading data from Snowflake (in case you later upload it to Oracle), or loading data into Snowflake. What my sample here does is replacing any empty string, and 'null' or 'NULL' values (from a file when loading, or from a table when unloading) by an actual SQL NULL.

2. EMPTY_FIELD_AS_NULL = TRUE - by default TRUE. When loading data into Snowflake, a field like ",," (assuming comma as field separator) will be inserted as SQL NULL in the loading table, when the option is set. When unloading, use with FIELD_OPTIONALLY_ENCLOSED_BY, to distinguish between empty strings and NULLs.