Search found 1049 matches

by Gablea
May 14, 2010 18:53
Forum: General
Topic: Read in CSV Data file
Replies: 5
Views: 1030

Read in CSV Data file

Hi all, I am trying to make a database for a EPoS applciaton and I want to read in the csv file from my SQL Server. I am not sure how to read this in and save it to a RANDOM database file that is made by FreeBasic (as I have given up trying to get it to work with the QuickBasic version of the databa...
by Gablea
May 10, 2010 16:07
Forum: General
Topic: Database error
Replies: 23
Views: 1671

Well I have managed to make it FIND the barcode with this code SUB FindProduct Dim Found As String FileNumber = FREEFILE Found = "No" Open PathToProductDatabase FOR RANDOM AS #FileNumber Len = Len(ProductRecord) RecNo = 0 Do WHILE NOT EOF(FileNumber) RecNo = RecNo + 1 Get #...
by Gablea
May 10, 2010 14:55
Forum: General
Topic: Database error
Replies: 23
Views: 1671

er ok that has totally confused me :)
by Gablea
May 10, 2010 1:00
Forum: General
Topic: Database error
Replies: 23
Views: 1671

I have sorted the cashier part now :) BUT I am having problems with finding products (as seeing it is a EPoS system that does help) This is my code I am using for the product find SUB FindProduct Dim Found As String FileNumber = FREEFILE Found = "No" Open PathToProductDatabase FOR RANDOM A...
by Gablea
May 09, 2010 20:12
Forum: General
Topic: Database error
Replies: 23
Views: 1671

I have changed it to string and using ValInt(CashierRecord.CashierNumber) = ValInt(CashierNumber) it works but now when a error happens (say the passwords do not match It will not redraw the screen) is there something I need to send to refresh the screen? I am using CLS to do it and it works the fir...
by Gablea
May 09, 2010 13:26
Forum: General
Topic: Database error
Replies: 23
Views: 1671

Yes I am use to Visual Basic 6 so FB is new to me as well

Most of what I am reading and doing is thanks to my good freind MysticShaddows.

if anyone else has any idea's what i can try I am open to all idea's

Andy
by Gablea
May 08, 2010 21:13
Forum: General
Topic: Database error
Replies: 23
Views: 1671

Well The database that is created WORKS perfetly fine with the old QBasic version of the FreeBasic software

SO any ideas why the QB version works with the database BUT the FB version does not? and it is the same database
by Gablea
May 08, 2010 20:57
Forum: General
Topic: Database error
Replies: 23
Views: 1671

I agree that you version works well SOO what could be wrong with mine? This is the global declare Common Shared CashierNumber As Integer Common Shared CashierPassword As Integer if seeing my complete application would help I can e-mail a zip (send me a email to andrew DOT gable at tesco DOT net)
by Gablea
May 08, 2010 18:11
Forum: General
Topic: Database error
Replies: 23
Views: 1671

I've just tried that and nothing :( This is the code that is being used in the VB6 application to make the databases for the FreeBasic app Type CashierData CashierNumber As Integer CashierPassword As Integer CashierPoSName As String * 20 CashierRecName As String * 20 CashierAccess As String * 26 Cha...
by Gablea
May 08, 2010 17:18
Forum: General
Topic: Database error
Replies: 23
Views: 1671

Database error

Hi all, I seem to be having a problem retreving data again from the database I enter the user ID (see bellow for the screen shot http://homepages.tesco.net/andrew.gable/singon1.JPG And when It looks for it in the database I get a error saying not found so I put some print commands in to show me what...
by Gablea
May 08, 2010 2:10
Forum: General
Topic: How can I space the boxes evenly
Replies: 8
Views: 615

yea
I just used the same line and removed the F at the end :)
by Gablea
May 08, 2010 1:11
Forum: General
Topic: How can I space the boxes evenly
Replies: 8
Views: 615

It's ok I sorted it :)

I simply placed a black border around the box :)
by Gablea
May 08, 2010 0:19
Forum: General
Topic: How can I space the boxes evenly
Replies: 8
Views: 615

if I wanted to put a gap between each one what would I need to ajust?

The gap would be at the top boxes 2-7
by Gablea
May 07, 2010 23:48
Forum: General
Topic: How can I space the boxes evenly
Replies: 8
Views: 615

ophelius,

all I can say is THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU THANK-YOU

THAT was starting to get me down :)
by Gablea
May 07, 2010 22:50
Forum: General
Topic: Can someone spot the error
Replies: 17
Views: 1387

I have changed what you said and it is still saying CASHIER NOT FOUND. This is Really startiung to get me down :( I have been working on this now for a week If I am having problems with the cashier sign on I asume I will have problems with all the other databases as well (as they was made from VB an...

Go to advanced search