I have searched this group and the CE group and have been to the SQLite website hoping to find some sample code, but cannot find the answer to this question: I...
You need to construct a proper SQL statement to insert the record data. Learning NSBasic is NOT the same as learning SQL. You'll need to study SQL in order to...
... ...snip... What is the purpose of the invisible text boxes? The whole issue of quote marks can drive programmers bonkers. In your ... would be generate ",...
It's much easier to use the ASCII Character codes in order to construct long SQL strings. Trying to keep track of all those quotes is an exercise in futility....
Thank you, Ed I an glad you posted good code so if anyone else has difficulty understanding this issue they will have an answer. After gathering info at the...
I'm not quite sure what you mean by "instead of a variable name", but basically, SQLite just wants a valid SQL statement. if your combination of variables and...
Thanks, I understand now. I didn't realize Value1 was an SQL statement, I just thought it was a way of renaming a variable. Obviously if I was a professional...
... I have been reading this string of postings and I think I figured out what is going on. There is confusion between how NSBasic and SQLite interract. I...
... This statement is incorrect. Properly declared variables have no issues in a SQL statement. SQL is standardized protocol and SQLite is simply the Open...
If you truly want to use variables within your SQL, here's a starting point: http://www.sqlite.org/cvstrac/wiki?p=DynamicLanguageInterfaceToSqlite The article...
I think it's obvious that very few people here have ever actually used SQL. All these issues arise when people put the cart before the horse. SQL is a...
Pay particular attention to the For Next Loop You'll see proper SQL statement concatenation that uses both string data and variables. This particular code uses...
I've been using SQL for 15 years now. The problem with most of this discussion has been in phrasing. I think your last summary should hopefully clear things...
Okay, with a little time to think I realized my last message probably was not phrased the most tactfully. First off, Tim, I want to say that in general I am...
No Harm, No Foul. As they say in da hood, Peace Out. ... actually used ... values to ... work on ... I were ... <tmarkoski@> ... program ... string ... Source ...
I think we all learned something and not just about computers. I am a marketing consultant by profession. When I begin working with any new client, the first...
Alan I agree with you that we all learned (or been reminded of) something. Having been in the computer business since 1969, we each have a way we learn how we...
I need to bring a window to the top and make it active, even if it has been minimized or is covered by another window, or if the screensaver has kicked in. I...
Is there anyway to make all forms appear in the center of the screen? I know visual basic has this. I saw a post about the size of forms changing and that was...
http://tech.groups.yahoo.com/group/nsbasic-desktop/message/1958 <http://tech.groups.yahoo.com/group/nsbasic-desktop/message/1958> Save the code shown as a...
Thanks again Tim, works great. I did a search for "centering" forms and this thread didn't come up because Geoff spelled centring the English way! Like...
Here I am again - hope I don't look stupid! The problem I am having is that I wrote one application that gathers data. I am now writing another application...
... Back in the days of MSDOS and QBasic, there was a garbage collection issue. If memory serves me correctly, the FRE function would return the amount of...
... ...snip.... I am having the same problem with an app I am working on. I have captured a copy of the input file so I can recreate the scenario. I am...
This is a limitation of the textbox control. It is not a 'garbage' collection issue or memory leak. You have a bytesize limit to what can be placed in a...
Dear all, I apologise if this is off topic. However, as an NS Basic developer who uses it on Pocket and ultra-mobile PC's to work on mobile data acquisition, I...
... data ... But there definitely *is* a memory deallocation problem that happens. Try writing a medium-sized string to some textbox.text over and over again,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
