[Pharo-users] Error: Unable to resolve external type: sqlite_int64 (It was Re: Live interaction with SQLite data from Pharo)
Offray Vladimir Luna Cárdenas
offray at riseup.net
Sun Oct 18 15:39:43 EDT 2015
Solved! Torsten advice was:
Change apiBindInteger: aStatement atColumn: aColumn with: anInteger to
use an integer in the NB call
apiBindInteger: aStatement atColumn: aColumn with: anInteger
"int sqlite3_bind_int64(sqlite3_stmt*, int, sqlite_int64)"
<primitive: #primitiveNativeCall module: #NativeBoostPlugin error:
^ self nbCall: #(int sqlite3_bind_int64 (sqlite3_stmt aStatement,
int aColumn, int anInteger))
module: self library
And now works. Thanks a lot!!!
Now I have another problem. If I ran http://ws.stfx.eu/1VPMHQXNL35N the
first insert command generates a new row in the database but the second
one doesn't, as is shown by querying the database from sqlite3 command
client. What I'm missing?
On 18/10/15 13:22, Offray Vladimir Luna Cárdenas wrote:
> I'm trying my queries in a more static form. My idea is to get proper
> insertion of Smalltalk object values on a SQLite database, but when I
> db execute: 'INSERT INTO BLOGPOSTS values (?, "Hola mundo!");'
> with: #(2)
> I get:
> error message: "Error: Unable to resolve external type: sqlite_int64"
> So seems that the number is trying to talk with the 64 bits of Sqlite
> instead of the 32 bits one which is in the same place that the image.
> Any way to solve this?
> On 18/10/15 10:48, Offray Vladimir Luna Cárdenas wrote:
>> I have followed the short tutorials on SQLite and Pharo and my
>> connection is working properly. But I miss some liveliness on how
>> interact with data base, particularly after seeing the video from
>> Doru at , where near to min 38 he shows a connection with a
>> Posgresql data base which after ran on the playground results in a
>> nice vire with a tab for putting the SQL code and another for
>> inspecting the results in a table format, even for adding data live.
>> Is this functionality only available on Postgres or can also be
>> enabled on a connection for SQLite and if yes, how can it be done?
>>  http://smalltalkhub.com/#!/~PharoExtras/NBSQLite3
>>  https://vimeo.com/97315968
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pharo-users