PureBasic Forums - English

Any chance of SQLITE3 commands being upgraded to latest version of Sqlite3 and with support for Encryption using the pragma key (a free add-on to SQLITE)???

Hi,

Can anyone post any code about how I would interrogate a database in ODBC to gather details of indices per table or for a particular table in the ODBC database??

Just can't fathom it...

Thanks Bernd, think I may have found my way through my coding problems...

Must now test that and see...

@ TI-994A, All,

Using your code, with the Get Blob command, does the *buffer have to have come from a *buffer = AllocateMemory command or can it be any old pointer to any point in memory?

@ IdeasVacuum,

Could you perhaps add a little more info about that?

(thanks in advance)

@ Tenaja,

What I want to do is say an AllocateMemory of say 1000 bytes is at xxx pointer in memory rather than have Purebasic allocate me the pointer in memory at which that AllocateMemory is.... hope that makes more sense?

Once again, thanks Tenaja

@ Tenaja,

Thanks for the speedy response - so could you run through what would happen if I put a datasection in a procedureDLL
and within that say included binary file a$ (where a$ was a filename fed in as a parameter to the procedureDLL)???

Just wondering whether there was any way to fix an AllocateMemory patch of memory to a particular point(er) in the memory rather than just being assigned back *memoryID? (if you see what I mean)

Is it possible to place a Datasection (from which say a binary file could be read) within a ProcedureDLL/CDLL?

@ TI-994A,

That is totally excellent - thanks v much. V helpful....

@ TI-994A,

Thanks for getting back to me so quickly on this. I almost get it.

I couldn't persuade you to post some pseudo-code could I? Creating a table with a record/id column, two text columns and then say three blob columns and then getting data from the middle blob?

Let's say I've created a table with several columns already and then I go to Set Blob command.

How do I know which numbered column /column index (0,1,2,3?) the blob column is at?

Does the Get Blob command work differently?

Or must I always create blob columns when first creating the table?

Do ...

Did anyone actually get to the bottom of this - I am trying to create functions returning strings with ProcedureCDLL.l for commands in to DarkBasicPro (latest versions of DBPro and PB owned) and I get crashes (in Windows 7 and Vista) -

Has anyone figured out the secret to it that seems to have ...

@ em_uk,

I actually agree. But this method of animation very much in fashion at the moment for 2d - and these sort of applications/formats make it very easy indeed.

Just an idea.