Will AU3 can read and write database picture?

[yEn861220]

Will AU3 can read and write database picture?

I was a beginner!

Can cite examples?

[Jos]

what are database pictures ?

[yEn861220]

I am sorry, I limited English proficiency.

What I mean is that the database(MS Access) read or write picture.

[ptrex]

@all

What he is talking about is storing pictures in a DB and reading it afterwards.

This is supported in SQLite (and other databases).

You need to store the data in "BLOB" field.

I hope this gets you going.

#include <SQLite.au3>

Local $hFile, $vData, $sFileName, $sData, $hQuery, $aRow, $sMsg
_SQLite_Startup()
_SQLite_Open()
_SQLite_Exec(-1,"CREATE TABLE IF NOT EXISTS Test (data blob);")
$vData = BinaryToString("Hello" & Chr(0) & "World"); = 48656C6C6F00576F726C64
$sData = _SQLite_Encode($vData)
_SQLite_Exec(-1,"INSERT INTO Test VALUES (" & $sData & ");")
$vData = BinaryToString(Chr(0) & @CRLF); = 000D0A
$sData = _SQLite_Encode($vData)
_SQLite_Exec(-1,"INSERT INTO Test VALUES (" & $sData & ");")
$vData = BinaryToString(Chr(0)); = 00 but this is interpreted as Number and returns 0000000000000000
$sData = _SQLite_Encode($vData)
_SQLite_Exec(-1,"INSERT INTO Test VALUES ( " & $sData & " );")
_SQLite_Query(-1,"SELECT * FROM Test;",$hQuery)
While _SQLite_FetchData ($hQuery, $aRow, 1) = $SQLITE_OK
    $sMsg &= Hex($aRow[0]) & @CR
WEnd
MsgBox(0,"Result",$sMsg)
_SQLite_Close()
_SQLite_Shutdown()

regards

ptrex

[yEn861220]

Thank you,regards

Although I do not understand, but I will make good use of research.