SQLitening Support Forum

Create table #61 and put your table descriptions there. Two fields... table name, table description.

I have added a redirect from http://sqlitening.planetsquires.com/support/index.php that seems to work.

Thanks Bern, I will do that. I did try to do the redirect but it resulted in an endless loop due to the fact that the forum is in a subdomain on the main PlanetSquires site. I will try a few more options......

I have upgraded the forum to us SSL encryption. You should see an secure padlock type of icon in your url address bar and the forum address starting with https://
If you encounter problems with the forum, please let me know. Thanks!

I think you need to use the NULLIF function.

SELECT BES_KVANT * PRIS / NULLIF(PRISKVANT,0) FROM IRA

https://www.sqlite.org/lang_corefunc.html#nullif
http://www.peachpit.com/blogs/blog.aspx?uk=Avoiding-division-by-zero-with-NULLIF-Five-SQL-Tips-in-Five-Days-Part-5-
https://stackoverflow.com/questions/19721898/where-and-how-to-use-nullifx-y-function-of-sqlite?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa
http://www.sqlitetutorial.net/sqlite-functions/sqlite-nullif/

You're welcome guys. It's great see Fred's awesome work continue to live on.

Perfect! Thanks
Had some issues with the main planetsquires site but overall the movement of sqlitening to the new site was pretty painless.

I finished moving the forum to a new web host. This forum is now served as a subdomain of PlanetSquires.
http://www.sqlitening.planetsquires.com/index.php

If you find any problems then please let me know. I think that you might have to re-upload any custom avatars that you were using. The attachments should be okay.

If I were to take a guess... I bet you need to wrap all of the inserts into one begin/end transaction. That should speed things up immensely even more so than the compilation time of the sql statement.

I never use NULL either. I find that it complicates things unnecessarily.

Thanks for sharing the link. Fred was truly a great man. Greatly missed indeed.

Hey, some good news....finally. I'll be watching with hope and fingers crossed for a new beginning for the product.

I would also like to hear these stories! Hopefully SQLitening is being used in many different ways.

cj, I believe that I am using the 1.70 source files as per this post: http://sqlitening.com/support/index.php?topic=9427.0

I have edited Post #7 http://sqlitening.com/support/index.php?topic=9635.msg25492#msg25492

Corrected libSQLitening.dll.a import file. Recompiled all DLL's and EXE's. Downloaded latest sqlite DLL. Created a FB port of ExampleB.bas example file.