` Comment on an Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Add a comment to an Icetips Article

Please add your comments to this article. Please note that you must provide both a name and a valid email address in order for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!

Your Name:  
Email:  
Header text/Subject:  

Please enter your comment in the box below:
Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

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 > >

Today is May 5, 2024, 12:49 pm
This article has been viewed 35125 times.
Google search has resulted in 54 hits on this article since January 25, 2004.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription