http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #8 by Safiur RAHMAN:
Yes it works now. Thanks
--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Benoît MINISINI changed the state of the bug to: Fixed.
--
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #7 by Benoît MINISINI:
In revision #7506, I have implemented the following convention:
Gambas date/time values with only the time part are stored in the PostgreSQL
database using the minimum date it accepts, i.e. '4713-01-01
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Benoît MINISINI changed the state of the bug to: Working.
--
___
Gambas-user mailing list
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #5 by Benoît MINISINI:
Is it possible for you to test revision #7454 and tell me if it fix the problem?
--
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #6 by Safiur RAHMAN:
Hello
I get following error:
Cannot create record: ERROR: invalid input syntax for type timestamp:
"12:52:00"
LINE 1: INSERT INTO "tblimage" ( "fldtime" ) VALUES ( '12:52:00' )
I think inserting time
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #4 by Benoît MINISINI:
The error seems logical, as "-00-00" is not a valid date, but nothing
changed in the postgresql
driver for a long time! So I guess that "-00-00" was supported before...
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Safiur RAHMAN reported a new bug.
Summary
---
Unable to Insert Time value in postgresql database
Type : Bug
Priority : High
Gambas version : 3.8
Product : PostgreSQL driver
Description
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Safiur RAHMAN added an attachment:
imagedatabase.tar.gz
--
___
Gambas-user mailing list
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #3 by Safiur RAHMAN:
Hi
When I create Postgresql database using
hTable = $newCon.Tables.Add("tblimage")
hTable.Fields.Add("fldid", db.Serial)
hTable.Fields.Add("fldtime", gb.Date)
hTable.PrimaryKey = ["fldid"]
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #2 by Safiur RAHMAN:
Hi
I use postgresql version 9.3 available in Ubuntu 14.04 official repository.
The Error.Text is:
Cannot create record: ERROR: date/time field value out of range: "-00-00
10:14:00"
LINE 1: INSERT
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Safiur RAHMAN added an attachment:
imagedatabase.tar.gz
--
___
Gambas-user mailing list
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Benoît MINISINI changed the state of the bug to: Waiting.
--
___
Gambas-user mailing list
http://gambaswiki.org/bugtracker/edit?object=BUG.829=L21haW4-
Comment #1 by Benoît MINISINI:
Please tell me which version of PostgreSQL server you use, and which error
message you get exactly. Thanks!
--
14 matches
Mail list logo