General information
Title:
Cursor field datatype
Hello
I have table in my database which has many date fields. Of which two are dupdate and dcreate where
dupdate = datetime(2000,10,10,12,00,00)
dcreate = datetime(2000,10,01,12,00,00)
This program works with different backends such as VFP, MSSQL, Oracle, Sybase
If I use a view I can change the datatype property to 'D' as the datatype on the server is datetime by using the following command where v_cust is the viewname.
dbsetprop('v_cust.dcreate','field','datatype','D').
Expression 'v_cust.dupdate - v_cust.dcreate' returns me the value of 10 (10 days)
If I use a SPT cursor I can't change the datatype to 'D' which is type 'T' in the database.
Expression 'v_cust.dupdate - v_cust.dcreate' returns me the value of 777600 (777600 seconds).
So my problem is : (I want to get the difference in number of days when using the SPT cursor but the modification I want to do is on the cursor and not the expression used.)
Is there a way to change the datatype of a field in the cursor?
Is there any other simple way to tackle this problem?
I can put some code before/after the creation of the cursor to solve this problem but I don't want to change the code where the comparision is used.
Thanks
Ajay
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only