Simple database: Difference between revisions
Content added Content deleted
Line 1,557: | Line 1,557: | ||
print what$ |
print what$ |
||
html "<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>" |
html "<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>" |
||
html "<TR align=center><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR>" ' heading |
html "<TR align=center bgcolor=wheat><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR>" ' heading |
||
#sql execute(sql$) |
#sql execute(sql$) |
||
WHILE #sql hasanswer() |
WHILE #sql hasanswer() |
||
Line 1,588: | Line 1,588: | ||
---- Last Entry ----<br /> |
---- Last Entry ----<br /> |
||
<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0> |
<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0> |
||
<TR align=center><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR> |
<TR align=center bgcolor=wheat><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR> |
||
<TR><TD align=right>5</TD><TD>Dawnridge Winery</TD><TD>2008-06-18 22:16</TD><TD>wine</TD></TR></TABLE> |
<TR><TD align=right>5</TD><TD>Dawnridge Winery</TD><TD>2008-06-18 22:16</TD><TD>wine</TD></TR></TABLE> |
||
---- Last category Sequence ----<br /> |
---- Last category Sequence ----<br /> |
||
<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0> |
<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0> |
||
<TR align=center><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR> |
<TR align=center bgcolor=wheat><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR> |
||
<TR><TD align=right>1</TD><TD>Home Sales</TD><TD>2012-01-01 10;20</TD><TD>broker</TD></TR> |
<TR><TD align=right>1</TD><TD>Home Sales</TD><TD>2012-01-01 10;20</TD><TD>broker</TD></TR> |
||
<TR><TD align=right>4</TD><TD>Back 40 Equipment</TD><TD>2009-09-18 20:18</TD><TD>farm</TD></TR> |
<TR><TD align=right>4</TD><TD>Back 40 Equipment</TD><TD>2009-09-18 20:18</TD><TD>farm</TD></TR> |
||
Line 1,602: | Line 1,602: | ||
---- Date Sequence ----<br /> |
---- Date Sequence ----<br /> |
||
<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0> |
<TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0> |
||
<TR align=center><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR> |
<TR align=center bgcolor=wheat><TD>Client<br>Num</TD><TD>Name</TD><TD>Client<br>Date</TD><TD>Category</TD></TR> |
||
<TR><TD align=right>5</TD><TD>Dawnridge Winery</TD><TD>2008-06-18 22;16</TD><TD>wine</TD></TR> |
<TR><TD align=right>5</TD><TD>Dawnridge Winery</TD><TD>2008-06-18 22;16</TD><TD>wine</TD></TR> |
||
<TR><TD align=right>4</TD><TD>Back 40 Equipment</TD><TD>2009-09-18 20:18</TD><TD>farm</TD></TR> |
<TR><TD align=right>4</TD><TD>Back 40 Equipment</TD><TD>2009-09-18 20:18</TD><TD>farm</TD></TR> |