POS and Inventory System

Submitted by asterix on Wednesday, March 2, 2011 - 20:23.

Language


This is a pos and inventory system in visual foxpro using postgresql as database.... I guess this combination is something unusual....(^ ^,) If you want to try this system: please use 8.3 or higher version of postgresql...

Tags

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byjayant0210on Fri, 03/04/2011 - 01:05

hi,
i have seen ur project. it looks nice but i am very beginner to this database system. can u help me out how can i restore the database.?

here are the steps:
1. create a database first in postgre
2. right click the on the database you created,then click restore
3. locate the database. *the one with .backup extension in the database folder of my application.

*you also need to create an odbc connection...i forgot to include the code in my project...
you must manually create one....(^ ^,)

Submitted byAnonymous (not verified)on Fri, 09/21/2012 - 18:25

The structure, Forms and the reports look great but I not able to restore data from PostGre9.2SQL. It is returning Error:
Process returned exit code 1.
Please help me restore and make connection. (I didn't use Postgre before)
Regards
Dorel
[email protected]

Submitted byMAKSOOD ALI (not verified)on Wed, 10/30/2013 - 16:49

The structure, Forms and the reports look great but I not able to restore data from PostGre9.2SQL. It is returning Error:
Process returned exit code 1.
Please help me restore and make connection. (I didn't use Postgre before)
Regards
MAKSOOD ALI

Submitted byAKHILESH JHA (not verified)on Mon, 08/07/2017 - 00:35

Sir,
I restore database and create ODBC, it connecting properly but tables are not available in database please share proper database or guide me how to find table in database

Submitted byvickriz.16 (not verified)on Wed, 01/31/2018 - 20:24

hi there. im looking for someone that cant help us build small pos system of oursmall store. can you contact me 09282188872

Submitted byAnonymous (not verified)on Fri, 03/04/2011 - 09:24

herels the steps:
1. create a database first in postgre
2. right click the on the database you created,then click restore
3. locate the database. *the one with .backup extension in the database folder of my application.

*you also need to create an odbc connection...i forgot to include the code in my project...
you must manually create one....(^ ^,)

Submitted byAnonymous (not verified)on Sat, 03/05/2011 - 12:58

I have created the database named as ospos
and odbc as ospos.
is the correct ?

thanks.

Submitted byAnonymous (not verified)on Sat, 03/05/2011 - 17:27

yes..
can you show me the screenshot of the odbc connection you created...

Submitted byjayant0210on Sat, 03/05/2011 - 14:26

is there any odbc to be created to run the software?. I have installed postgreSQL 8.3 by which name database has to be created. ?
I m sending you few screen shots on ur gmail. can u pls let me know why the application is not running. I dont know that is there any problem with postgreSQL installation.

pls guide me how to create the odbc because I m very new to this database system. I would like to enjoy this because it looks great but very complicated.

Thanks for ur quick reply.

Submitted bycool_angoton Tue, 03/15/2011 - 14:18

sir...i was impressed at your POS, is there a way can you help me in building Library Management System? i mean can you share me your source code you have in this system, (if any sir)..please, thank you...

in the zip file is complete source code of this system...

Submitted byAnonymous (not verified)on Thu, 03/31/2011 - 14:17

Hi sir..

i'd like to ask a favor from you so i can study about Foxpro..

im a slowlearner.. and for me to learn is to hands-on can you give me some sample program or system with coding for visual foxpro 6.0?

my email add is [email protected]

hope you can help me..

God bless

Submitted byshawnrayon Thu, 03/31/2011 - 14:27

Hi Sir..

can you help me? i would like to learn foxpro 6.0, but im a slowlearner sir.. i can't get the language on reading only. for me to understand is hands-on. with your help i can learn it.. any sample system.. or program with codings.. is ok..

you can email me at [email protected]

hope you can help me

GOD BLESS

thank you

Submitted byAnonymous (not verified)on Wed, 04/06/2011 - 10:51

Can you change your database to MySql or MSSql? i really hard time to install Postgre. Thanks

Submitted byAnonymous (not verified)on Mon, 04/11/2011 - 11:28

I wud take a long time to convert it to mysql coz some data type are not supported in mysql...

Submitted byAnonymous (not verified)on Sat, 04/23/2011 - 23:00

Can you change your database to Foxpro Database or Microsoft Access or Microsoft SQL Server ? i really hard time to install Postgre. Thanks

Submitted byAnonymous (not verified)on Sun, 04/17/2011 - 13:37

can you give me password for this project

we'll it regards for that, the database of this system is .dbf but i already call the database for that system into SQL codes.

Submitted byAnonymous (not verified)on Sat, 06/18/2011 - 15:59

hi sir can you make a system that an item can record its date when borrowed the concept is like a borrowing a cd in a cd rental store..my email add is [email protected]

Submitted byAnonymous (not verified)on Mon, 07/18/2011 - 19:25

Dear Sir,

Thanks for your project pos and sales inventory first. But I can't run it due to database. I have installed postgre 9.4 and tried to restore your bakup file as you told. But it returned with error code 1. It's may be mismatch with me due to database password/user or database name or role you have taken. If it is possible to provide sql script file ( of database and table creation) for postgresql in my email will be really helpful to run the application and also sample connection code.

Thanks again.

Enam

Email: [email protected]

Submitted byAnonymous (not verified)on Tue, 07/26/2011 - 03:16

sir,
to restore the backup database it may be required database username and password during taking backup. please if possible mail me sql script of database and table creation will be assistance for me learning about your source code.
if any one can restored the database and run the pos please mail me how the database restored.
email: [email protected]

thanks

Submitted byAnonymous (not verified)on Tue, 07/26/2011 - 19:50

actually could u run the program with postgresql database yourself in your computer.

Submitted byAnonymous (not verified)on Sat, 10/01/2011 - 15:29

Sir.. is it ok for you to create a library system using visual FoxPro with .dbf database?
Content:
1. Access levels: Student and Librarian(admin)
2. Borrowing and Returning
3. Inventory
4. Reports
5. user registration

thanks in advance!

My Email Add: [email protected]

Submitted bytito (not verified)on Sun, 01/08/2012 - 09:50

Thanks...
yes... its run
very helpful

Submitted byAnonymous (not verified)on Thu, 06/13/2013 - 17:26

Hello there!! I would like to know the details on how did you run this app. I tried it but yet unsuccessful after installing postgre... Pls help me. thanks a lot..

Submitted byRaaj (not verified)on Mon, 03/12/2012 - 19:52

sir,
i have PostgreSQL 8.4, but i m new to VF can u send me full detail how to run database ....... ODBC connection......... and PostgreSQL connection....
my mail id [email protected]

Thanks

Submitted bycompuzonon Tue, 04/03/2012 - 18:21

The structure, Forms and the reports look great but I not able to restore data from PostGre9.1SQL. It is returning Error:
Process returned exit code 1.
Please help me restore and make connection. This would help to study your project in detail.
Regards
Jan
[email protected]

Submitted byHAULKHORY (not verified)on Sat, 05/12/2012 - 13:05

DEAR SIR, I am new to vfp, was using fpd 2.6. I would high appreciate if you can email me teh steps, how I should create the odbc connection for this project.

thanks in advance

PUBLIC pnconnectionhandle
lcDSNLess="DRIVER={PostgreSQL ANSI};SERVER=192.168.1.4;port=5432;UID=postgres;DATABASE=ospos;PWD=123456;"

pnconnectionhandle=SQLSTRINGCONNECT(lcDSNLess,.T.)
IF pnconnectionhandle > 0
WAIT WINDOW "Konnect" TIMEOUT 2
ELSE
WAIT WINDOW "Error " timeout 3
pnconnectionhandle = 0
ENDIF

Submitted byHerman (not verified)on Thu, 06/14/2012 - 18:44

HI i downloaded your POS but i still receive error like variable error b not found it may be connection string
What ODBC driver you use, I can open open the postgresql and it appears taht the database is already there what to do next?

Submitted byAlmorliz (not verified)on Thu, 06/21/2012 - 23:05

Can you help me? I need USER ID and PASSWORD for Cyber Pos. Thanks.

Submitted byUsuario (not verified)on Fri, 06/22/2012 - 00:05

Can you help me? I need USER ID and PASSWORD for Cyber Pos. Thanks.

Submitted byhac (not verified)on Fri, 11/14/2014 - 09:10

username :'1111'
password :'thailand'

Submitted byAnonymous (not verified)on Mon, 05/20/2013 - 21:48

Im a biginner of visual foxpro...i don't know this much of presentation
may given through visual foxpro..(i completely study your project)
and all the moduls u created is so attractive...now i had 2years exp in visual foxpro..now i love this domain, because of u...thank u sir..

Submitted byMisha (not verified)on Wed, 08/14/2013 - 15:52

The program is great!
which tool you used to write (generate) SQL queries, reports ..etc

Submitted byMutunga (not verified)on Fri, 09/20/2013 - 18:55

First of all let me thank you profoundly for sharing your great work. I have installed the application and followed instructions. I have postgreSQL9.3 but when I create a database with the name ospos and try to restore from the pos_database file under database I get and error. Would you be kind enough to send me a backup file that works with postgreSQL9.3.

I have followed the issues that many of your fans have raised and this seems to be a big one. Kindly help us with a compatible database even a tar format and we will really appreciate (email is [email protected]) . Below is the error I get:
Process returned exit code 1.

Thanks in advance

Submitted byMutunga (not verified)on Fri, 09/20/2013 - 19:22

Hello,

Never mind my earlier query. I got it working finally. Thanks a lot. Nice software. I like your interface and style of coding. Cheers!

after logging in using this username '1111' and password 'thailand'
i received an error 'connection handle is invalid, then variable b
error and so on then after ignoring all of it message is closing transactions.

please help.

you can email me at [email protected]

Add new comment

About text formats
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.