Search found 6 matches
- Sunday 23rd August 2020 9:23am
- Forum: General
- Topic: Retrieving dates from SQLIte
- Replies: 4
- Views: 4168
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...
- Saturday 22nd August 2020 8:09am
- Forum: General
- Topic: Retrieving dates from SQLIte
- Replies: 4
- Views: 4168
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 = ...
- Friday 21st August 2020 6:27pm
- Forum: General
- Topic: Retrieving dates from SQLIte
- Replies: 4
- Views: 4168
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...
- Friday 9th November 2018 2:38pm
- Forum: General
- Topic: Record not found problem
- Replies: 7
- Views: 9329
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
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
- Friday 9th November 2018 11:55am
- Forum: General
- Topic: Record not found problem
- Replies: 7
- Views: 9329
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...
- Thursday 8th November 2018 7:56pm
- Forum: General
- Topic: Record not found problem
- Replies: 7
- Views: 9329
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...