Loading

POS and Inventory System

Submitted by: 
Language: 
Visitors have accessed this post 56656 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...


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

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

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

i cant find the main form :(

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

How to create an ODBC connection?

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

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

thanks.

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

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

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

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

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

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

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

what's your problem in installing postgresql?

can you give me password for this project

what password do you mean?

sir can u change this database to DBF

thx,

rizwi

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.

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]

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

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

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

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

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?

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

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

username :'1111'
password :'thailand'

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

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

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

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

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!

what is user name & password?

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?

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

Pages

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th>
  • You may insert videos with [video:URL]
  • 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.