Fr Simon Rundell Member Licensed User Longtime User May 21, 2020 #1 I usually make a major mistake in the format/way/technique of posting my queries but is this a (silent) bug? As you can see I am declaring and using my B4XTableColumns but the IDE doesn't like it. It works, but is it a syntax checking problem or am I doing something not technically allowed but which works? I'm currently having so much fun in lockdown with B4X, and the XUI stuff is just fab, Erel, thank you so much!
I usually make a major mistake in the format/way/technique of posting my queries but is this a (silent) bug? As you can see I am declaring and using my B4XTableColumns but the IDE doesn't like it. It works, but is it a syntax checking problem or am I doing something not technically allowed but which works? I'm currently having so much fun in lockdown with B4X, and the XUI stuff is just fab, Erel, thank you so much!
LucaMs Expert Licensed User Longtime User May 21, 2020 #2 Fr Simon Rundell said: and using my B4XTableColumns Click to expand... If you only set a value of a variable (or some properties of an object) it is considered "not used" and this is right. If I had: Dim T As Long T = 1000 but nothing else about T, those two lines would be completely useless. Upvote 0
Fr Simon Rundell said: and using my B4XTableColumns Click to expand... If you only set a value of a variable (or some properties of an object) it is considered "not used" and this is right. If I had: Dim T As Long T = 1000 but nothing else about T, those two lines would be completely useless.
Fr Simon Rundell Member Licensed User Longtime User May 21, 2020 #3 Ahh - yes, I don't intend to do anything with them columns yet but kept this code format incase I needed to mess with their size etc. Much clearer, THANK YOU. Upvote 0
Ahh - yes, I don't intend to do anything with them columns yet but kept this code format incase I needed to mess with their size etc. Much clearer, THANK YOU.
Sandman Expert Licensed User Longtime User May 21, 2020 #4 Off topic, but might still be important: Depending on what lblID is, you might be open to a database exploit. See #4 in the list of code smells: https://www.b4x.com/android/forum/threads/b4x-code-smells-common-mistakes-and-other-tips.116651/ Upvote 0
Off topic, but might still be important: Depending on what lblID is, you might be open to a database exploit. See #4 in the list of code smells: https://www.b4x.com/android/forum/threads/b4x-code-smells-common-mistakes-and-other-tips.116651/
Fr Simon Rundell Member Licensed User Longtime User May 21, 2020 #5 Thank you. I did try to avoid it but a) The uid is an integer and when passed as a parameter I was unable to cast it from a String to an Int, so it crashed at WHERE uid='11' b) It is not an input but stored in a non visible label, so I figured safe from SQL injection. I'm not the best (nor a professional) coder (completely self-taught) but I try... Upvote 0
Thank you. I did try to avoid it but a) The uid is an integer and when passed as a parameter I was unable to cast it from a String to an Int, so it crashed at WHERE uid='11' b) It is not an input but stored in a non visible label, so I figured safe from SQL injection. I'm not the best (nor a professional) coder (completely self-taught) but I try...
Sandman Expert Licensed User Longtime User May 21, 2020 #6 Fr Simon Rundell said: I'm not the best (nor a professional) coder (completely self-taught) but I try... Click to expand... You seem to be doing fine, keep it up... Fr Simon Rundell said: The uid is an integer and when passed as a parameter I was unable to cast it from a String to an Int, so it crashed at WHERE uid='11' Click to expand... ...but this might still be worthy of its own thread even if it's not an editable value. Upvote 0
Fr Simon Rundell said: I'm not the best (nor a professional) coder (completely self-taught) but I try... Click to expand... You seem to be doing fine, keep it up... Fr Simon Rundell said: The uid is an integer and when passed as a parameter I was unable to cast it from a String to an Int, so it crashed at WHERE uid='11' Click to expand... ...but this might still be worthy of its own thread even if it's not an editable value.
