Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] Suggestions

 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-07-2016, 07:21 AM
aaronjsolomon aaronjsolomon is online now
Registered User
 
Join Date: 07-06-2011
Posts: 34
Programmatic access of SQLite/Ultra Recall database

Hi,

Huge fan of UR, use it all day every day.

I've been doing a fair amount of manipulating UR databases using VBScript and the specially-compiled sqlite3.exe you provide elsewhere in this forum. (IIRC, Kinook made a minor change to the .urd file format so that other products would not recognize it as a SQLite file.)

However, it would be a real boon to be able to use more robust programming tools such as ADO.NET wrappers, ODBC drivers, etc.

RazorSQL is a great RDBMS because it performs all of its functions via the command-line tool, which gives me an opportunity to point to your custom sqlite3.exe.

However, in a scripting/programming environment, I haven't been able to figure out how to access a UR database directly, other than by constructing query strings and passing them to the command-line shell (and even this limited functionality is very useful!). This works reasonably well for simple updates and deletes, but provides no means (AFAIK) to load a result set into memory and iterate/manipulate results via code.

Question: please advise on how one might programmatically connect to a UR database via COM, .NET, ODBC, or the like. One obvious approach would be to tweak UR itself so that it can access .urd files that internally conform to the SQLite file spec, in addition to Ultra Recall's slightly tweaked version. (I'm not looking for a file conversion tool, I can figure that out myself. Just a registry entry that allows a standard SQLite file to be opened and accessed.) This approach seems ideal because I could then access the full set of SQLite tools that are out there, many of which are limited and/or costly.

Alternatively, please advise if there are other paths to this same end. There are supposedly some open source SQLite connectors where I might be able to tweak them to read .urd files, but I'm not an alpha programmer (hence VBScript), and many SQLite dev projects are dormant/flaky, so I'm reluctant to burn time on that path unless absolutely necessary.

Eagerly looking forward to your thoughts!

Cheers, Aaron

Last edited by aaronjsolomon; 12-07-2016 at 08:46 AM.
Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 01:19 PM.


Copyright © 1999-2023 Kinook Software, Inc.