Using Foxpro 2.6 or 6.0 free tables

07-11-2003, 12:00 AM
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


Re: Using Foxpro 2.6 or 6.0 free tables

07-14-2003, 12:00 AM
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
>
>