• 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

    • CL2SQL: Command Line Tool for Unattended Migration
    • DF_TEXT data type mapping in Flex2SQL – performance considerations
    • Current Driver Releases
    • NULL Handling
    • Multiple embedded SQL statements
  • Recent Comments

    • CL2SQL: Command Line Tool for Unattended Migration « Mertech Flex2SQL Tech Blog on Write Your Own Migration Routines Using the CONVERT_DAT_FILE Macro
  • Archives

    • 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

    Add new tag 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.