LiveCode Forums.

I am also having problems with using the 'browser". A very simple script I made some time ago to display a local pdf file does not work now. The Browser Sample in the tutorials is not working- it will not display data for me although it looks as though the data has downloaded. I downloaded a fresh ...

A (delayed) follow up note.
I finally had time to get back to realbasic (2008- recently released) for this project. It does NOT behave correctly. It behaves differently to revolution and some aspects encouraged me to think it would do what I want. However, the more detail I applied the more it ...

I have no real expertise in programming, which can sometimes be an advantage. I just try things to see if they work without knowing or worrying about some complexities.
The RealBasic HTMLViewer seems to behave for what I am trying to do. I do not know why that is.

Gyroscope is partly correct. I do ...

Thank you for your help. I started this project in RealBasic and thought I would see how it could be done with Rev, but now I know I may as well stop there. At least I did not waste any time as the limiting factor was almost immediately apparent.
Back to RealBasic. Thanks again.

I want to have a line follow the cursor. No problem. Simple with only one line of code.

I also want the line to move over a revBrowser object that has had a pdf loaded. Problems-
1) The revBrowser object always seems to be "on top" and the graphic (ie the line) will not display over the browser.
2 ...

Hi Mark. I think I am in a completely different time zone hence the delay with my responses.

Because the data will be different at each computer. There will be some common records but it is likely that the majority will be different as the users will be different and the data will come from any ...

Hello Mark and thank you again . Of course your code works. I tried a number of combinations to no avail. Sometimes I start to follow a path and I then cannot see where I am wrong. I'll have to remember to force myself back to the beginning when I am struggling.

Your use of the external is ...

Thank you Mark
As I understand it, the line will have to read
shell("sqlite3 testxx2.db "select * from test"")
and the extra quote constants are the only way I can get it to read correctly as a string.
Why am I doing it this way? I came across a good sqlite book and while working in the shell ...

I am experimenting with the sqlite shell via Revolution with some success. I want to select files from a database. The command
sqlite3 testxx.db "select * from test"
at the shell gives the desired result.

I am using 2 identical databases testxx & testxx2 so that I know which one I am referring ...

Thank you, Mark, for your suggestions and please excuse my tardy reply. I did not have much time to try things.
It came down to a matter of trial & error to some extent, but I have something that works.
You correctly noted that "**" refers to the long path to the file. The database is a test file ...

Thank you. I had so many little bits of code trying various options that I did not know what to post. This seems to be the most relevant approach. I have modified it from my original to incorporate the advice you gave about "binfile".

To insert:
answer file "Select"

put "*b" & URL ("binfile ...

I want to directly insert files of any type into a sqlite db. I have used various bits of information available on the forums etc, but no success.

If I insert a simple, small text file then it looks intact in the database. I cannot extract it intact- if I retrieve it from the database it is ...

Thank you. I have not gone ahead with any of the project as I could not work this out. As is so often the case, there is an easy answer when you ask for help. Thanks again.

Can I please ask if anyone has any advice regarding generation of GUIDs for a cross platform database project? Thank you.