Search found 3 matches

by Bushbug
Friday 09th November 2018 2:38pm
Forum: General
Topic: Record not found problem
Replies: 4
Views: 211

Re: Record not found problem

Hi Stevedee,
I have solved the problem by changing the: If DataResult.Index = -1 to <> -1 and placing the Else part after the process. It then works perfectly.
Thank you for your interest and inspiration.
Kind regards,
Frank
by Bushbug
Friday 09th November 2018 11:55am
Forum: General
Topic: Record not found problem
Replies: 4
Views: 211

Re: Record not found problem

Thank you for the prompt reply Stevedee. Here is the full coding for the particular event. (txtASLNo_LostFocu()) Public Sub txtASLNo_LostFocus() Dim sASLNo As String Dim sSQLData As String Dim $rSQLData As Result Dim iLen As Integer Dim sAppName As String Dim sASLType As String Dim sOpsName As Strin...
by Bushbug
Thursday 08th November 2018 7:56pm
Forum: General
Topic: Record not found problem
Replies: 4
Views: 211

Record not found problem

I am new to using Gambas and am thrilled with it. However, I have run into a problem. I have written a program that contains a textbox into which one enters a unique licence number (ASLNo) eg. 00001. Once the textbox (txtASLNo.Text) loses focus a SQL statement looks for the record associated with th...