![]() ![]() You can then use the new Version 8 function CsvGet() to parse the result. Using this special delimiter instructs the Sqlite() function to return the results as standard CSV data. Note: Version 8 sees the introduction of the special delim value of "*csv*" (without the quotes). If not entered the default is " " (without the quotes) you can uses any character or number of characters here. ![]() The new database is "created", without any effect on the current connection.ĭelim=xxx - The delimiter to use when returning the result of the Select. No = The current database is not closed and remains the active database. This is particularly troublesome if your current connection is a memory database, as it is deleted on closing the current connection. However, the problem comes about when all you want to do is attach the newly created database to your existing connection. This is most likely what macro authors will usually want. That is, if you don't use this option then GSAK substitutes Active=Yes. SOptions is an optional parameter and only applies to the Create, Sql and Import actions.Īctive=Yes|no - Yes = Close any current connection and make the created database the active database. The most common being the actual SQL query you are performing with the "sql" action. ![]() SData contains the string associated with the action. If using multiple statements, then each statement must end with a " " (semi colon). This enables you to immediately run SQL against the current database without having to worry about open semantics.Ĭreate - create a new database provided by sDataĬlose - close the current database (sdata and sOptions should be "") That is, if you issue a "sql" action but haven't opened a database, then GSAK will automatically use the current live database. However, a special exception has been added for the "sql" action. You should open a databases before using any other action. SData should be the fully qualified path to the SQLite database file name, or the reserved memory only database of ":memory:". Open - open the database provided by sData. For an overview of SQLite please see this topic This function is the main portal to the very powerful SQLite database engine. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |