Christian,
The revdb documentation is not very clear on this, but when trying to
activate the blob encoding your code should look like the following:
put "*b" & URL("binfile:" & it) into tRowData
put "INSERT INTO Fotos(FotoID,FotoData)" &" VALUES(null,:1)" into tSQL
put revdb_execute(gConID,tSQL, "*b"&"tRowData") into tTmp
you might check out the doc's on revQuerydatabaseBlob which are a little
more explicit on how to use the syntac
--
cb
On 10/16/06, Christian Langers <[EMAIL PROTECTED]> wrote:
Sorry to bother you again, but....
.. it does not do the job... same reactions -->SQLite throws error
message : syntax or unrecognized token
It's perhaps a bug ?
Christian
Le 16 oct. 06 à 19:46, Shao Sean a écrit :
> Let's start with your code from the first example:
>
> put "'"&"*b"&URL ("binfile:"&it)&"'" into tRowData
>
> You're putting extra single quotes around your data, you probably
> shouldn't.. What ends up happening is you move the "*b" code from
> char 1-2 to char 2-3 and the RevDB code won't see it..
>
> put "*b" & URL("binfile:" & it) into tRowData
>
> _________________________________________________________________
> Use your PC to make calls at very low rates https://
> voiceoam.pcs.v2s.live.com/partnerredirect.aspx
>
> _______________________________________________
> use-revolution mailing list
> [email protected]
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
