My First SQLite Project

[Rathinagiri]

It is cumbersome because of non-existence of sql statements. It is easy to port a MySQL based application to SQLite.

[sudip]

Yes, Rathi.
BTW, I finished Setup, automatic Import data from old dbfs, master setup entry with all validation (most of validations are done by Sqlite itself!!!)
Now, I shall do transaction entry, reports (Grid2Print will be suitable), Backup and Restore utilities.
Time to start programming again
Regards.
Sudip

[sudip]

Hello Friends,

This is my first Sqlite real life project.

MyExpenseSql.jpg (47.81 KiB) Viewed 6024 times

This is an update of my old MyExpense project. So, if it is installed in old Folder, it will automatically add existing data from dbf to Sqlite tables. I also added Backup facility (but, not Restore due to some problem. I can't use SQLITE3_CLOSE() function)

Please install from

setup.zip

(1.04 MiB) Downloaded 553 times

And download source code from

MyExpenseSql.zip

(17.09 KiB) Downloaded 562 times

And please don't forget to send you comments like before.

With best regards.

Sudip

[gvaronas]

Hi Sudip, in the source file is missing <hfcl.ch>

Best Regards
GVS

[sudip]

Hello GVS,

Thanks for interest. Please download HFCL from download/file.php?id=355

With best regards.

Sudip

[gvaronas]

Thanks Sudip.
Now I have this error:
Start...
Missing ".o" files: MYEXPENSESQL.O BACKREST.O TRANPRINT.O
TRANPRINT.prg(134) Error E0030 Syntax error: "syntax error at 'GRID'"
Finished With Errors.

The line 134 is:
PRINT GRID grid_1 OF frmTranPrint FONT "Arial" SIZE 12 ORIENTATION "P" ;
HEADERS {"Expense Report"+strHead3, strHead2} COLUMNSUM aSum SHOWWINDOW

Any help / Tip

TIA
BestRegards
GVS

[gvaronas]

I've solved this with:

PRINT GRID grid_1 OF frmTranPrint FONT "Arial" SIZE 12 ORIENTATION "P" HEADERS {"Expense Report"+strHead3, strHead2} COLUMNSUM aSum SHOWWINDOW

making a single line by removing the semicolon

BestRegards
GVS

[sudip]

Thanks a lot friend.

I used an excellent utility Grid2Print developed by S. Rathinagiri. I used HFCL for this utility.

With best regards.

Sudip

[sudip]

Hello All Friends,

I found some errors in Printing Report of MyExpense project.
I corrected them.

Please download:-
Souce Code:

MyExpenseSql.zip

(23.91 KiB) Downloaded 507 times

Setup File:

setup.zip

(1.04 MiB) Downloaded 491 times

Please send your comments.

With best regards.

Sudip

[mol]

Reading this topic, I've decided to try some work with sqlite with my small already working project.

I have a question: How to lock record in sqlite database in network environment?