// Called by TypeConversion.script. This config file contains information

// for type conversion tests. We put a bunch of data in a database, sometimes

// using the wrong type of Bind, then attempt to read it back, sometimes

// using the wrong ColumnXXXX method, and check for the expected result

// as defined by the spec.

[Top]

Delete0=C:\TypeConversion.db

ExpectedError0=KErrNotFound

Create1=C:\TypeConversion.db

NewBlock2=PopulateDB

NewBlock3=CheckContents

Close4=

Delete5=C:\TypeConversion.db

EndBlock6=

[PopulateDB]

Exec0=Create Table Tbl99(f1 int, f2 real, f3 text, f4 blob);

Prepare1=Insert into Tbl99(f1, f2, f3, f4) values(:f1, :f2, :f3, :f4);

ParameterIndex2=:f1

ParameterIndex3=:f2

ParameterIndex4=:f3

ParameterIndex5=:f4

// Put some basic data into the table. Nothing extreme here...

BindInt6=0,-417

BindReal7=1,2.95e15

BindTextFromFile8=2,Z:\TEF_SQL\TestData\reference1.txt

BindBinary9=3,Z:\TEF_SQL\TestData\reference1.bin

St_Exec10=

Reset11=

// Now put some entries into the table that do not match the expected types.

BindInt64_12=0,-123456789012345

BindInt13=1,47

BindBinary14=2,Z:\TEF_SQL\TestData\reference1.txt

BindTextFromFile15=3,Z:\TEF_SQL\TestData\reference1.bin

St_Exec16=

Reset17=

// Put some more basic data into the table. Nothing extreme here...

BindInt18=0,-1

BindReal19=1,1.50

BindText20=2,Once upon a time...

// Forget doing the binary this time.

St_Exec21=

Reset22=

// Outro

St_Close23=

EndBlock24=

[CheckContents]

Prepare0=select * from Tbl99;

ColumnIndex1=f1

ColumnIndex2=f2

ColumnIndex3=f3

ColumnIndex4=f4

// Try to read the data that was correctly put into the table into the

// wrong types.

Next5=

AtRow6=true

ColumnSize7=0,4

ColumnInt64_8=0,-417

// Maxint (32-bit)

ColumnInt9=1,2147483647

ColumnSize10=1,8

ColumnType11=2,

ColumnBinaryD12=2,

ColumnSize13=2,3626

ColumnSize14=3,8094

ColumnTextD15=3,

NoOperation16=

// Try to read the data that was incorrectly put into the table into the

// correct types. In the case of the ColumnText and Binary lines, we

// specify nothing where we would normally give text to match or a file

// because we expect nothing to be returned from ColumnText/Binary,

// but no error either.

Next17=KSqlAtRow

AtRow18=true

// We put a large negative int64 into an int. What do we get back?

ColumnSize19=0,8

ColumnInt20=0,-2147483648

// We put 47 as an integer into a real field. This should be easy..

ColumnSize21=1,8

ColumnReal22=1,47.000

// We used BindBinary to put the content of reference1.txt (actually

// UNICODE) in this text field. What do we get back?

ColumnSize23=2,7254

ColumnTextP24=2,

// We used 'BindText' to put binary (actually ascii) into this BLOB

// field from reference1.bin.

//

// We get size 4047, not 8094 because this has become a text field.

ColumnSize25=3,4047

ColumnType26=3,ESqlText

// This fails, or rather gives an empty buffer because it isn't a binary field

// anymore.

ColumnBinaryL27=3,

// This should work.

ColumnTextL28=3,Z:\TEF_SQL\TestData\reference1.bin

// Now for row 3. This is really just to test real->integer rounding.

Next29=KSqlAtRow

ColumnInt64_30=0,-1

ColumnInt31=1,2

ColumnTextP32=2,Once upon a time...

// Outro

Next33=KSqlAtEnd

AtRow34=false

St_Close35=

Close36=

EndBlock37=