BETA

[jsdpr15]

Sir

Any Beta Release is available of Version 3.2.2 ,
if available please provide Sir

Thanks

[pawelsalawa]

I don't practice beta versions anymore. Also there will be no 3.2.2, but already 3.3.0 (see news on the homepage https://sqlitestudio.pl/news/).

[pawelsalawa]

It depends what charset have you used to store the names in the other application, cause SQLiteStudio reads always UTF-8 and it is standard in SQLite3.

[jsdpr15]

Sir,

I Create an View whos showing Total of Amount Month wise

but i want to Know that how to add Grand total of shown in View

and how to convert total Amount in Currency Format??

And Also want to know how to set Text align (i.e. Right, Left, Center e.t.c.) in View

[pawelsalawa]

Regarding Totals, Grant Totals - you need to learn how to use aggregate functions in your SELECT queries: https://sqlite.org/lang_aggfunc.html#aggfunclist

Regarding currency - I'm not sure what you mean here, but if you want to format a number, you can use printf() function: https://sqlite.org/lang_corefunc.html#printf

An alignment is done automatically by SQLite depending of data type returned by a query. If it's a number, it's right-aligned. Otherwise it's left-aligned.

[jsdpr15]

Regarding Totals, Grant Totals - you need to learn how to use aggregate functions in your SELECT queries: https://sqlite.org/lang_aggfunc.html#aggfunclist

Regarding currency - I'm not sure what you mean here, but if you want to format a number, you can use printf() function: https://sqlite.org/lang_corefunc.html#printf

An alignment is done automatically by SQLite depending of data type returned by a query. If it's a number, it's right-aligned. Otherwise it's left-aligned.

how can you please provide example codes

If possible
Please sir

[pawelsalawa]

Dear Janil,

This is not SQLite support forum, but SQLiteStudio forum.
I do help people from time to time with SQL or with SQLite, but mostly I help here people with SQLiteStudio related problems. For learning & asking questions about SQL and SQLite, I recommend you stackoverflow.com, there are millions of people ready to help and here I'm mostly the only one.

[jsdpr15]

Sir,

is his possible to save any query whose need to execute again and again(periodically) in SQlite Studio Software

[pawelsalawa]

• You can save SQL Editor contents into a file and re-load it later if you need.
• You can also just leave SQL Editor open when you close SQLiteStudio and next time you run SQLiteStudio, it will restore you SQL Editor window, together with the query you had in it.
• You can also find your queries executed in the past by switching to History tab (in SQL Editor window) - then double click on a history entry to put it into your execution editor.

[jsdpr15]

sir did you add any option to pin or set an alias to mostly used queries

[pawelsalawa]

No, but you still have the other 2 options to choose from.

[pawelsalawa]

The code snippets feature is on TODO list.

[jsdpr15]

Sir,

Any latest version is available of software

[pawelsalawa]

3.3.3 is the latest released version. I'm working on 3.4.0 version.

[jsdpr15]

Hello sir
Good day
Is there any option to edit print settings in software, bcoz I try to print some reports whose I created in db(as permanent view) so that will separate in 2 or 3 pages

[pawelsalawa]

Only whatever settings you see in the printing dialog. Nothing more.