Discussions under Tips and Techniques

Setting Parameter Values on a Built (Compiled) Statement

first post: rhenry74 wrote: private void btSave_Click(object sender, EventArgs e) { strin...

Column Names Must be Prefixed...

first post: rhenry74 wrote: ...by the table name if the statement involves more than one table....

Using DbLite from C#

first post: rhenry74 wrote: Reference DbLite and vjslib private void RefreshDiaryEn...

You can Update or Delete Only the First Matching Row

first post: rhenry74 wrote: If you know a row ID is unique, this can save time. update firs...

Syntax Supports Simultanious Inserts into Multiple Tables

first post: rhenry74 wrote: insert into Product, TimeCard (Product.Amount, TimeCard.Hours, Pr...

SQL-like Syntax

first post: rhenry74 wrote: $ - stands for comparison and can be =, , = or != | - stands for ...

  • 1-6 of 6 discussions
    • Previous
    • 1
    • Next
    • Showing
    • All
    • discussions