[Pharo-project] ODBC on W7 and Pharo 1.4

Friedrich Dominicus frido at q-software-solutions.de
Thu Jul 26 03:21:53 EDT 2012


"Torsten Bergmann" <astares at gmx.de> writes:

>
> Can you send the CREATE/INSERT script for the table?

>>Can you tell me if  there is a usable tutorial about
>>FFI somewhere. 
>
> Make sure you use latest FFI and ODBC package. For
> a FFI description use
>
> http://lmgtfy.com/?q=Squeak+FFI
CREATE TABLE [tblTest] (
[ID] AUTOINCREMENT,
[DoubleValue] DOUBLE DEFAULT 0);

In Pharo:
c := ODBCConnection dsn: 'testDB' user: '' password: ''.
c execute: 'create table [tblTest2] ([value] int);' 

INSERT INTO [tblTest] ([DoubleValue]) VALUES (23456.0);

Well yes the [] are needed.....

Regards
Friedrich





More information about the Pharo-dev mailing list