I’m using ARGen for a desktop project using the SQLite database am unable to build because my licence is a simple macOS only desktop licence.
According to Xojo, that should be fine (I think) for SQLite projects ( https://xojo.com/store/index.php ). But I could be wrong and ARGen could be using something in its active record pipeline that requires some connection not allowed in the budget version of Xojo.
I’ve tried to remove every reference I can find to other databases in the code ARGen produces, but still am unablae to build.
So, either I’m missing something, or ARGen requires a “Desktop Full” licence to use. If it’s the latter, I’ll upgrade, but I really don’t want to spend the extra $300 if I don’t need to.
It should be fine just make sure you’re using only SQLite methods and functions, otherwise that could be the cause of the error message. If there is not reference for “generic” database methods (or other database classes methods) then I guess you should contact ARGen developer to find the origin of the problem.
Yes, the thing is, ARGen creates a ton of functions and it’s really hard to tell if I’ve deleted them all.
ARGen is great, by the way. It’s super useful, but some parts are not very clear. For example, it does not handle saving pictures to a database very elegantly, even though the code contains a comment like this:
' static arsAllowPrefix() as string = Array("m_", "m_id","i","s","dtm","dt","b","d","v","pict")
and seems to deal with blobs in its BKS_ActiveRecord.MapFieldInfo method. But there are workarounds for that.
Thanks Christian. I clicked the link and started the video. Almost from the beginning you note that the plug-in requires a Database connectivity Xojo licence. That sort of brings me back to my original question.
What is going on in a project that lets Xojo know such a licence is required? I suspect ARGen also requires such a licence, but I don’t remember coming across that in its limited documentation.
The PDF sent me by the developer says:
[quote]ARGen is a utility made by BKeeney Software that can save a Xojo developer many hours of tedious coding by automatically generating code and user interface elements for their database applications.
ARGen works by scanning the database of your choice: CubeSQL, ODBC, Oracle, Microsoft SQL Server (Windows only), MySQL, Postgres, and SQLite. After specifying which tables and views you want to use in your application, you tell ARGen which User Interface elements you want to create as well. It will automatically create List and Edit forms in windows, webpages, or containers and you’ll have stubbed in code to finish later.[/quote]
Is “scanning the database of your choice” what is keeping me from building? Unlike you, they do not specify if a Xojo Database connectivity licence is required. I am in fact trying to use only SQLite.
the ActiveRecord code references MySQL/Postgres/SQLite/etc. And that is what it probably tripping up the “must have database license” code. The is just an educated guess. I would reach out to @Bob Keeney and ask him.
Removing the plug-ins did the trick. There were still some Xojo complaints in the BKSActiveRecord.DatabaseAdapter.BindValues method. But removing that seems to have fixed it. MySQLPreparedStatement and related things.