Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: error en Select odbc firebird

  1. #11
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,661
    Por ejemplo:

    Code:
    // TYPE("employees_calendar.eventstart") = "T" 
    lc = SQLCONNECT("Lianja_Southwind")
    m_datetime = TTOC(DATETIME(),1)
    ? SQLEXEC(lc,"select * from employees_calendar where eventstart < stot(?m_datetime)")
    SQLDISCONNECT(lc)
    
    // TYPE("orders.orderdate") = "D"
    lc = SQLCONNECT("Lianja_Southwind")
    m_date = DTOS(DATE())
    ? SQLEXEC(lc,"select * from orders where orderdate < stod(?m_date)")
    SQLDISCONNECT(lc)

  2. #12
    Member
    Join Date
    Feb 2015
    Posts
    36
    this is ok:

    Xfini = DTOS(FINI)
    Xffin = DTOS(FFIN)
    myselect="SELECT * FROM FACTDIG WHERE FCHFACTURA>= stod(?XFINI) AND FCHFACTURA<= stod(?XFFIN) ORDER BY FACTDIG.FCHFACTURA"

    thanks an regards

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us