Search found 1017 matches

by Gablea
Nov 30, 2018 13:28
Forum: General
Topic: Import files
Replies: 15
Views: 380

Re: Import files

I think I will be going with the Types Data interface

But I will need to look into this so I can see understand this method
by Gablea
Nov 30, 2018 11:10
Forum: General
Topic: Import files
Replies: 15
Views: 380

Re: Import files

@Paul Doe

So all I need to do now is crate the function that saves the csv file into a fix length data file (think that would be the simplist part of the project)
by Gablea
Nov 29, 2018 23:30
Forum: General
Topic: Import files
Replies: 15
Views: 380

Re: Import files

@Paul Doe THANK YOU that was just what I was looking for and thank you for the comments explaining what they do it makes sense now And yes I think it was show how to do that but I was struggling to understand what the code did now You have done your example that shows and explains what each section ...
by Gablea
Nov 29, 2018 18:00
Forum: General
Topic: Import files
Replies: 15
Views: 380

Re: Import files

See I’m not 100% up on how to read in the files with tab as the determinator

Is there any simple examples on here that shows how to do that?
by Gablea
Nov 29, 2018 15:48
Forum: General
Topic: Import files
Replies: 15
Views: 380

Re: Import files

So once the file has been converted I just Read it in as normal

Great thanks for the advice I will give that a try tonight
by Gablea
Nov 29, 2018 13:40
Forum: General
Topic: Import files
Replies: 15
Views: 380

Re: Import files

Hi dodicat
Thanks for that advice. But I have to be careful as one of my customers use , in the description name of the items

Is it not possible to split lines at the | and process then like you would with the csv files?
by Gablea
Nov 29, 2018 11:11
Forum: General
Topic: Import files
Replies: 15
Views: 380

Import files

Hi everyone, I have a good understanding of reading csv files and thanks to a few of you on here I am starting to understand how to read in files with tab formats But how would I read in files that use | as field seperators I know this is a very simple question but everything I look at online contra...
by Gablea
Nov 02, 2018 15:00
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 5121

Re: Where have I gone wrong

What I could not understand is why when I used

Dim PasswordChange as integer = *row[4] it would put that as 48 but when I used Dim PasswordChange as integer = VAL(*row[4]) it return the correct value. (where did the 48 come from)
by Gablea
Nov 02, 2018 10:32
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 5121

Re: Where have I gone wrong

I have no idea. But lucky I found it so at least I know if I use the val() command it will work.


Now have to ask what is quicker

Select case or if else end if?
by Gablea
Nov 01, 2018 20:53
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 5121

Re: Where have I gone wrong

I have found the problem on my code i was using Dim PasswordChange As Integer = *row[4] but it was returning the value of 48. so I used the Val() Function and it works fine now This is my new code Dim SQLQuery As String Dim db As MYSQL Ptr Dim res As Integer Dim restab As mysql_res Ptr Dim row As my...
by Gablea
Oct 31, 2018 7:09
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 5121

Re: Where have I gone wrong

That sounds like a good idea and then use a small app that runs in the background to do the syncing

I will look into this once I can get the cashier sign on to work.

It shows the server information and then does nothing.
by Gablea
Oct 30, 2018 10:14
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 5121

Re: Where have I gone wrong

Most EPoS systems I have seen do have a offline mode

But maybe I should get the system working first before I start to add new functions (unless I can get it to keep the local data in sync with the main database server)
by Gablea
Oct 29, 2018 21:39
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 5121

Re: Where have I gone wrong

lol yea I know what you mean but I have most of the code working in the VB version so it would not be hard to convert once I get the link working with MySQL
by Gablea
Oct 29, 2018 21:08
Forum: General
Topic: Where have I gone wrong
Replies: 192
Views: 5121

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: 5121

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

Go to advanced search