Clarion Community

Search Sort Posts:  Oldest to newest Newest to oldest

07-16-2008, 3:03 AM dEraCh2000 Joined on 04-30-2008 Sarajevo, B&H Posts 11 MSSQL datetime column Hello, Is there a way to read in a browse only the time portion of the datetime column, since it's defined as a time @t7 column in the dictionary.... Regards    Report

07-18-2008, 11:59 PM Shankar Joined on 10-24-2005 Dubai, UAE Posts 219 Re: MSSQL datetime column Hi! If you have defined the DateTime column in the dictionary the proper way i.e. DateTimeColumn     STRING(8),NAME('DateTime') DateTimeGroup      GROUP,OVER(DateTimeColumn) DateColumn           DATE TimeColumn           TIME                    END there should NO problem displaying only TimeColumn in the Browse. However, if you try to sort the data on that column it will always sort by Date/Time. Regards Shankar    Report

07-19-2008, 8:43 AM dEraCh2000 Joined on 04-30-2008 Sarajevo, B&H Posts 11 Re: MSSQL datetime column Hi, I'v managed to get the time out of the datetime column yesterday. I imported the table from the database and I got the right definition in the dictionary, just like you posted. There is no problem if it sorts  by Date/Time since I an using this to mark the time of any actions taken by the application user. Thanks for the reply Kind regards       Report

Clarion Communi... » Clarion » Clarion 6 - Gen... » MSSQL datetime column

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Clarion |- Clarion Language and Runtime Library |- Databases and Drivers |- Clarion 6 - General Clarion.Net |- General