Search found 6 matches

by Bushbug
Sunday 23rd August 2020 9:23am
Forum: General
Topic: Retrieving dates from SQLIte
Replies: 4
Views: 4125

Re: Retrieving dates from SQLIte

Good morning Quincunxian. Thank you for pointing me in the right direction. I deleted some records in the database table and re-saved them. Then the program worked perfectly. Obviously some date data in the specific table had somehow become corrupted. Your assistance is greatly appreciated. Now I ju...
by Bushbug
Saturday 22nd August 2020 8:09am
Forum: General
Topic: Retrieving dates from SQLIte
Replies: 4
Views: 4125

Re: Retrieving dates from SQLIte

Thank you very much for your response Quincunxian. In reply to your questions: 1. The mode of the Datebox is set to Dateonly. 2. I am using a variable "dPurchase" which is declared as a Date. (Dim dPurchase As Date) 3. I am applying the returned value directly from the query. (dPurchase = ...
by Bushbug
Friday 21st August 2020 6:27pm
Forum: General
Topic: Retrieving dates from SQLIte
Replies: 4
Views: 4125

Retrieving dates from SQLIte

I have a program that requires retrieving a date from SQLite3 and placing the value into a datebox. When I run the Select statement "SELECT PDate FROM TableName WHERE Registration = "PJA NA" in SQLite itself (Execute SQL), it returns the correct date as shown in the specific field. Ho...
by Bushbug
Friday 9th November 2018 2:38pm
Forum: General
Topic: Record not found problem
Replies: 7
Views: 8985

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 9th November 2018 11:55am
Forum: General
Topic: Record not found problem
Replies: 7
Views: 8985

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 8th November 2018 7:56pm
Forum: General
Topic: Record not found problem
Replies: 7
Views: 8985

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...