[Gambas-user] Database Date fields

Steven Lobbezoo steven at ...1652...
Sat Mar 31 21:18:53 CEST 2007


Sorry, just found it.
I suppose I should think better before I write.
(Just used Val(Datestring), and all is well.)

I would verry much support the idea from an other mail to this list, to 
construct an index to the documentation, sometimes it's hard to find an item.

Steven


Le samedi 31 mars 2007 20:49, Steven Lobbezoo a écrit :
> Hi all,
>
> I have some date type fields in an MySQL database table.
> If I Update the directly (with db.exec) I can write them directly from a
> text control in a form. As long as the format entered is somewhat like date
> it's acceptable (12/2/2007 or 2.3.07 or ... whatever).
>
> Now, I started using gambas db.edit method, with db.update.
> Date fields are not accepted anymore.
> Whatever I do, gambas says : expected date, got string instead!
>
> Is this a bug, or what do I do with my textfield to convert it to an
> acceptable date (I did nout find any functions to do that , of course it's
> possible to write such a function, but why re-inventing the wheel ?)
>
> Steven
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user




More information about the User mailing list