# The New Language Reference (Local) **URL:** \ **Category:** General\ **Created:** [June 7, 2016, 8:29am UTC](https://forum.xojo.com/t/the-new-language-reference-local/31834 "2016-06-07T08:29:31Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\ **Post date:** [June 7, 2016, 8:29am UTC](https://forum.xojo.com/t/the-new-language-reference-local/31834/1 "2016-06-07T08:29:31Z")
The New Language Reference (Local): 2016R1.1 / OS X 10.11.5… `1. New Project, 2. Open the new Language Reference, 3. Cmd-Option-M 4. Type in the Method name: "SQLite_" (without the quotes) 5. Click in the Language Reference` enjoy the flickering, but this is not the end (but near) ! `6. In the Language Reference, type SQLIte, click in SQLiteDatabase, 7. Choose the first code example, 8. Click in the Code Area, 9. Cmd-V, or Edit-Paste or even back to the Language Reference and drag and drop the code…` NOTHING ! Tip: close the Language Reference window and you will be able to paste the code. In the example: [code]Dim sql As Text sql = “DELETE FROM Team WHERE ID = ?!” ’ Pass in values after sql instead of doing string replacement Try Dim ID As Integer = 100 ’ Primary key for row DB.SQLExecute(sql, ID) ’ Previously connected database Catch e As SQLiteException Dim err As Text = e.Reason End Try[/code] `DB` from `DB.SQLExecute` does not exists: I inderstand. But when I declare one, I get an error in `ID`. Also `SQLiteException` is unknow in `Catch e As SQLiteException` Then, I shutdown the computer and go to bed. ---
**Author:** ![Tim\_Parnell](https://forum.xojo.com/user_avatar/forum.xojo.com/tim_parnell/32/161_2.png) [@Tim\_Parnell](https://forum.xojo.com/u/Tim_Parnell)\ **Post date:** [June 7, 2016, 12:13pm UTC](https://forum.xojo.com/t/the-new-language-reference-local/31834/2 "2016-06-07T12:13:05Z")
That kind of SQLExecute is in the new framework for iOS only. I have a small feeling you were trying to use it elsewhere. ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [June 7, 2016, 1:26pm UTC](https://forum.xojo.com/t/the-new-language-reference-local/31834/3 "2016-06-07T13:26:00Z")
The New Language Reference (Local): 2016R1.1 / OS X 10.11.5… 1. New Project, 2. Open the new Language Reference, 3. Cmd-Option-M 4. Type in the Method name: “SQLite\_” (without the quotes) 5. Click in the Language Reference 6. In the Language Reference, type SQLIte, click in SQLiteDatabase, 7. Choose the first code example, press cmd-C 8. Click in the Code Area, 9. Cmd-V, or Edit-Paste Now this is one of those areas where there is a bug in the local reference. We have 2 SqliteDatabases and associated recordsets etc - one in the classic framework and one for the new framework. But they have the exact same name and the only distinction is what kind of project you can use them in. We’ll have to correct that issue. The result is that when the local documentation set is created the dev center entries overwrite the older wiki ones and because this class is named exactly the same, has the same scope etc, we end up with only one of the two entries in the database. ---
**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\ **Post date:** [October 29, 2020, 6:21pm UTC](https://forum.xojo.com/t/the-new-language-reference-local/31834/4 "2020-10-29T18:21:01Z")