1 Konuyu açan huseyino

  • huseyino
  • Üye
  • Offline
  • Yer: New York
  • Kayıt Tarihi: 09.10.2006
  • İleti: 24

Konu: MS Access ten Tarih bilgisi okuma

Merhaba,

MS Access te DATETIME formatta bir alani okuyup kontrol edebilmem lazim. Fakat herhangi bir sekilde buyuktur kucuk tur gibi karsilastirma yapamiyorum.


1- Access ten SP ile bilgi alirken nasil tarih kontrolu ile alabilirim (su tarihler arasi gibi)
2- ve Access in icindeki Query i nasil parametrik calistirabilirim. (Su tarihteki islemler gibi)

dbConnection=SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\partner.mdb;Uid=;Pwd=;')

m.StartDate = datetime()

sSQL = "Select datevalue([s1].[regdate]) AS [REGISTERDATE], " +;
        "S1.sname AS [COMPANY], " +;
        "S1.scontact AS [NAME], "+;
        "S1.saddr AS [ADDRESS1], " +;
        "S1.iizip AS [POSTCODE], "+;
        "S1.scity AS [CITY], " +;   
        "S1.sstate AS [STATE], "+;
        "FROM shipment S1"


= SQLEXEC(dbConnection, sSQL)
SQLCOMMIT(dbConnection)


Sql

2 Cevaplayan cetinbasoz

  • cetinbasoz
  • cetinbasoz
  • Uzman Üye
  • Offline
  • Kayıt Tarihi: 07.10.2006
  • İleti: 3,162

Re: MS Access ten Tarih bilgisi okuma

Visual Fox Pro
dbConnection=SQLSTRINGCONNECT('Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\partner.mdb;Uid=;Pwd=;')

 

m.StartDate = dtot(date()-30)

m.EndDate = datetime()

 

sSQL = "Select datevalue([s1].[regdate]) AS [REGISTERDATE], " +;

        "S1.sname AS [COMPANY], " +;

        "S1.scontact AS [NAME], "+;

        "S1.saddr AS [ADDRESS1], " +;

        "S1.iizip AS [POSTCODE], "+; 

        "S1.scity AS [CITY], " +;    

        "S1.sstate AS [STATE], "+;

        "FROM shipment S1"+;

" where ([s1].[regdate]) between ?m.StartDate and ?m.EndDate"

 

 

SQLEXEC(m.dbConnection, m.sSQL)

cetinbasoz's Website