home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 May / CMCD0504.ISO / Software / Shareware / Programare / turboVB / TurboVB.chm / contents / sqlformatter.gif < prev    next >
Graphics Interchange Format  |  2004-03-23  |  11.3 KB  |  617x538  |  8-bit (51 colors)
   ocr: SQL Formatter X File Help Options Declare Variable strSql Line Length: 70 Line Continuation Double Quotes to Single Quotes SELECT InvoiceNo, SupplierNo, SupplierName, SupplierTelNo FROM blinvoices I, tblsuppliers S WHERE InvoiceNo= 32432. AND SupplierNo = S.SupplierNo Dim strSql. As String strSql == "SELECT InvoiceNo, SupplierNo, SupplierName, SupplierTelNo FROM I &"tblinvoicesl I, tbiSuppliers S WHERE InvoiceNo == 32432 AND .SupplierNo". &"-S.SupplierNo" Format SQL Close