POS and Inventory System

Submitted by: 
asterix
Wednesday, March 2, 2011 - 20:23
Language: 
Foxpro
Visitors have accessed this post 64988 times.

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: 
inventory system
pos
Visual Foxpro
Postgresql
MUST
asterix's picture

Article by asterix

asterix has submitted 4 source code / articles.

If you like this post, you can follow SourceCodester on Twitter.

Subscribe to SourceCodester feed via RSS or EMAIL to receive instant updates.

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

Reshab (not verified)

Tue, 10/18/2016 - 16:12

plz upload more accounts project
thanks

mazatl (not verified)

Mon, 07/20/2015 - 08:44

here are the steps:
1. create a database first in postgres
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 the application
No importa que te de un código de error Numero 1

Ahora abre el vfp y busca el formulario de login
en el boton de login coloca el siguiente còdigo
para lograr una conexión odbc

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

El usuario y password son 1001005 y 123

LukeAjax (not verified)

Fri, 12/05/2014 - 08:30

I'm interested in your software. I would like to get a copy of your source code. What do I need to do? Thanks.
contact me at [email protected]

Robert Brown (not verified)

Fri, 10/31/2014 - 05:14

Hi, please Can anyone tell me how to create the database to test the program? Send me an E-Mail: agarciagaray[at]openmailbox[dot]org

Joven (not verified)

Fri, 09/26/2014 - 02:34

Sir tanong q lng po pe b iconnect sa local network pano b isshare ung datebase sa network kng nasa main server ung program po. Pano po kpg dumami n ung data hndi po b babagal yn in future? Wala po bng seconds delay kpg nag search kau kng nka conect sa ibng network ung main?

Anonymous (not verified)

Tue, 03/04/2014 - 15:44

can you email you source code. . I very much need it . ..pls email in [email protected] . thank you so much.. . if you help me im very much appreciated...

asterix

Mon, 05/12/2014 - 18:14

In what way could my code can help you?

jerz

hac (not verified)

Fri, 11/14/2014 - 09:17

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]

Anonymous (not verified)

Mon, 10/07/2013 - 22:29

what is user name & password?

Mutunga (not verified)

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!

Mutunga (not verified)

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

Misha (not verified)

Wed, 08/14/2013 - 15:52

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

Anonymous (not verified)

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..

anonymous

Thu, 10/18/2012 - 10:38

sir pwede po bah bigyan mo ako na code para lang po sa project.maraming pong salamat!!

Usuario (not verified)

Fri, 06/22/2012 - 00:05

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

hac (not verified)

Fri, 11/14/2014 - 09:10

username :'1111'
password :'thailand'

Almorliz (not verified)

Thu, 06/21/2012 - 23:05

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

Herman (not verified)

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?

HAULKHORY (not verified)

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

Misa (not verified)

Wed, 08/14/2013 - 16:12

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

compuzon

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]

Raaj (not verified)

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

tito (not verified)

Sun, 01/08/2012 - 09:50

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

Anonymous (not verified)

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..

Anonymous (not verified)

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]

Anonymous (not verified)

Tue, 07/26/2011 - 19:50

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

Anonymous (not verified)

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

Anonymous (not verified)

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]

Anonymous (not verified)

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]

Anonymous (not verified)

Tue, 05/10/2011 - 22:14

sir can u change this database to DBF

thx,

rizwi

Anonymous (not verified)

Thu, 05/12/2011 - 08:35

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.

asterix

Wed, 05/18/2011 - 22:29

may i know who this is?

jerz

Anonymous (not verified)

Thu, 05/12/2011 - 17:30

sir can u change the database to foxpro with dbf tables and can u link the project to dbf table,

can email me that pos system please sir,

Rizwi,

[email protected]

thnx

Anonymous (not verified)

Sun, 04/17/2011 - 13:37

can you give me password for this project

Anonymous (not verified)

Tue, 04/19/2011 - 20:03

what password do you mean?

Anonymous (not verified)

Wed, 04/06/2011 - 10:51

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

Anonymous (not verified)

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...

Anonymous (not verified)

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

Anonymous (not verified)

Sun, 04/24/2011 - 20:43

what's your problem in installing postgresql?

shawnray

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

Anonymous (not verified)

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

cool_angot

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...

coolangot

Anonymous (not verified)

Mon, 04/04/2011 - 13:18

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

jayant0210

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.

Jayant

Anonymous (not verified)

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....(^ ^,)

Anonymous (not verified)

Sat, 03/05/2011 - 12:58

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

thanks.

Anonymous (not verified)

Sat, 03/05/2011 - 17:27

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

jayant0210

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.?

Jayant

Anonymous (not verified)

Fri, 03/04/2011 - 09:32

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....(^ ^,)

vickriz.16 (not verified)

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

Pages

Add new comment

More information about text formats

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.