The MASM Forum Archive 2004 to 2012

Project Support Forums => IDE Development and Support => Easy Code => Topic started by: scjain on October 03, 2009, 11:17:52 AM

Title: sqlite3
Post by: scjain on October 03, 2009, 11:17:52 AM
can sqlite3 database may be used in easycode for masm, if yes than how to use the said database for view,edit and delete data?
Thanks in advance for reply-scj
Title: Re: sqlite3
Post by: farrier on October 04, 2009, 09:12:28 AM
scjain,

Yes!

sqlite3 has proven to be a very powerful tool for a number of my projects; all done in assembler (fasm)

Tell me a little more about what you have and what you need to do.  Do you already have a database you must use, or do you need to create one?  Do you want to add records, or just select, edit, and update the records.

Let me know!

farrier
Title: Re: sqlite3
Post by: scjain on October 06, 2009, 01:32:55 PM
hello farrier
thanks for your prompt reply to my query. So far I am able to create,add records in a database, but not getting how to view those records and edit/update or delete those recors. presently i am using easycode for masm. your help in this regards is highly solicited.
thanking you in advance
scjain
Title: Re: sqlite3
Post by: farrier on October 06, 2009, 05:07:22 PM
scjain,

Attached are some code segments which should get you started.  There are other ways to do the same thongs I've done here, but this is how I do it.  Ask more questions if you need to.

hth,

farrier :U
Title: Re: sqlite3
Post by: scjain on August 01, 2010, 10:52:00 AM
hello farrier
thanks for your example which has helped me a lot.but am sorry that i could not proceed further due to prolonged illness,Now I need your help, how to print datas from the database table while processing those datas to laser printer,say cash book etc.
thanking you in advance
scjain
Title: Re: sqlite3
Post by: farrier on August 03, 2010, 04:03:13 PM
scjain,

Glad to hear you are back coding!

Printing can be easy or complicated.  If you are just printing text it can be easy; if you want to print forms with boxes, columns, and rows it will be complicated.

There are quite a few postings here that deal with printing.  I remember donkey did a very helpful post on printing.  Use the search.  The data you want to print from a sqlite Select is just like any other text, either ASCII or Unicode.

You can print raw data--control codes and "text"--to any printer on your network.

http://msdn.microsoft.com/en-us/library/dd162861%28VS.85%29.aspx

hth,

farrier