Search found 1049 matches

by Gablea
Oct 29, 2018 21:08
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

The only thing that is stored is the current sale (so if a item is voided it will be removed from the list) as Items are scanned they are added to the promo table and once the cashier press the Total key then the Local PoS app performs the promotions (ie buy one get one free etc) if for any reason t...
by Gablea
Oct 29, 2018 19:14
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

I understand that but my VB.net version it uses a in memory table to control the receipt data as well as any promotions and i have almost all the code created for all the offers etc so I would like if possible to replicate the function with FreeBASIC
by Gablea
Oct 29, 2018 15:51
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

Yay :)

Is it possible to do in memory table with MySQL? (Local to the machine)
by Gablea
Oct 29, 2018 1:32
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

@grindstone

I shall update the code with that bit added and see what happens.

So from what you can see am i on the right path?
by Gablea
Oct 28, 2018 18:36
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

What I am trying to do is to check to see if any results have come from the server if they have then process them otherwise show a error message So say the user entered the correct user ID and password it would then run this code Dim PasswordChange As Integer = *row[4] Select Case PasswordChange Cas...
by Gablea
Oct 28, 2018 16:08
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

@grindstone i think I have broken FreeBASIC he he Dim SQLQuery As String Dim db As MYSQL Ptr Dim res As Integer Dim restab As mysql_res Ptr Dim row As mysql_row SQLQuery = "" SQLQuery += "select " SQLQuery += "userid, " '0 SQLQuery += "userpassword, " '1 SQLQu...
by Gablea
Oct 27, 2018 20:05
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

@grindstone Sorry maybe I did not explain myself. So as you can see I have a record from the server How would I put the name result from the select cashiername into CashierNamePrint When I was using the csv file I could use CashierNamePrint = cashier_name (as that is the field I used to load the dat...
by Gablea
Oct 26, 2018 19:59
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

@grindstone Thank you so much for the code examples I just need some advice on the following http://www.algpos.co.uk/freebasic/mysql_1.png as you can see the system does find my User ID on the system no how would i get the following populate from the result of the SQL Search? KeyPadInput = "&qu...
by Gablea
Oct 24, 2018 13:28
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

Thank you. I shall have a read of that tonight. And I will see if I can implement it into my simple KPoS application
by Gablea
Oct 23, 2018 13:39
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

@gindstone

Yes please if you could translate it I would appreachate it

I know if I went with MySQL I would no long have dos support but Linux in text mode is almost the same.
by Gablea
Oct 23, 2018 7:26
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

@grindstone My windows PoS is already using the MySQL database. I have tried a few times to get MySQL working but I have hit and miss with it (sometimes it work sometimes it does not) @jj2007 I agree with your option. a simple data file would be better and it would allow me to still support DOS file...
by Gablea
Oct 22, 2018 18:05
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

Ideally I would like to use MySQL as I could use a windows back office and a Linux front end.
by Gablea
Oct 20, 2018 23:51
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

@grindstone

Thank you for that example. i will have a look at it once i have worked out how to get the database files to work right. (still struggling a little with that one)
by Gablea
Oct 16, 2018 14:41
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

Each till is a computer in its own right. They all have network cards and each till have static IP. The tills are all connected to a fast switch the tills all use the full 100MB network connection. And thanks for clearing up the thing about the tills being the server. I wish I could work out how to ...
by Gablea
Oct 16, 2018 11:39
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 8983

Re: Where have I gone wrong

Yes that is correct. Each module is a exe in its own right that would use local tcp ports to talk to the main till program (would the till program be the server or the client)

Go to advanced search