MySQL database connection

[lsunw]

Hi,

Anyone here know how to make a MySQL databse with DHPOS stock table?
Is it possible to make a third party program like APRINT to connect to MYSQL? by using MYSQL ODBC?

http://www.mysql.com/products/connector/odbc/

For example, everytime ring up sale with DHPOS, it will deduct the quantity item in the mySQL...the idea is to make the mysql as the main control inventory.

if this can accomplished then will safe allot of work to sync the stocktable in DHPOS and web application using mysql database such as ecommerce or web ERP.

[marine64]

In short No it is not possable. at least not at this time as there is no qbasic connector for mysql. however maybe oneday. sorry

[ZeeMan]

Well, you don't neccessarially need to use QBasic. Theoretically you could look at the QBasic examples for accessing the stock table and figure out the equivelent commands for another launguage with access to MySQL, and then run the program in paralell with DHPOS.

Also, I think that it is possible to use DLLs with QBasic (I'm not sure though) so you might be able to use the QBasic examples and have them use functions from the DLLs to send their output to MySQL. I'm not sure about this though, so you'd have to test it out (don't forget to back up your files!)

[lsunw]

I also think so...but i'm not a programmer.

That why i post to see got anyone can help to write one that similar to APRINT...anyone here have done any similar program!?

[Jonathan Simpson]

It's possible to IMPORT the stock table into mysql using any of a variety of methods.

It's probably possible to export from mysql into POS, as well.

What is not possible is having POS use mysql as a stock table while running

[lsunw]

Not sharing same stock table...What I mean is when rung each sales, there a 3rd party program (like, APRINT) which will deduct the same stock no. which located in the mySQL database.

In this case, I only need to track only 1 stock table which is mySQL.

[bob5731]

That would help in my pos for windows