With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
(where Array(10,"ABC") represents an Array of Variants the way the VBScript would)
Cmd.Connection = Conn Cmd.CommandText = "SELECT * FROM TABLE WHERE FIELD1 = ? AND FIELD2 = ?" Set RS = Cmd.Execute(RecordsAffected,Array(10,"ABC"))
But this is not valid code (you can not assign an array of variants to the Cmd Parameters).
Cmd.CommandText = "SELECT * FROM TABLE WHERE FIELD1 = ? AND FIELD2 = ?" Cmd.Parameters = Array(10,"ABC") RS.Open(Cmd, adOpenDynamic, adLockPessimistic)
|combining condition to rerun if failure within BEGIN..END||27||87|
|Recommendation vb6 to vb.net or others||14||112|
|Update in Sql||7||30|
|Linking a DMV to a database id/sql text in SQL server 2008||8||48|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!