Is this wrong?
Now I’m more confused than before. Can I ask that the original problem be addressed and only it and no Table classes be brought into the discussion as I haven’t used them yet. I have all my code in an object and I have windows. Windows and object, only.
My real problem I can see is knowing when to use con() and when I don’t need it.
I think what I’m seeing is you don’t need to con() when you use Sta: or Text Block. In those you can put square brackets and they’ll work?
I’m just trying to get row.columns to be recognized properly. I am aware of bind variables but in reading the documentation it seemed only helpful in a repetitious loop to save process time.
Really if the kind of thing that Kelly addressed , if it could be kept to that I’d appreciate it.
I have a doubt about Kellys answer, he seems to say I only need to KSq strings, but not numerics, is this due to the Irish? O’Reilly etc.? Is that because of the apostrophe? You see what level I’m on. I can only dream of learning SQL to the level beyond simply inserts and updates. Frankly, so far, I’m using nearly ONLY the omnis shortcuts $insert, $update, $dowork, $delete. Whole rows. I’m dabbling with inserting fewer fields but the KSq issue comes up.
The question really is WHEN DO SQUARE BRACKETS GET HANDLED and when do they NOT. That’s all. It’s about text strings and quotes. Kelly did handle it but I wonder why the “wrong way” is working for me in some areas and not others. So if anyone cares to still answer, please keep it super simple down to when ksq gets calculated, when not, too many quotes verse using con(), that’s it.
Table classes are tempting as you all say “Oh but the tables handle that”…handle what? I know that the list or row is in there native, that $cinst is your row when you’re in there, something like that. I don’t know enough to use them. I’m stretching my wings by having my code in an object now. Used to be all and only windows. You gotta think “beginnner”. I wish I understood what you all are talking about, but the farthest I am right now is that a bind variable has an @ in front of it, and ties to memory directly. I read that. That’s all I know. Tables, nothing.
I’ve gotten a lot done, I’m proud of myself, but I did a lot of coding without testing, now I’m testing, and this one issue of my text strings being too quoted and not con()’d has come up.
I can’t believe the level some of you are on, such as Doug, Graham, Alex….others….ya’all get going amongst yourselves and it’s phew, right over my head. Oh well. Andreas is another, high thinker, knower of great amounts of omnis tricks and truths. SQL, what a bear.
Beginner! I shout. Darn. Don’t like being a beginner.
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:email@example.com