• Blog Home
  •     
  • BTR2SQL Blog
  •     

Posts Tagged ‘Stored Procedure’

Calling a Stored Procedure Passing and Receiving a Date

Monday, February 18th, 2008

The DataFlex date format isn’t compatible with MS SQL. You must to change the way as argument is passed and/or is received.

Take a look at this sample program. You may see that the variable is declared as a string, but should be date. I’m changing the date format before call stored procedure:

(more…)

Tags: Stored Procedure
Posted in Code Examples, Flex2SQL | No Comments »

Search

  • Recent Posts

    • Working with new SQL Server 2008 data types
    • New Feature: Lazy Open Mode
    • Custom OEM to ANSI Translation
    • Case handling
    • Blob Handling in DataFlex with Mertech’s Drivers
  • Recent Comments

    • Archives

      • October 2011
      • September 2011
      • August 2011
      • June 2011
      • May 2011
      • February 2011
      • September 2010
      • May 2010
      • April 2010
      • March 2010
      • January 2010
      • September 2009
      • August 2009
      • June 2009
      • May 2009
      • April 2009
      • March 2009
      • February 2009
      • March 2008
      • February 2008
    • Categories

      • Code Examples
      • Current Releases
      • DataFlex
      • DB2
      • DBMS
      • Development Tools
      • Error Messages
      • Flex2SQL
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Tools
    • Subscribe

      • RSS 2.0
    • Tags

      10.1 Data Model Add new tag backups Connection current driver releases Embedded SQL Linux LOB Locking Migration MS SQL Performance Tips Reports Restructuring Sessions Stored Procedure Triggers Tuning
    Opening doors to new business!
    home about us | contact | Terms of Use | site map privacy
    © 2009 Mertech Data Systems, Inc.