Anonymous user
Simple database: Difference between revisions
→{{header|Run BASIC}}
Line 1,522:
clientDate$ = trim$(#clientDate contents$())
category$ = trim$(#category contents$())
dbVals$ = clientNum;",'";name$;"','";clientDate$;"','";category$;"'"
sql$ = "INSERT into client
#sql execute(sql$)
goto [sho]
Line 1,536:
' ------------------------------------
' Select by category - Last date only
' ------------------------------------
[lastCat]
sql$ = "SELECT *
WHERE client.
FROM client as c WHERE c.category = client.category)
ORDER BY category"
| |||