| |
|
support.dcube.vfp
Started by webadmin@datadynamics.com at 07-11-2003 12:00 AM. Topic has 1 replies.
  
|
|
Sort Posts:
|
|
|
|
 07-11-2003, 12:00 AM
|
webadmin@datadynamics.com
Joined on 12-12-2005
Posts 0
|
Using Foxpro 2.6 or 6.0 free tables
|
|
|
|
|
Originally Posted By: farid<farid1234567890@kedaung1234567890.com>
Hi All,
I'm trying to use Dynamicube with Foxpro free tables using DAO and ADO. So
far so good, except it's faild to load time series data. What are the
template for parsing date type data into Year, Qtr, Month?
Please help
Thanks
|
|
|
|
|
Report
|
|
|
|
|
07-14-2003, 12:00 AM
|
webadmin@datadynamics.com
Joined on 12-12-2005
Posts 0
|
Re: Using Foxpro 2.6 or 6.0 free tables
|
|
|
|
|
|
Originally Posted By: Lucas \(DD\)<dynamicube.support@datadynamics.com>
Farid,
Thanks for the feedback. This is really dependant on the FoxPro free table
syntax. Depending on your provider, the time series information varies. You
might find out how to extract a specific month/day/year from a table using
SQL specific syntax of your provider.
Example:
Oracle ---> select to_char(mydate,'MM') MyMonth from mytable
SQL Server ---> select datepart(month,mydate) MyMonth from mytable
MS Access ---> select datepart("m",mydate) as [MyMonth] from mytable
FoxPro Free Tables ---> select MONTH(mydate) from mytable
I hope this information has helped.
Lucas
DD Support
"farid" wrote in message
news:E83xn%231RDHA.1360@dynaweb.datadynamics.com...
> Hi All,
>
> I'm trying to use Dynamicube with Foxpro free tables using DAO and ADO. So
> far so good, except it's faild to load time series data. What are the
> template for parsing date type data into Year, Qtr, Month?
>
> Please help
>
> Thanks
>
>
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Forum Archives » support.dcube.v... » Re: Using Foxpro 2.6 or 6.0 free tables
|
|
|
|
|