In the first box, put details of a table,
e.g.
UserId, Long
UserName, String
Password, String
etc...
Then use patterns like this:
Dim _$1 as $2
and
_$1 = .Item("$1")
or
isNull($1,0) as '$1',
'secretGeek' on Thu, 28 Apr 2005 21:34:36 GMT, sez:
Create property Getters and Setters with this pattern:
Public Property $1() As $2
Get
Return _$1
End Get
Set(ByVal Value As $2)
_$1 = Value
End Set
End Property
(Where the first box has, for example:
UserId, Long
UserName, String
)
'secretGeek' on Thu, 28 Apr 2005 22:17:11 GMT, sez:
Pattern for generating Insert statements from data:
Insert into tblMasterCombo (TypeID, Binary, Description) values('$1',$2,'$3')
'Strikes' on Fri, 29 Apr 2005 07:28:23 GMT, sez:
Very handy. Thanks for that.
Also, have you seen QuickCode?: http://www.dvxp.com/en/QuickCode.aspx.
To use your default $1 loves $2 pattern, "I,Quickcode"... Man does it save me some time...
'blameMike' on Fri, 29 Apr 2005 09:38:11 GMT, sez:
Select
:foreach
h1.$1 as '1:$1', h2.$1 as '2:$1',
:end
from $Table h1
inner join $Table h2
on h1.$matchcol = h2.$matchcol
where h1.$keycol <> h2.$keycol
and
h1.$timecol > h2.$timecol
'Paul Stovell' on Fri, 13 May 2005 02:23:43 GMT, sez:
I needed to add columns to 90+ tables in a database but ignore others. I ran sp_tables, copied the list of table names as the input, and used
alter table $1
add [columnName] datetime not null
As the pattern. Woohoo!
'Harry' on Fri, 17 Jun 2005 17:50:42 GMT, sez:
--------------------------
string,Username
string,Password
long,ID
--------------------------
private $1 m_$2;
public $1 $2
{
get {return m_$2;}
set {m_$2 = value;}
}
--------------------------
private string m_Username;
public string Username
{
get {return m_Username;}
set {m_Username = value;}
}
private string m_Password;
public string Password
{
get {return m_Password;}
set {m_Password = value;}
}
private long m_ID;
public long ID
{
get {return m_ID;}
set {m_ID = value;}
}