CRUD SQLite example

jesse · Post by **jesse** » Thu May 26, 2011 4:32 pm

works great! it really helped me to get the understanding a bit more and run some testing. How can I set column dynamically from the code? I see
you have hardset the number of columns. Is it possible to set this information in the code as well as the column widths, and fonts, etc...?

townsend · Post by **townsend** » Thu May 26, 2011 6:05 pm

jesse wrote:How can I set column dynamically from the code? Is it possible to set this information in the code as well as the column widths, and fonts, etc...?

Yes-- that's certainly possible, but that would be part of the DataGrid example.

Here's a Stack that will show you how that is done. It's one of my favorites.
DataGrids Tour: http://revonline2.runrev.com/stack/229/Data-Grids-Tour

And here are a whole bunch of other good DataGrid lessons:
http://lessons.runrev.com/spaces/lesson ... =Data+Grid

If you get stuck start a new thread.

PS: Thanks for you help on my DB question.

BvG · Post by **BvG** » Thu May 26, 2011 10:59 pm

Nice!

i suggest uploading it to revOnline ("user samples") too!

maybe make a presentation about it on www.livecode.tv ?

jesse · Post by **jesse** » Thu May 26, 2011 11:23 pm

townsend,

thanks i'll check it out again. and your welcome

townsend · Post by **townsend** » Fri May 27, 2011 4:20 pm

BvG wrote:Nice!
i suggest uploading it to revOnline ("user samples") too!
maybe make a presentation about it on http://www.livecode.tv ?

Thanks! Let me get this uploaded to revOnline, then we can
talk about me doing a short presentation.

bn · Post by bn » Fri May 27, 2011 7:51 pm

Hi Paul,

thank you for the stack. Maybe I finally get around to dig into sql thanks to your example. I actually understood what was going on.

Kind regards

Bernd

jesse · Post by **jesse** » Mon May 30, 2011 6:02 pm

townsend,

I have tried running for CRUD Example as a standalone on Windows but it doesn't seem to update the datagrid
after Connecting, Create Table, Populate, and then when I click Read into Datagrid nothing happens. Any suggestions?

townsend · Post by **townsend** » Mon May 30, 2011 6:57 pm

Yes-- I see that message, "Table 'Users' Updated Successfully" is somewhat
confusing. I've changed it to read, "Selected Row Updated Successfully"
I've attached an updated version.

ALSO-- a much more important change to this version has to do with a
slightly poor coding practice I discovered. Previously, all the exit statements
had included the Hander name. These have all been replaced with the
more generic "exit to top" key phrase, which does the same thing.

This way if you ever want to copy and rename the Handler, you only
need to change the name in two places: at "on name ... exit name"
instead of three or four, or many more in more complex Handlers.

jesse · Post by **jesse** » Mon May 30, 2011 7:02 pm

Thanks for the update. Still I have no clue why when I compile as a standalone none of the buttons that are supposed to manipulate the datagrid are working.
I tried clear datagrid, and read into datagrid but nothing changes on the datagrid. Of course everything works fine while in development mode.

Any ideas?

townsend · Post by **townsend** » Mon May 30, 2011 7:55 pm

I didn't even think to create a Standalone. You're right. The DtataGrid was frozen.
I tried everything I could think of. Nothing worked. So, I just deleted the DataGrid
and created a new one, with the same name. Works good now.

: 102 CRUD SQLite example 3.5.JPG (54.63 KiB) Viewed 22884 times

jesse · Post by **jesse** » Mon May 30, 2011 8:45 pm

That is very odd. I used your CRUD script as a starting point for my script and had the same problem with the datagrid
not working. Sure enough like you mentioned I deleted the grid and re-created it and it works now. If you happen to find
out what the issue was please let me know as I can't figure it out for the life of me. Thanks again for your help!

townsend · Post by **townsend** » Wed Jun 01, 2011 3:56 pm

did you update the download on the other post? i would love to download
it once its updated. its really helped me to understand how to do things more.

Okay-- Here's the updated version, with the dynamic column names.

: 103 CRUD SQLite example 3.6.JPG (60.74 KiB) Viewed 22908 times

BvG · Post by **BvG** » Wed Jun 01, 2011 4:22 pm

Hi

please make a presentation on livecode.tv about the sql example stack, it's so grand! Please contact me at bvg AT mac DOT com.

mwieder · Post by **mwieder** » Wed Jun 01, 2011 8:08 pm

Oooo - I second that - this would make a great presentation for livecode.tv

townsend · Post by **townsend** » Wed Jun 01, 2011 10:34 pm

Thanks for the encouragement guys!
Yeah-- sure-- I'd be glad to do a presentation for livecode.tv
after I finish at the Summer Academy. (3 weeks left)
There's not much to the example. If I ALSO went over the basics of
the SQL manager, SQLiteMan, then I probably could do 20-30 minutes.

BvG-- I'll send you an email about this. Also, I've been trying to
log into RevOnline for days now. It looks like they're not accepting
uploads right now.

LiveCode Forums.

CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example

Re: CRUD SQLite example