Paging is one of themost needed tasks when developers are developing applications. SQL Server hasintroduced various features of SQL Server 2000 to the latest version of SQLServer 2012. Here is the blog post which I wrote which demonstrates how SQL ServerRow Offset and Paging works in various versions of the SQL Server. Instead ofgiving the generic algorithm, I have used AdventureWorks database and build ascript. This will give you better control over your data if you have installedthe AdventureWorks database and you can play around with various parameters.The goal is toretrieve row number 51 to 60 from the table Sales.SalesOrderDetails of database AdventureWorks. Compile project VB6 menggunakan Windows 7 SP1 kadang menimbulkan error saat dijalankan di Windows XP.

1. Visual Basic Project Ideas

Hal ini disebabkan karena ADODB di Windows 7 SP1 tidak compatible dengan Windows XP dan akan muncul ' Runtime Error 430 - Class Does Not Support Automation or Does Not Support Expected Interface'.Untuk dapat meng-compile project VB6 di Windows 7, berikut langkah-langkahnya:. Buka Folder%ProgramFiles%Common FilesSystem. Untuk Windows 64bit buka folder%ProgramFiles(x86)%Common FilesSystem. Set permission folder 'ado' menjadi owner dan permission menjadi read/write. Buka folder 'ado'. Rename file ' msado27.tlb' menjadi ' msado27new.tlb'.

Rename file ' msado28.tlb' menjadi ' msado28new.tlb'. Cari file ' msado27.tlb' dari komputer Windows 7 (Bukan SP1) atau anda bisa dapatkan. Copy file ' msado27.tlb' ke folder 'ado' di Windows 7 SP1. Duplikat file ' msado27.tlb' dan rename menjadi ' msado28.tlb'.

Visual Basic Project Ideas

Restart SystemIni sudah saya coba dan berhasil.Semoga berguna.