` Printed Icetips Article

Icetips Article

SQL Related Articles: Clarion dates to SQL
2002-07-06 -- Mark Mcbreen

Newsgroups: softvelocity.products.c55ee


In your dictionary make sure you have the SQL date defined correctly & that
should work OK.
e.g. for MSSQL something like this
MySQLDateTimeField    STRING(8) !This corresponds to MSSQL datetime
MyGroup    GROUP,OVER(MySQLDateTimeField)
  SQLFileDateField  DATE
  SQLFileTimeField  TIME
END

MyGroup.SQLFileDateField  =  TPSFile:DateField
MyGroup.SQLFileTimeField  = 0
PROP:SQL = 'INSERT MYTable (MySqlDateTime) VALUES(' & MySQLDateTimeField   & ')'

Regards

"Suntower Systems"  wrote in message
news:3d25d919@news.softvelocity.com...
> Converting a large app with LOTS of TPS dates (LONGs).  Can someone
provide
> some guidance on how to convert these into SQL date fields?
>
> Can the TPS ---> SQL conversion program simply assign the data in TPS
format
> to the new SQL date field as below?
>
>                 SQLFile:DateField  =  TPSFile:DateField
>                 PUT(SQLFile)
>
> ---Thanks,
>
> ---JC
>
>

Printed May 5, 2024, 4:36 am
This article has been viewed/printed 35124 times.
Google search has resulted in 54 hits on this article since January 25, 2004.