My First SQLite Project
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5351
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Has thanked: 212 times
- Been thanked: 232 times
- Contact:
Re: My First SQLite Project
It is cumbersome because of non-existence of sql statements. It is easy to port a MySQL based application to SQLite.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- sudip
- Posts: 1446
- Joined: Sat Mar 07, 2009 11:52 am
- Location: Kolkata, WB, India
- Has thanked: 5 times
- Been thanked: 2 times
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
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
With best regards,
Sudip
Sudip
- sudip
- Posts: 1446
- Joined: Sat Mar 07, 2009 11:52 am
- Location: Kolkata, WB, India
- Has thanked: 5 times
- Been thanked: 2 times
Hello Friends,
This is my first Sqlite real life project. 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 And download source code from And please don't forget to send you comments like before.
With best regards.
Sudip
This is my first Sqlite real life project. 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 And download source code from And please don't forget to send you comments like before.
With best regards.
Sudip
With best regards,
Sudip
Sudip
- sudip
- Posts: 1446
- Joined: Sat Mar 07, 2009 11:52 am
- Location: Kolkata, WB, India
- Has thanked: 5 times
- Been thanked: 2 times
Hello GVS,
Thanks for interest. Please download HFCL from download/file.php?id=355
With best regards.
Sudip
Thanks for interest. Please download HFCL from download/file.php?id=355
With best regards.
Sudip
With best regards,
Sudip
Sudip
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
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
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
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
- Posts: 1446
- Joined: Sat Mar 07, 2009 11:52 am
- Location: Kolkata, WB, India
- Has thanked: 5 times
- Been thanked: 2 times
Hello All Friends,
I found some errors in Printing Report of MyExpense project.
I corrected them.
Please download:-
Souce Code: Setup File: Please send your comments.
With best regards.
Sudip
I found some errors in Printing Report of MyExpense project.
I corrected them.
Please download:-
Souce Code: Setup File: Please send your comments.
With best regards.
Sudip
With best regards,
Sudip
Sudip
- mol
- Posts: 3455
- Joined: Thu Sep 11, 2008 5:31 am
- Location: Myszków, Poland
- Has thanked: 282 times
- Been thanked: 182 times
- Contact:
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?
I have a question: How to lock record in sqlite database in network environment?