the fbdtos (and the other) function doesnt work too...
doesnt those function just convert to a string with the format '2005/01/01' or
'2005-01-01'..?
as i've pointed out earlier i've tried all sort of string format for the date and none works..i'm beginning to think that the problem may be with odbc, or firebird or the VFP version (version5) that i'm using? But isnt it if i use sql pass-thorough it shouldnt matter what version of VFP im using since i just pass the command to the back-end? How does the firebird documentation say about this? it's odd that while firebird is free, the documentation is not and its so very very scarce..and the issue i have with the date is such a simple one. just the date format. i've successfully connected to firebird and successfully inserted records into it from within VFP as long as i dont insert date values..so the problem is really how firebird wants to accept the date..