storing binary into a altSQLite DB

chris bohnert chris at altuit.com
Mon Oct 16 16:35:42 EDT 2006


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 <christian.langers at education.lu> 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
> > use-revolution at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-revolution
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>



More information about the Use-livecode mailing list