Skip to content

Correspondencia bigInt en VB.2008

December 29, 2011

El ipi bigInt en SQL Server, corresponde al tipo sqlInt64 en VB.2008, cuando queremos recuperar un registro de la BBDD, por ejemplo:

Try

Dim sSQL As String = “SELECT MAX(id) AS expr1 “ & _

“FROM MAD_FitxadesRFID”

Dim idReader As SqlDataReader = New SqlCommand(cmdText:=sSQL, Connection:=g_cn).ExecuteReader()

With idReader

While .Read()

idIncr = ((Trim(.GetSqlInt64(0))))

End While

End With

idReader.Close()

Catch

MsgBox(Err.Number & ” “ & Err.Description, vbOKOnly, “ERROR”)

Exit Sub

End Try

From → Datos

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: